ODBC Call Failed with complete Connect string but not with ODBC only.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a pass-through query between MS Access and an SQL Serverwith statements like

Set qdfPassThrough = dbs.CreateQueryDef("Duplicates"
qdfPassThrough.Connect = "ODBC;DATABASE=DBSQL;UID=sa;PWD=;DSN=Famous
qdfPassThrough.SQL = strQuery (i.e., the SQL statement as a string
qdfPassThrough.ReturnsRecords = Tru

Upon execution I receive the error: ODBC call failed (apparently #3151)

The odd thing is that when I reduce the Connect statement to just "ODBC;" and execute it, it will prompt me for the DSN, UID and PWD (no password) and I provide the exact same information as displayed in the long connect statement and it all works fine

I checked the client and server named pipes and TCP/IP and everything seems to be in order. What is going on here

Thanks
 
Betacon

What happens when you remove DSN=Famous from your connect string?

Ron W
Betacon said:
I have created a pass-through query between MS Access and an SQL Serverwith statements like:

Set qdfPassThrough = dbs.CreateQueryDef("Duplicates")
qdfPassThrough.Connect = "ODBC;DATABASE=DBSQL;UID=sa;PWD=;DSN=Famous"
qdfPassThrough.SQL = strQuery (i.e., the SQL statement as a string)
qdfPassThrough.ReturnsRecords = True

Upon execution I receive the error: ODBC call failed (apparently #3151).

The odd thing is that when I reduce the Connect statement to just "ODBC;"
Click to expand...
and execute it, it will prompt me for the DSN, UID and PWD (no password) and
I provide the exact same information as displayed in the long connect
statement and it all works fine.
I checked the client and server named pipes and TCP/IP and everything
Click to expand...
seems to be in order. What is going on here?
 
Back
Top