Monika
|
| Posted: 02/04/2002, 4:52 AM |
|
Sir,
Hello,
I used CC and developed my web site(ASP 2.0 with Templates). It works fine on my Local computer and on my Intranet (with PWS as well as On IIS).
I Used MS Access Database and Using Connection String Type "Same as Design" and Connection Type "Custom" with Provider=Microsoft.Jet.OLEDB.4.0.....
(The generated Code Looks like in Common.asp is as follows :
Dim cn : Set cn = Server.CreateObject("ADODB.Connection")
'-------------------------------
' Create database connection string, login and password variables
'-------------------------------
Dim strConn, strLogin, strPassword
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\database\Sales_Feb_2002.mdb;Persist Security Info=False" )
BUT when I upload file to the WEB server on which I hosted my WEB site and give the addess of the page, the following error message comes :
The page cannot be displayed
HTTP 500 Internal server error
My Host server is with IIS support and ms_access database.
What Can I Do? I think this is a database connection error? How can I Modified this connection string to use my generated pages on my web server?
I Tried this :
Set Cn = Server.CreateObject("ADODB.Connection")
conString = "DBQ=" & Server.MapPath("..\database\Sales_Feb_2002")
Cn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & conString
but the same error message is come ?
waiting for reply.
Thanks in advance.
Monika
|
|
|
 |
Nicole
|
| Posted: 02/04/2002, 7:23 AM |
|
Monika,
try to let CC create connection string and upload db automatically. On Site->Properties->Database tab->server side connection select
Connection String Type - Create Automatically
select 'Copy the database' checkbox
select Access version
and define 'Local Database Path'
The db will be uploaded and connection string will be like:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("BugTrack_MSAccess.mdb") & ";Persist Security Info=False"
|
|
|
|
Monika
|
| Posted: 02/04/2002, 9:08 AM |
|
I tried this but could not get success. The error Message is the same on the web server while running fine locally.
Give another solution Please ?
Monika
|
|
|
|
Monika
|
| Posted: 02/04/2002, 5:36 PM |
|
Please anyone who know the solution, Give me, Otherwise I will be in a trouble.
How Can I modify this connection string?
Monika
|
|
|
|
Nicole
|
| Posted: 02/05/2002, 4:48 AM |
|
Monika,
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.
|
|
|
|
|
