When using VB.NET 2010 to connect to SQL SERVER 2000 Database that secure with password using OLE DB we can use this following connection string:
Provider=SQLOLEDB;Data Source=<server instance name>;Password=<password>;User ID=<user>;Initial Catalog=<databaseName>
example:
Public conSql As New OleDbConnection
Public conStrSqlServer As String = “Provider=SQLOLEDB;Data Source=<server instance name>;Password=<password>;User ID=<user>;Initial Catalog=<databaseName>”
conSql.ConnectionString = conStrSqlServer
conSql.Open()
conSql.Close()
The main point if you use win 7 64 bit is don’t forget to set your debug platform to x86 or you will find an error.
Tq
Advertisements