Anurag Seetha
|
Posted: 02/04/2002, 10:48 PM |
|
hi
i used CC by ASP & Templet and develop a result site. It works fine on my Local computer with PWS as well as On IIS.
BUT when i upload file to the WEB server on which i hosted my WEB site. the error message while accessing asp file is
HTTP 500 Internal server error
When i give address for my HTML templet it shows me the templete.
My host server is with IIS support and ms_access database.
I am also using ms_access database with DSN less connectivity.
I am in a difficult position as i have to declare my result on the Internet.
My current connection string is looks like as follows :
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=..\result\Result_Feb_2002.mdb;Persist Security Info=False"
strLogin = "Admin"
strPassword = ""
I don't know the Physical Path of my direcrory on the web server on which my site is hosted
waiting for reply.
anurag
|
|
|
Andrew B
|
Posted: 02/04/2002, 11:10 PM |
|
Try changing your conn string to include this :
Data Source = " & Server.MapPath("..\result") & "\fresult_feb_20002.mdb"
Also, are you sure that both the DBs are identical?
|
|
|
Anurag Seetha
|
Posted: 02/05/2002, 12:03 AM |
|
Dear Andrew B
I am Using ONLY ONE database that is stored in the "result" subdirectory of the web server in which all others related files are stored.
The above thing is also not worked .
Please Help Me.
Anurag Seetha
|
|
|
Nicole
|
Posted: 02/05/2002, 5:18 AM |
|
Hello,
Try to use DSN connection. Create DSN for your db on local machine and DSN pointing to uploaded db with the same name on server.
In CC for Design time in Data Link properties window on Providers tab select 'Microsoft OLE DB Provider for ODBC Drivers', on Connection tab select your dsn name.
For server side connection select "Same as Design" from Connection String Type.
|
|
|
Peter
|
Posted: 02/05/2002, 6:59 AM |
|
Original:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=..\result\Result_Feb_2002.mdb;Persist Security Info=False"
strLogin = "Admin"
strPassword = ""
New:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=..\result\Result_Feb_2002.mdb;Persist Security Info=False"
strLogin = "Admin"
strPassword = ""
|
|
|
Peter
|
Posted: 02/05/2002, 6:59 AM |
|
Original:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=..\result\Result_Feb_2002.mdb;Persist Security Info=False"
strLogin = "Admin"
strPassword = ""
New:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=..\result\Result_Feb_2002.mdb;Persist Security Info=False"
strLogin = "Admin"
strPassword = ""
|
|
|
Peter
|
Posted: 02/05/2002, 7:01 AM |
|
Sorry, I have e few sticking keys on this keyboard.
Original:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=..\result\Result_Feb_2002.mdb;Persist Security Info=False"
strLogin = "Admin"
strPassword = ""
New strConn statement:
Dim strConn, strLogin, strPassword
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Result_Feb_2002.mdb") & ";Persist Security Info=False"
strLogin = "Admin"
strPassword = ""
|
|
|