KB Issue

When creating a database connection string, you may sometimes get the address incorrect.

Issue Details

Creating a JET Database Connection String, you have to make sure that you have your address correct, if not, you will get an error similar to this:

Microsoft JET Database Engine (0x80004005)
'G:\InetPub\wwwroot\site\2\data\mydb.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server where the file is located.
/stajac/ACN.asp, line 6

Recreate Issue

This will happen if you misspell your directory name in the path.

[Classic ASP - ACCESS Database Connection String with Error]

CFFCS | CarrzSynEdit: | ASP/VBScript

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\InetPub\wwwroot\site\2\data\mydb.mdb"
objConn.Open

Resolve Issue

To resolve this issue, make sure that you spell your folder names correctly.

[Classic ASP - ACCESS Database Connection String]

CFFCS | CarrzSynEdit: | ASP/VBScript

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\InetPub\wwwroot\site\1\data\mydb.mdb"
objConn.Open

Looking at the above connection path, you will notice that there is a \1\

Copy

Search Site

Search Google

instead of a \2\

Copy

Search Site

Search Google

; this is what caused the issue.

When creating paths like the one above, copy and paste the physical path from Explorer's address bar.