View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Wood[_2_] Brad Wood[_2_] is offline
external usenet poster
 
Posts: 1
Default Can't get connection string right

-----Original Message-----
When I set the connection string of an ADODB.Connection

to
this and try to run a command, I get the error
message, "Requested operation requires an OLE DB Session
object, which is not supported by the current provider"


Just to terminate my own post:
I don't know what the heck; I was adding messages in my
code so I know the code was running. I had the ADO code
in the event handler for a hyperlink, and it would never
work. Next thing you know, I hit F5 in the VBA window and
the code ran and worked (added a record to a database). I
then clicked the hyperlink and it worked there too.