|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
July 23rd, 2004, 04:34 PM
|
||||
|
||||
Master Detail Page in Dreamweaver
Hello,
I have a few questions that I hope someone can answer.... Where I am at: I created a connection, recordset and master detail page using dreamweaver. When I go to preview the page, I get an error: "Data source name not found and no default driver specified" Which tells me that there is not a DSN on the server. I defined the DSN locally, under System DSN. So, does that mean it is only on my system? Do I have to create the DSN on the server? Here is the code for where I am getting the error: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="../../Connections/BookConnection.asp" --> <% Dim RecordsetBooks Dim RecordsetBooks_numRows Set RecordsetBooks = Server.CreateObject("ADODB.Recordset") RecordsetBooks.ActiveConnection = MM_BookConnection_STRING RecordsetBooks.Source = "SELECT * FROM Books ORDER BY Title ASC" RecordsetBooks.CursorType = 0 RecordsetBooks.CursorLocation = 2 RecordsetBooks.LockType = 1 RecordsetBooks.Open() RecordsetBooks_numRows = 0 %> RecordsetBooks.ActiveConnection = MM_BookConnection_STRING is giving me the error. I tried to change the ActiveConnection to RecordsetBooks.Connection="Microsoft.Jet.OLEDB.4.0" (location of file - url) but recieved an error. WHAT DO I DO! Can someone help? Do you need more info? Thanks, Sarah 
|
|
#2
August 3rd, 2004, 11:16 AM
|
|||
|
|||
|
To use the DSN you would also need to create it on the server. Try this..
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=path\to\your\database"
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > Master Detail Page in Dreamweaver |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
