dbdrivernoprompt connection problem

[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!!

 

[stoppal]

PLEASE HELP

 

[stoppal]

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

 

[stoppal]

PROBLEM SOLVED!