Advertisement

1 - 1 of 1 containing alltags:("-2147467259 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified") (0.002 seconds)
 
Access Coding/Macros 1
Access Architecture/Design 1
Microsoft Access Database 1
 
 
 
Problem linking Access to SQL 2000 DSN-less
Tags: VBA \ ADO, -2147467259 [Microsoft][ODBC Driver Manager] Data source...
I am trying to link to a table in SQL 2000 from Access using the following statment: rstTest.Open strTest, "ODBC;Driver=SQL Server; Server=ServerName; Database=DatabaseName; UID=Username, Pwd=Use...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23570217.html
Zones: MS Access, ...Date Answered: 07/26/2008 Grade: A Views: 0
  • 1