Hello, I need some help with ASP.NET (I'm stlll learning it, but want to start programming so I won't forgot what I already read). I haven't got to database accessing, but for this one particular test program that I am making I need to access a SQL Server 2000 database. The way that I want to access the database is through the SYSTEM DSN, which I have already set up (and it works too, using ASP 3.0). The code that I have for the connection string is:
connectionStr = "DSN=GiLtY_DB;UID=;PWD="
but when I try to make a new connection, using this:
Dim myConnection As SqlConnection
Dim connectionStr As String
myConnection = New SqlConnection(connectionStr)
I get an error from the compiler saying that: "Unknown Connection option in connection string: dsn"
Is the DSN word not a defined word? or it's been replaced with another phrase (I know some people use data source, but I don't know if that's the one for me.) Any help is appreciated!
connectionStr = "DSN=GiLtY_DB;UID=;PWD="
but when I try to make a new connection, using this:
Dim myConnection As SqlConnection
Dim connectionStr As String
myConnection = New SqlConnection(connectionStr)
I get an error from the compiler saying that: "Unknown Connection option in connection string: dsn"
Is the DSN word not a defined word? or it's been replaced with another phrase (I know some people use data source, but I don't know if that's the one for me.) Any help is appreciated!