Results 1 to 4 of 4

Thread: Error Microsoft OLE DB Provider for ODBC Drivers

  1. #1
    Join Date
    Apr 2009

    Error Microsoft OLE DB Provider for ODBC Drivers


    I have developed a code in ASP and I get an error when I run that file. Here below i have mentioned that problem if anybody tell me what wrong with it then i will be thankful to him

    Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) / Appli_AVK / connection_SQL.asp, line 5

    Here is the code of my ASP file connection to a database SQL Server 2005

      set conn_SQL = Server. CreateObject ( "ADODB.Connection") 
      connstring_SQL = "driver = (SQL SERVER); server = S53DNVMV171; uid = cli_prev_planif_avk; pwd = pass; cli_articles database =" 
      conn_SQL. connstring_SQL open 
    Thanks for your suggestion.

  2. #2
    Join Date
    Jan 2009

    Re: Error Microsoft OLE DB Provider for ODBC Drivers

    Have you set up DSN for your OLE DB, When you set up the DSN, you need to change the default database to the database that contains all of the Commerce Server tables. If the "Change the default database to:" option is left unchecked or points to a database other than the one that contains the Commerce Server tables, the above error will occur.

    To change the default database for the Commerce Server DSN to the correct database, do the following:

    1. Open Control Panel.
    2. Double-click the ODBC Control Panel extension to launch the ODBC Administrator.
    3. Click the System DSN tab in the ODBC Administrator.
    4. Select the System datasource that is mapped to the Commerce Server database.
    5. Click the Configure button to launch the Microsoft SQL Server DSN Configuration wizard.
    6. Click the Next button twice.
    7. On the third page of the wizard, click the "Change the default database to:" checkbox, and then click on the dropdown list to select the Commerce Server database.
    8. Click the Next button twice, click Finish, and then click OK.

  3. #3
    Join Date
    Feb 2009

    Re: Error Microsoft OLE DB Provider for ODBC Drivers

    This may arise when the assigns permission are not correctly enabled, and to avoid this kind of problem you need to make sure permissions set to update/add files in the directory where you have stored the Access mdb file are granted. and to check that you need to ask your webhost

    If there would be problem related to the connection string then you might be require to change it. Strip all but the DRIVER= and DBQ= part.

    your default configuration may be set on ad2000.mdb if that doesn't work then try ad97.mdb. As the one host I installed AdMentor they claimed to support Access 2000 this may be their setting but you may get an error. But when i changed to ad97.mdb and it worked...

  4. #4
    Join Date
    Jan 2009

    Re: Error Microsoft OLE DB Provider for ODBC Drivers

    DSNs make code harder to maintain. Well, unless you can log into the ISP's machine with remote software, and to avoid this define your ODBC connection not with "Microsoft Access Driver" but with "Jet OLEDB Provider 4.0". So your connection string would look like this:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data source="C":\Backup\OBS\Development\Db\obs2k.mdb;Persist Security info="False""

    If you use a DSN-Less connection. Otherwise its in the ODBC Settings.

Similar Threads

  1. No ODBC Drivers available for Excel or Access in Windows 7
    By Mahican in forum Networking & Security
    Replies: 7
    Last Post: 01-11-2011, 01:59 PM
  2. Where to get ODBC drivers in unix
    By Xylina in forum Software Development
    Replies: 5
    Last Post: 16-01-2010, 03:12 AM
  3. ODBC Drivers 64-Bit
    By NMahmoud in forum Windows Server Help
    Replies: 4
    Last Post: 13-10-2009, 02:51 PM
  4. Microsoft office install odbc error
    By Drogbaa in forum Windows Software
    Replies: 3
    Last Post: 03-08-2009, 06:23 PM
  5. How do I reinstall ODBC Drivers?
    By longevity in forum Windows XP Support
    Replies: 1
    Last Post: 31-12-2006, 11:00 PM

Posting Permissions

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