Tim Tolliver
|
| Posted: 09/26/2002, 5:14 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
|
|
|
 |
Alex
|
| Posted: 09/26/2002, 11:59 PM |
|
I guess you only have to change the path to the database from your computers hardisk to the servers path from the point on the conn string
C:\WEBSHARE\WWWROOT\dogs.mdb;Persist Security Info=False"
You got the path from your webaccounts site or from the staff and it could be like (conn string from C:...)
D:\webspace\servername\virtualdomain\yourdomain.com\www\yourmap\yourdatabase.mdb..."
|
|
|
|
jAMES
|
| Posted: 09/27/2002, 9:16 AM |
|
see idiot posting.
95% of my problem was getting the correct connection string from my ISP
then pasting that connection string into the common asp files..for more in depth advice follow up the idiot posting...
|
|
|
|
Tim Tolliver
|
| Posted: 09/27/2002, 9:36 AM |
|
Thanks to you both for your replies. I got it working.
|
|
|
|
|
