J
James
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
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