Cannot Connect to Database - OLE DB Session Object?

Feb 24, 2010 2 Replies

Text of the error message:



----- Store Operations Business Rules



Error #3079 Requested operation requires an OLE DB Session Object, which is not supported by the current provider. (Source: ADODB.Command) Update TimeCard SET TimeOut = GetDate(), Hours = DateDiff(mi, TimeIn, GetDate()) / 60.0 WHERE ID = ?



-----



This only happens at one of my five stores, and only on my laptop. Nobody else is having any trouble connecting to any database, and my laptop can connect to the other four stores and HQ without issue.



Anybody got any ideas?


Hey Tom! How are you - aside from your db connect issue...

I have seen this before and can't exactly recall what the cause was, but I think mine was related to a custom receipt I had and related to the trx tables. The only thing I can see paired off with a time card stamp would be either a custom report or a crystal rpt. Maybe if you take all of your reports out of your directory, then try to connect, see what happens... I am pretty sure I had to edit my receipt in order for me to get past my error.

Unrelated note: Do you know if QB10 will integrate w/ 2.0? I hit a massive road block when doing this yesterday. No issues integrating past QB versions w/ 2.0, but now that all we can get is QB10 - it will not connect. I am going to throw up a post here.

Text of the error message: ----- Store Operations Business Rules

Error #3079 Requested operation requires an OLE DB Session Object, which is not supported by the current provider. (Source: ADODB.Command) Update TimeCard SET TimeOut = GetDate(), Hours = DateDiff(mi, TimeIn, GetDate()) / 60.0 WHERE ID = ? -----

This only happens at one of my five stores, and only on my laptop. Nobody else is having any trouble connecting to any database, and my laptop can connect to the other four stores and HQ without issue.

Anybody got any ideas?

-- Stop fishing for e-mail

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required