Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Error Microsoft OLE DB Provider for ODBC Drivers

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 12-05-2009
Member
 
Join Date: Apr 2009
Posts: 65
Error Microsoft OLE DB Provider for ODBC Drivers
  

Hello,

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

Code:
 <% 
  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.

Reply With Quote
  #2  
Old 12-05-2009
Member
 
Join Date: Jan 2009
Posts: 140
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.
Reply With Quote
  #3  
Old 12-05-2009
Member
 
Join Date: Feb 2009
Posts: 105
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...
Reply With Quote
  #4  
Old 12-05-2009
Member
 
Join Date: Jan 2009
Posts: 99
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 04:09 PM.