Access ODBC Drivers

Results 1 to 2 of 2

Thread: Access ODBC Drivers

  1. #1
    Join Date
    Dec 1969

    Default Access ODBC Drivers

    I am looking into using OpenDataSource as a way to transfer data from ACCESS to SQL. I am able to connect to an ACCESS DB with<BR><BR>Set AccessConnect = Server.CreateObject("ADODB.Connection")<BR>AccessC = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:Inetpubwwwrootdata_fso ester.mdb" <BR><BR>But am unable to do the OpenDataSource connection with:<BR><BR>SELECT *<BR>FROM OPENDATASOURCE (&#039;Microsoft Access Driver (*.mdb)&#039;, <BR> &#039;Data Source="C:Inetpubwwwrootdata_fso ester.mdb";User ID=;Password=&#039;<BR> ).tester.mdb.tester<BR><BR><BR>The error is my Micrsoft Access Driver<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.<BR>/aadmin/ShowRecordsAccessIDlocal.asp, line 13<BR><BR>Anyone here try to do this... ideas??? How else do I state:<BR><BR>&#039;Microsoft Access Driver (*.mdb)&#039;<BR><BR>Paul

  2. #2
    Join Date
    Dec 1969

    Default Answered in Asp Q&A forum


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts