Custom Forms - ODBC/OLE DB problem

  • Thread starter Thread starter Bryan Dickerson
  • Start date Start date
B

Bryan Dickerson

I almost think that this should go into one of the ODBC/OLE forums, but
let's see what happens...

I have a custom form that I've been working on for a while to integrate some
ODBC stuff into so that it's more integrated with our main company database.
My PC runs Win2K and Office XP SP2 (haven't dl'd SP3, yet). I finally get
it ready to test on a larger scale and the first PC outside of mine that I
try it on is running WinXP (no SP2, yet) and Office 2003. In the Item_Open
event handler of the custom form, the first ADO query gets the error
message: "Requested object requires an OLE DB Session object, which is not
supported by the current provider." and then the line number that points to
the code line: "Set oCmd.ActiveConnection = oCn" (oCmd is the ADO Command
object and oCn is the ADO Connection object). I haven't done much
researching thru Google, etc., yet, 'cause the answers I get from this group
are usually much faster and more accurate.

Any ideas? Any help is, as always, greatly appreciated.

Thanx!!
Bryan
 
Update:

The real error message was hidden between (silly me!) "On Error Resume Next"
and "On Error Goto 0". When trying to open up the connection like this:
oCn.Open "File Name=Connection.udl", I get the error msg: "Driver's
SQLSetConnectAttr failed."

Does this help with any ideas?

Thanx!
Bryan
 
Nevermind. It was a stupid error on my part. <crawls back into the corner
with his tail between his legs>
 
Back
Top