what's wrong with this ADODB connection string to sql server 2005

Question

I'm working on populating a combobox in visual studio 2005 using vb and I'm stuck on the connection string part. I should mention i'm connecting to a SQL Server 2005 instance. Here is what i have:

Dim gDBA As ADODB.Connection
Dim records As ADODB.Recordset

gDBA = New ADODB.Connection 
gDBA.Open("Server=e-13;Database=subscribers;User ID=KViews;Password=Solution;Trusted_Connection=False;", "KViews", "Solution")

I got the connection string from http://www.connectionstrings.com/sql-server-2005#p1

When I click 'run', i get a COMException was unhandled message : "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."

I'm guessing the connection string is looking for a System ODBC driver name, however, i'm not sure where to put this. any ideas on this or what else I might be doing wrong?

thanks in advance

gbn · Accepted Answer · 2009-10-20 20:47:30Z

3

You're probably missing "Provider=SQLNCLI" or "Provider=SQLOLEDB" or "Driver={SQL Native Client}" from the conn string. The article you quoted shows 2 of these, but without SQL Native client installed you can rely on SQLOLEDB

This specifies the driver, otherwise it it derived from a DSN set via control panel. This explains the error.

edited Oct 20, 2009 at 20:47

answered Oct 20, 2009 at 20:40

gbn

434k84 gold badges602 silver badges690 bronze badges

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

Comments

koosk · Accepted Answer · 2009-10-20 20:50:54Z

1

This connection string is currently in use on an asp app connecting to Sql Server 2008 Express.

"Driver={SQL Native Client};Server=serverName;Database=databaseName;Uid=userId;pwd=password;connect timeout=60;"

answered Oct 20, 2009 at 20:50

koosk

1042 silver badges6 bronze badges

Comments

John · Accepted Answer · 2009-10-20 20:42:34Z

0

What about using "Data Source" and "Initial Catalog" instead of "Server" and "Database"?

answered Oct 20, 2009 at 20:42

John

16k10 gold badges76 silver badges114 bronze badges

Comments

Ralf de Kleine · Accepted Answer · 2009-10-20 20:42:57Z

0

If you're connecting to a SQL server try using the System.Data.SqlClient namespace.

Dim cn As New SqlClient.SqlConnection("User ID=KViews;Password=Solution;Initial Catalog=subscribers;Data Source=e-13")
cn.Open()
Dim cmd As New SqlClient.SqlCommand("Select * from tabel")
cmd.Connection = cn
Dim r As SqlClient.SqlDataReader = cmd.ExecuteReader

(SqlClient is managed code - ADODB native)

answered Oct 20, 2009 at 20:42

Ralf de Kleine

11.8k5 gold badges50 silver badges89 bronze badges

Collectives™ on Stack Overflow

what's wrong with this ADODB connection string to sql server 2005

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related