Migrating ADODB Connection to .NET

Question

What kind of connection strings are these?

DRIVER={Microsoft ODBC for Oracle};SERVER=*****;UID=*****;PWD=*****;
Driver={SQL Server};Server=*****;UID=*****;PWD=*****;Database=*****;

I'm working on migrating an application from classic ASP to .NET. In the old app, connection strings like the ones above were used with the ADODB.Connection object:

set AppDBcn = server.CreateObject("ADODB.Connection")
set AppRS = server.CreateObject("ADODB.Recordset")

I've tried using .NET's ADODB.Connection class and the OdbcConnection class to open these, but keep getting connection errors like "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" or "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied."

Am I using the wrong .NET connection classes for these types of connection strings, or is there something more sinister going on here?

Thanks!

Thit Lwin Oo · Accepted Answer · 2012-02-15 00:31:12Z

1

Reference there. Connection String for .NET

Connection String for .NET

answered Feb 15, 2012 at 0:31

Thit Lwin Oo

3,4283 gold badges22 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dylan Smith · Accepted Answer · 2012-02-15 00:31:29Z

0

var conn = new System.Data.SqlClient.SqlConnection(
             "Data Source=myServerAddress;
              Initial Catalog=myDataBase;
              User Id=myUsername;
              Password=myPassword;");

answered Feb 15, 2012 at 0:31

Dylan Smith

22.3k2 gold badges51 silver badges63 bronze badges

Collectives™ on Stack Overflow

Migrating ADODB Connection to .NET

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related