Tim Tolliver
|
| Posted: 09/25/2002, 8:08 PM |
|
I have searched for similar connection problems, but am having trouble implementing the fixes. Most answers I found seemed to be for CC, and I am not even sure that is an issue. I have used another asp generator that uses mappath & it works fine. However, it is not as full featured as CCS.
Using an Access database, and of course it works fine published locally. I am using Frontpage to publish, as I can't seem to get the FTP in CCS to work ( could FP be the problem?). After publishing, the forms load fine, but no data in them, just the field names.
The following is how my common.asp file read regarding the connection string.
Private Sub Class_Initialize()
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WEBSHARE\WWWROOT\dogs.mdb;Persist Security Info=False"
User = "Admin"
Password = ""
DateFormat = Array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss")
BooleanFormat = Empty
Set objConnection = Server.CreateObject("ADODB.Connection")
Set Errors = New clsErrors
End Sub
|
|
|
 |
Rey
|
| Posted: 09/27/2002, 10:40 AM |
|
Change the connection string
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & Server.MapPath("dogs.mdb")
|
|
|
|
REY
|
| Posted: 09/27/2002, 10:45 AM |
|
create with frontpage new directory /fpdb
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False" & Server.MapPath("fpdb/dogs.mdb")
|
|
|
|
Rey
|
| Posted: 09/27/2002, 10:51 AM |
|
emailreosoriov@hotmail.com
|
|
|
|
|
