Forum Discussion

anatar02's avatar
anatar02
Contributor
12 years ago

Connecting "SQL Server doe not exists or access denied" error while connecting the SQL 2005 Express version!!!

hi team, 



i am getting an sql odbc connection eror while trying to connect the 2005 sql express!!...



the error is "ODBC SQL Server Driver ][Named Pipes]SQL Server doe not exists or access denied." 





code 




var mConnection; 


 


 mConnection=Sys["OleObject"]("ADODB.Connection");


 


  mConnection["Open"]("Driver={SQL Server};"+"Server=.\SQLEXPRESS;"+"Database=StorePos;"+ "Uid=sa;"+"Pwd=compaq1-2");


 mConnection["Execute"]("UPDATE PosMenu SET MENUID='10011' WHERE MENUID='10211'"); 






The above code is giving the issue only with Microsoft SQL Server 2005 express edition but the same times its working well and fine with sql 2005 enterprise edition