dbdrivernoprompt connection problem

  • Thread starter Thread starter stoppal
  • Start date Start date
S

stoppal

I have a problem trying to link my access table using VB

I can connect using the below connection string ....

Driver={SQL
Server};SERVER=MYSERVER;UID=MYUSERNAME;PWD=myPASSWORD;DATABASE=myDATABASE;


WHEN I USE....

Set dbsODBC = OpenDatabase("",, False, strConnect)

BUT IF I try to disable the prompt using....

Set dbsODBC = OpenDatabase("", dbDriverNoPrompt, False, strConnect)

my connection either does not connect or it displays the prompt.

What am I doing wrong, and why would this be happening?

THANK YOU!!
 
PLEASE HELP!!! I REALLY NEED SOME SOLUTION, I don't know what to do. I
really need help!!
 
Back
Top