SQL OLE DB old database String. What is the new replacement string for SQL2014 or 2012??

Hello;

I has and old web application begin with windows 2000 and SQL 200. Then Windows 2003 and SQL 2005. In the 2 scenarios I change in this string the data source (server name and the password and then work fine.

Application.Lock();
Application("ConnectionString") = "Provider=SQLOLEDB;Data Source=Server1;Initial Catalog=EvaluacionesDatabase;User ID=sa;Password=xxxxxxxxx ;";
Application("Header") = ""

Now we have windows 2012R2 server and SQL server 2014. I try first change the data source and password but didn't work. Then try various strings changes but didn't work.

Did Everyone know the correct string for SQL2014??

Thanks

Vega

0 answers