dns-less connection no prompt PLEASE HELP

G

gga

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, False, strConnect)


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


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


AND


Set dbsODBC = OpenDatabase("", dbDriverNoPrompt, False,"ODBC;" &
strConnect)


my connection either does not connect or it displays the prompt. I
think the problem has something to do with me not using a DSN, but I
thought I should be able to connect without one. PLEASE HELP!


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

I REALLY NEED A SOLUTION---PLEASE!!!!!!!!!!!!1

THANK YOU!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dbdrivernoprompt connection problem 3
Connection String to SQL Server in VBA 3
Convert ODBCDirect Codes to ADO in Access 2007 1
DAO : Can't drop Sql Server 2005 table 1
Code for DSN-Less connection not working? 1
Enabling Allowbypasskey with DB that has a password 1
Connect to Oracle via ODBC 5
DSN Less Connection 2

Top