Complete Newbie question. Do I need ODBC to go between asp and mssql?

I took over a project from a website developer that did not have enough time to spend on his customer. It uses MS Sql server and ASP. The other developer sent me the customers data in a backup. I installed SQL Server 2005 on a test windows 2003 server and got ASP working with IIS6. I added the login and pw for the customers data and associated it with the database.

Can't seem to get to the data from the website which is on the same server.

I get the following error in IE7:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Do I need to add an ODBC driver also? Isn't just adding Sql server 2005 enough? Have read and read - missing something.

The code in the asp page is:


' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_ADODB_STRINGRO
MM_ADODB_STRINGRO = "dsn=abc;uid=abcO;pwd=abc2009;"


Any ideas? Complete newby to sqlserver and asp.

 

Here is a site that will help a lot:

http://www.connectionstrings.com/

I use it all the time.