S
Scott
As this is my first time creating/publishing a website, I
have run into a problem with the creating the database. I
am using Frontpage 2002,have already completed and saved
the form as an .asp file, and am stuckon the DSN part and
connection properties.
Under Database Results Wizard step 1-5, the Database
Connection Properties, I chose SYSTEM DATA SOURCE ON WEB
SERVER. After this, I am instructed to choose an option
under browse, but currently have 2 choices that do not
seem right and don't work (Name: Donations3_DWC Type:
Sybase SQL anywhere 5.0, and the other is the same but
says readonly)
When either of these are chosen, there is a database
connection error on step 2 of the results wizard. If you
have any information or know where I can get some detailed
instructions for a beginner, it would be greatly
appreciated. I also want the results private and not
visible to the public.
I also sent this message to my web hosting company and
this is there response. Any suggestions?
THANKS,
Scott
Response:
We are using the latest Microsoft Data Access Components
(MDAC 2.6),which fully supports Jet 4.0, and therefore
Access 2000. So there is no worry on driver issues.
This is how you can make the connections.
Assumption: your database is in cgi-bin directory.
DSN Less connection for Access
<%
set cnn = server.createobject("ADODB.Connection")
cnn.open "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=e:\inetpub\clients\domain_name.com\cgi-
bin\database.mdb"
%>
OLE DB Method for Access
<%
set cnn = server.createobject("ADODB.Connection")
cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE
e:\inetpub\clients\domain_name.com\cgi-bin\database.mdb "
%>
File DSN Connection Method for Access
<% set cnn = server.createobject("ADODB.Connection")
cnn.open "FILEDSN=AccessDSN"
%>
have run into a problem with the creating the database. I
am using Frontpage 2002,have already completed and saved
the form as an .asp file, and am stuckon the DSN part and
connection properties.
Under Database Results Wizard step 1-5, the Database
Connection Properties, I chose SYSTEM DATA SOURCE ON WEB
SERVER. After this, I am instructed to choose an option
under browse, but currently have 2 choices that do not
seem right and don't work (Name: Donations3_DWC Type:
Sybase SQL anywhere 5.0, and the other is the same but
says readonly)
When either of these are chosen, there is a database
connection error on step 2 of the results wizard. If you
have any information or know where I can get some detailed
instructions for a beginner, it would be greatly
appreciated. I also want the results private and not
visible to the public.
I also sent this message to my web hosting company and
this is there response. Any suggestions?
THANKS,
Scott
Response:
We are using the latest Microsoft Data Access Components
(MDAC 2.6),which fully supports Jet 4.0, and therefore
Access 2000. So there is no worry on driver issues.
This is how you can make the connections.
Assumption: your database is in cgi-bin directory.
DSN Less connection for Access
<%
set cnn = server.createobject("ADODB.Connection")
cnn.open "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=e:\inetpub\clients\domain_name.com\cgi-
bin\database.mdb"
%>
OLE DB Method for Access
<%
set cnn = server.createobject("ADODB.Connection")
cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE
e:\inetpub\clients\domain_name.com\cgi-bin\database.mdb "
%>
File DSN Connection Method for Access
<% set cnn = server.createobject("ADODB.Connection")
cnn.open "FILEDSN=AccessDSN"
%>