Probably has something to do with the path of the database file. If E:\ is mapped to a network resource, try moving the *.dbf file to a local folder, change the path in your connection string accordingly, and see if it works. If it works, then the drive letter is the culprit. In which case, if I remember correctly, you need to use the full network path including the machine name and share name of the network resource, like \\machinename\sharename\subdirectory\filename.dbf.
Hope that helps! - Vieth > -----Original Message----- > From: Chris Hagwood [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 1:37 PM > To: [EMAIL PROTECTED] > Subject: [ASP] dbase connection string > > > I need to connect to a dbase database, but cannot seem to get > it right. > Here's my connection string: > > strCon = "Driver={Microsoft dBASE Driver (*.dbf)};" & _ > "Dbq=E:UPDATES\ONLINEDB\feimage.dbf;" > > Set rs = Server.CreateObject("ADODB.Recordset") > > strSQL = "Select * from feimage;" > rs.Open strSQL, strCon > > I get this error: > Error Type: > Microsoft OLE DB Provider for ODBC Drivers (0x80004005) > [Microsoft][ODBC dBase Driver] '(unknown)' 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. > /intranet/webforms/jailphotos/results.asp, line 6 > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> Make a clean sweep of pop-up ads. > Yahoo! Companion Toolbar. > Now with Pop-Up Blocker. Get it for free! > http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM > -------------------------------------------------------------- > ------~-> > > -------------------------------------------------------------- > ------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [EMAIL PROTECTED] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
