not be able to open SQLSERVER 2005 error 80040e4d
-
HI, Iam facing problem to connect Sqlserver 2005 with this connection string Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=master;DataSource=RAYALU\SQLEXPRESS iam Able to connect sqlserver 2000 with same above mentioned connection string. I need some OLEDB connection string provider which works on both SqlServer2000 and Sqlserver2005. Please Guide how to connect atleast Sqlserver2005. Thanks, Rayalu
-
HI, Iam facing problem to connect Sqlserver 2005 with this connection string Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=master;DataSource=RAYALU\SQLEXPRESS iam Able to connect sqlserver 2000 with same above mentioned connection string. I need some OLEDB connection string provider which works on both SqlServer2000 and Sqlserver2005. Please Guide how to connect atleast Sqlserver2005. Thanks, Rayalu
Look at www.connectionstrings.com[^] the problem you are having I believe is with your provider. The provider clients for Sql Server 2000 and 2005 are different.