Cannot figure out server.mapppath configuration

[Jack]

Hello,
I have an application on my desktop where I have hardcoded the connection
string. Now I need to move the application to our test webserver. Here I need
to use the server.mappath method to connect to the database. The database is
in the same directory as the new application named gwis. Hence the database
is in the gwis directory in the test webserver. I made the changes in my
connection string as follows:


myDSN="DRIVER={Microsoft Access Driver (*.mdb)}; "
'myDSN=myDSN & "DBQ=C:\_______GWISBRANDNEWREADY3\GMISDATA.mdb"
myDSN = myDSN & "DBQ=" & Server.MapPath("/gwisbrandnewready3/GMISDATA.mdb"
Set CN=server.createobject("ADODB.Connection")
CN.Open myDSN

Set RS = Server.CreateObject("ADODB.Recordset")
RS.ActiveConnection=CN

The old hardcoded string is commented out. However, with this change, the
application is not still working.
It goes through the verify.asp routine. However, it displays the following
message:

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be
displayed.

HTTP 500 - Internal server error

Any help is appreciated in advance. Thanks.

 

[Patrice]

Disable "simplied http errors" in your IE config so that you see the exact
error...

Patrice

 

[Jack]

Thanks Patrice for your suggestion. I already got it.

 

[Bob Barrows [MVP]]

So that means your problem is solved?

Thanks Patrice for your suggestion. I already got it.

 

[Jack]

Thanks Bob for asking. Actually, my problem is resolved here. However,
I have a different problem which I posted in the database section which is
yet to
be resolved. It is about connecting from asp to a database located in a
different
server. Regards.