Keyword Not Supported: dsn 1

[hrhadin]

I have the following code in the page_load event of page Default.aspx:

Imports System.Data
Imports System.Data.SqlClient

Partial Class _Default

Protected Sub page_load(ByVal sender As Object, ByVal e As System.EventArgs)

If Not IsPostBack Then
Dim conn As New SqlConnection

conn.ConnectionString = "Dsn=Wic;uid=sa;pwd=flatfive"
End If
End Sub
End Class

When I run this code it gives me the error stated in the Subject.

The Dsn is valid. I use it to connect to SQL server often.
What am I doing wrong?

 

[TipGiver]

Dsn or Dns ?

 

[hrhadin]

Dsn. It's an ODBC Data Source

 

[TipGiver]

http://www.connectionstrings.com

 

[TipGiver]

As you say in the title, the odbc might not support dsn connection. Use an other

 

[hrhadin]

Thanks for your help TipGiver. The ConnectionString.com provided me with correct format for my string.

 

[TipGiver]

 

[ca8msm]

Ideally, you should keep the connection string in your web.config file. Place it in the appSettings section like this:

	<appSettings>
		<add key="myConnectionString" value="enter the string here"/>
	</appSettings>

and then retrieve it like this:

Dim myString As String = ConfigurationManager.AppSettings("myConnectionString")

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.