ASP to MsSQL

[koh]

bottom here is my asp coding, for connecting to mssql2005
i know how to connect to mssql by vb using the com+.
but i want to try using the database connection on asp page.

<%@ LANGUAGE="VBScript" %>
<%
Option Explicit
Dim UID, SQLStmt, Connection, FirstName, LastName
Dim RS, SSN, Major, GradDate
 SSN = Request.QueryString("SSN")
 Set Connection = Server.CreateObject("ADODB.Connection")
 Connection.Open "Driver = {SQL Server};Database=Db_Testing;UID=;PWD=;"
 SQLStmt = "SELECT * "
 SQLStmt = SQLStmt & "FROM detail "
 Set RS = Connection.Execute(SQLStmt)
%>
<h2><%= RS.Fields("name") %> <%= RS.Fields("telephone") %>:</h2>

i tried many ways, it seems that i am having problem connecting to database;
where i always receive the message belowMicrosoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

May i know whats wrong with my coding? or may be i missed a step for the connectivity.

Thank you

[hollystyles]

You havn't told ADO where the server is, localhost/FQDN or IP address. try this:

Connection.Open "Data Source=localhost;Initial Catalog=Db_Testing;UID=;PWD=;"

This is a great reference for connection strings: www.connectionstrings.com

[koh]

oic, but to the above coding
i placed them into vb6.0. It worked perfectly...

mind asking for another question...why?

thank you

[hollystyles]

i placed them into vb6.0. It worked perfectly...

mind asking for another question...why?

You have to set the server somewhere, how can anything connect to DB_testing if it doesn't know where the server is? I can't answer your question because there are many ways to connect VB apps to a SQL Database through wizards and stuff and I wasn't looking over your shoulder when you did it so I can only make a stab in the dark...err maybe it was magic?

[koh]

oic....i'd understand

thank you hollystyles