Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Frontpage database connection questions

Status
Not open for further replies.

lshippee

Technical User
Jul 19, 2000
36
US
The problem:<br>When I go to the active server page containing the database results, I get the following error message:<br><br>Database Results Error<br>Description: [Microsoft][ODBC Microsoft Access Driver] 'F:\MSOFFICE\SHARED\AgencyEvalData99.mdb' 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.<br>Number: -2147467259 (0x80004005)<br>Source: Microsoft OLE DB Provider for ODBC Drivers<br><br>One or more form fields were empty. You should provide default values for all form fields that are used in the query. <br><br>*******<br>This happens whether I type in the url from the browser or I open the web on the server and preview the page.<br><br>Working on the server I have done the following to attempt resolution:<br><br>Reverified the database connection <br><br>Changed the type of database connection from &quot;file or folder in current web&quot; to &quot;system data source on web server&quot; and selecting the data source name set up for me by my web host.<br><br>Reimported the database and attempted running the results wizard -- I get the same error message as above while trying to run the database results wizard<br><br>How can I resolve the path name problem so that the results are connected with the database on the web server rather than on my PC?&nbsp;&nbsp;I thought that reimporting the database would do it, but apparently not.&nbsp;&nbsp;<br><br>Is there something I'm missing about data source names?&nbsp;&nbsp;Is this something I have to replace or modify in order to complete the results?&nbsp;&nbsp;<br><br>Any insight you can provide is greatly appreciated.<br><br>Leslie Shippee<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top