|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: DSNless connection to Access Database problem |
|
From: |
gunther |
|
Date: |
12/5/2000 10:05:07 AM |
|
IP: |
212.190.10.49 |
Set MyConn = Server.CreateObject("ADODB.Connection")
conString = "DBQ=" & Server.MapPath("members.mdb")
Myconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & conString
sql="SELECT Fields " & _
"FROM tables " & _
"WHERE conditions;"
Set RS = MyConn.Execute(SQL)
This is the code for MapPath. To execute this code, members.mdb has to be in the same directory as the asp that will call it. but i think that your problem isnt the code, but how you execute an asp. It has to be run through HTTP, so the code can be compiled en executed. Therefore you have to start an asp like this:
c:\inetpub\wwwRoot\members\default.asp is called as http:\localhost\members\default.asp |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
