We help IT Professionals succeed at work.

Not a valid path?

Medium Priority
636 Views
Last Modified: 2013-11-24
I get the error message:
"Microsoft JET Database Engine (0x80004005)
'c:\inetpub\wwwroot\company\KUND.DBF' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/company/test.asp, line 5"

The asp file is in the same folder as the dbf-file. This is my code:

<%
  Dim Conn: Set Conn = CreateObject("ADODB.Connection")
  Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                   "Data Source=" & Server.MapPath("KUND.DBF") & ";" & _
                   "Extended Properties=""DBASE IV;"";"
  Set OpenDBFConn = Conn

Set rs = Server.CreateObject("adodb.recordset")

SQL = "SELECT * From kund"
rs.open SQL,Conn,2,3

%>

Could any one tell me why I get this error?
Comment
Watch Question

Senior Systems and Integration Developer
CERTIFIED EXPERT
Commented:
In all the samples I have seen the actual datafile name is not specified. Have you tried:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".") & ";Extended Properties=dBASE IV;User ID=Admin;Password="

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thank you!!!

That was strange, but it worked. =)
Carl TawnSenior Systems and Integration Developer
CERTIFIED EXPERT

Commented:
No problem. For future reference, if you ever need a connection string for pretty much any database, you can look here:

    www.connectionstrings.com
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.