Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 1837 | Replies: 4
 |
•
•
Join Date: Jul 2004
Posts: 64
Reputation: 
Rep Power: 5
Solved Threads: 0
Junior Poster in Training
ASP to MsSQL 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.
i tried many ways, it seems that i am having problem connecting to database;
where i always receive the message below
Microsoft 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
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 below
Microsoft 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
Last edited by koh : Jul 30th, 2006 at 9:44 am.
•
•
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,166
Reputation:
Rep Power: 7
Solved Threads: 59
You havn't told ADO where the server is, localhost/FQDN or IP address. try this:
This is a great reference for connection strings:
www.connectionstrings.com
Connection.Open "Data Source=localhost;Initial Catalog=Db_Testing;UID=;PWD=;"
This is a great reference for connection strings:
www.connectionstrings.com
Last edited by hollystyles : Jul 30th, 2006 at 5:43 pm.
•
•
Join Date: Jul 2004
Posts: 64
Reputation:
Rep Power: 5
Solved Threads: 0
Junior Poster in Training
oic, but to the above coding
i placed them into vb6.0. It worked perfectly...
mind asking for another question...why?
thank you
i placed them into vb6.0. It worked perfectly...
mind asking for another question...why?
thank you
•
•
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,166
Reputation:
Rep Power: 7
Solved Threads: 59
•
•
•
•
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?
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
