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!

Connecting Access to FrontPage

Status
Not open for further replies.

mbdw6708

Vendor
Jun 22, 2000
121
US
I have connected an Access database to FrontPage.  When I view from the Browser, there is no output from the database.  Any advice????????
 
Dear mbdw6708,<br><br>When posting a question attempt to be specific while not being verbose.<br><br>For example<br>&gt;I have connected an Access database to FrontPage<br><br>How?<br><br>Reduce your code problem to the smallest possible contents that exihbits the behavior in question, i.e.,<br><br>&lt;%<br>&nbsp;&nbsp;var rs = Server.CreateObject(&quot;ADODB.Recordset&quot;);<br>&nbsp;&nbsp;rs.Open(&quot;select name, phone from test&quot;,&quot;DSN=testing&quot;, 1,3,1);<br>%&gt;<br><br>Name: &lt;%=rs(&quot;name&quot;)%&gt;&lt;br&gt;<br>Phone: &lt;%=rs(&quot;phone&quot;)%&gt;<br><br><br>The browser displays the message:<br><br>Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br><br>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <br><br>/Research/work/junk.asp, line 9 <br><br><br>Hope this helps<br>-pete
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top