Connect to SQL 2000

[Guest]

I am trying to connect to a sql server 2000 database from Access 2003 using
the opendatabase method and an odbc dsn without any success.
sql server name is montagnosdv1
sql database name is cmbs
security is trusted connection
dsn name is cmbs_development

I tried several combinations for the dbname property including:
using set db = ws.opendatabase("odbc;dsn=cmbs_development,false,false)

can someone please give me the correct connection string.
Thanks

 

[Douglas J. Steele]

While a little dated, check out http://support.microsoft.com/kb/164481 I
believe it still applies. (In other words, OpenDatabase really isn't the
correct way to do this anymore, but the documentation isn't explicit about
that fact)

 

[dbahooker]

hey james you don't need a connection string

u just need to use Access Data Projectas

FILE, NEW, PROJECT EXISTING DATA

 

[Sylvain Lafontaine]

When using a connection string, the connection string must be the fourth
parameter:

set db = ws.opendatabase ("", false, false, "odbc;dsn=cmbs_development")

The database should be stored in the DSN as the default database to connect
to (this is in the third dialog window when creating the DSN) or you could
also use the first parameter:

set db = ws.opendatabase ("cmbs", false, false,
"odbc;dsn=cmbs_development")

Finally, this must be a System DSN, not an User DSN.