[Microsoft][ODBC SQL Server Driver]Incorrect syntax near '\'

  • Thread starter Thread starter mCompany
  • Start date Start date
M

mCompany

I'm receiving this error when executing a SQL statement with the
connection string below. The exact same code works when
"server=MyServer" rather than "MyServer\MSDE1". It appears to be a
problem with the instance. Any ideas?


[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near '\'.


driver={SQL
Server};server=MyServer\MSDE1;database=Main;uid=test;pwd=abc123;Network=
dbmssocn;Connect Timeout = 60;
 
Back
Top