Newbie question: SQLClient in ASP.Net

[info25]

Hi
Whenever I tried accessing my SQL Server 7.0 database with SQLConnection in ASP.Net, I always get the error: 'Specified SQL server not found'. My code is like:

Dim Con As New SQLConnection("server=SQLSRV;database=northwind&quot
Conn.open()

SQLSRV is the name of my SQL server on the network. In the ASP days, I usually use DSN to access the SQL server and all works OK.
Can anyone tell me what I should do to corrrect this?
And should I specify user id and password for the connection string? Are they the same as the DSN UID and pwd?
I think I can do it in DSN way, but I need to download ODBC.Net data provider, but it requires MDAC 2.7 or later. And Micosoft's MDAC download page says: 'Due to issues with clustering, this release is currently NOT supported on SQL Server 7.0 Servers or SQL 6.5 Clustered Servers. '! Huh? Does this mean I can't use ODBC?
Oh BTW, I just installed MDAC 2.6 on the web server. Can that be the cause of the problem?
Thanks!

 

[drew10]

I noticed that you declare Con as New SqlConnection then you use: Conn.open() ---> Conn spelled with 2 n's
That may be your problem.