Over 1 million tech questions and answers.

Access - Oracle ODBC Error

Q: Access - Oracle ODBC Error

We recently switched from Oracle 8 databases to Oracle 11g. I have an existing Access 2002 database with a report that runs off a schema in the Oracle database.

I created a new ODBC entry to link the tables in Access to the new Oracle DB, however I am getting an OBDC failure error when I try to link them in the link table manager.

Is there anything I need to do, download new drivers for example, to get the report to properly link to the tables?



Preferred Solution: Access - Oracle ODBC Error

I recommend downloading and running DAP. It can help sort out any driver and firmware related issues on your system

It's worked out well for many of us in the past.

You can download it direct from this link http://downloaddap.org. (This link will open the download page of DAP so you can save a copy to your computer.)

A: Access - Oracle ODBC Error

Sorry, I have no idea, have you contacted the Oracle Support team or help?

Read other 1 answers

When I search for Oracle ODBC drivers, I can only find drivers for Windows 7. I have seen installation instructions for installing Oracle 11g on Windows 10 (the actual database software) but I can't find anything on installing Oracle 11g ODBC drivers (32 or 64bit) for either Windows 8.1 or Windows 10. I've also looked on Oracles "Instant Client downloads for Microsoft Windows (x64)", but only can seem to find ODBC drivers that work with Windows 7. What's taking so long? This would seems to be a rather highly requested driver.

Read other answers

Hi all,
I have a strange problem that occur on lots of our machine,
We deploy a fresh Windows 7 32Bit OS from SCCM.
I created a script that adds a "Microsoft ODBC for Oracle" DSN on all of our workstation (part of the task sequence).
I tested the script and its work great, but...
Some users have problem that the DSN is not showing on the "ODBC Data Source Administrator"

Now, when I try to manually add the DSN, the moment I select "Microsoft ODBC for Oracle" i get the following error -

I'm googling the web for few days now and cant find a solution...
Please help...

A:Microsoft ODBC for Oracle - Fail to create

Correct, I based my opinion on the error about the components apparently missing. Here is a Knowledge base article about troubleshooting this very issue:
How To Troubleshoot an ASP-to-Oracle Connectivity Problem
There is a similar thread on the Oracle forums which contains some solutions you can attempt to fix your problem:
Thread: Oracle client and networking components were not found

Do those steps resolve your issue?

Read other 10 answers

Create a batch script for Oracle ODBC connection

Read other answers

Good afternoon Lord Bob,

I have installed the Oracle 10 g drivers, but MS access 2007 x86 can't seem to see the ODBC driver. I tried to set up manually, but got a non administrator Fail answer. I am an administrator.

so what am I missing? I can see and connect using the SysWOW64 odbc driver, but the application can't,



A:For Lord Bob - installing Oracle 10G ODBC driver on windows 7 x 64

Not sure why you asked me this, and I have little experience with Access and Oracle software.

Have you checked the Access and Orcacle FAQs and forums for this problem?


Read other 1 answers

When an Access97 database was converted to Access2000, and error message:
ODBC- -call failed
[INTERSOL][ODBC SQL Server driver][S #102] was recieved. The action was "Transfer Database", Transfer type: "Export", Database type: "ODBC Database"

Has anyone seen this. I found nothing in TechNet (June 2000 edition).


A:Access 97 convert to 2000 ODBC error

You've obviously got a macro or other code in the database that saves the file through ODBC to an external file. If you have no idea what I'm talking about, go to the Macros tab and see if you have any. Open them in design view and see if there is a file name listed in any of them.

Brainbench MVP for Microsoft Word

Read other 1 answers

I'm using Access 97 on a Windows 2000 machine. Monthly, I get a Cognos Powerplay cube file (.mdc), with which I run reports using the Cognos Powerplay application.

I would like to use Access on this file to automate what I do manually in Powerplay. I am proficient in Access VB but I have not used DAO or ODBC. I've read the on-line help and I believe I need ODBC drivers but that is about as much as I get out of it.

Can someone tell me how to get started with this?

Thanks in advance,


A:MS Access and ODBC

You need to contact them for the driver. I didn't see anything on their web site, but they may have one.

Read other 1 answers

I want to connect my access database to an ODBC connection. Basicallt, we have this system that we use with a lot of information so basically, I created a field in my access database and what I want it to do is that I will have one field that will be the indentifier meaning when I enter a name there, I want all other info associated with that name to show up on my form. Problem is I dont know how to do that. Can you help me?

A:Access with ODBC

Read other 15 answers

Looking for the best approach to updating/altering an Access table via DSN-less connection string.

Situation: This process will be run nightly via MS Schedule tool

1 - contains 1 table which acts as a linked central datasource for
numerous databases - this cannot be change. - in some instances this
maybe left active which affects the altering of the table. Alter is
need to change 3 fields's data types or convert prior to update.

2 - contains the temporary table and the code or possibly just the code
to update the data in the linked table source.

Note this code
cannot be kept in DATABASE1 - due to the fact that this database is
occasionally opened and used by other users, so I cannot have the
Autoexec fired when the user access the database - hence the need for

Now the Oracle data source contains numerous fields
that need to be converted in 1 way or another, including converting a
date that in contains a text (varchar) datatype ie. 090822, when I
attempt to covert this and place in an Access Date/Time field - I am
getting an error.

My thought is to create the temp table then
export into Database 1 - which will replace the existing with the new
data - or possibly have the Database2-tbl linked in Database1 and do a
delete and append queries - however, then I run into the conversion

Any and all suggestions is greatly appreciated.

that needs the conversio... Read more

Read other answers

In making the ODBC connection to my external database while linking the table to Access 2010, I forgot to check the Save Password checkbox when I was choosing the tables to link to. Is there any way to do that now (save the password) without redoing the whole project from scratch?



A:Access ODBC Password

Read other 7 answers

Keep on getting errors while using ColdFusion
I reinstalled MS Access 97 but keep getting this dialog box
when I turn on ColdFusion Server 4.0.1

ODBC Driver Manager
is a different version than the ODBC driver manager
You need to reinstall the ODBC components to ensure proper operation

How do I reinstal the ODBC components?

A:Access 97 ODBC manager

Go to the setup again and select options and select Data Access Components

Read other 1 answers

Hi All

After installing the drivers for V5R2, I reboot and then once logged in I get this warning:

"Your service source directory (\\servername\path\V5r1\Express\Install\Image), has ISeries Access for Windows version V5R1MO. Your compuer has ISeries Access for Windows version V5R2MO.

Service Pack (SP) cannot be installed because your computer's version is newer than your service source directory's.
My goal is to have Client Access ODBC driver (32-bit) version 9.00.08 (cwbodbc.dll).

Does installing the service pack get me to version 9.00.08 ? Right now I'm at version 9.00.00. And futhermore, how can I get past this warning/error


Read other answers

Operating System - Windows XP Professional Version 2002 Service Pack 2
Office version - Office Professional Edition 2003
I am trying to link an Access application to a SQL Server table via ODBC link. However, when selecting "ODBC" under Files of Type on the Link dialog, the Link dialog box closes and nothing happens.

SQL Server is installed on my computer as are the database tables that I am trying to connect to.

To see if it was an issue, I set the macro security level to low, but still no luck.

Is there anything else that needs to be adjusted to enable the ODBC link?

A:MS Access 2003 - Cannot Link To ODBC

Here is the resolution along with the disclaimer.


Read other 2 answers

When I try and link tables, using ODBC nothing happens; I know ODBC works because I can import data in Excel so the setup of source is working. I have tried re-installing MS Office 2003 and I have installed all of the service packs but I still get the same result. I think it is something wrong with my registry. Any help would be appreciated.

A:MS Access 2003-ODBC Issue

Read other 7 answers

I have an application that uses a MS Access database. In Vista it I cannot open multiple ODBC connections to the database. No error is given. As soon as I close the first application the second one opens. What do I tweak in Vista to allow multiple connections to the database?

Read other answers

Hi All,

I have two issues with Access 2003 on two different machines running XP. Both users are members of the administrators group on the local machine.

1. On the first machine when I try to link to an external data source I get "Registry Error" in the drop down box "Files of type". There are a few data sources there like Excel, dBase etc but ODBC is missing. I have uninstalled and reinstalled Office 2003 and have even tried repairing it. I have also gone to the c:\windows\system32 dir and registered all the ms*40.dll's. I have also reinstalled XP albeit just the upgrade option as opposed to a full reinstall. None of the above has worked.

2. On the other machine I am trying to link to a Foxpro 2.6 for dos (don't ask why it is a very long story!) free table ODBC connection. I get the the ODBC connection and am able to choose the Foxpro connection (Visual Foxpro Driver 6.01.8629.01) but then it throws the error

[Microsoft][ODBC Visual FoxPro Driver]Function sequence error (#0)

The annoying thing is that if I link a table on another machine and copy the database I can open the table and edit the data. Also if I log in as administrator locally I can use the ODBC connection to connect to the tables but not as my username on the domain. Again my domain account is a member of the local administrators. I have done all the reinstals as described in the first point and reregistered the dll's.

Any help would be appreciated.

A:ODBC Access 2003 two problems

I have never worked with ODBC but can I offer the suggestion that as you can do some things on some computers but not on others that you compare the Access settings on the 2 computers to see if there are any differences.
In particular the VB Editor>References to libraries settings.
Maybe also the Add-ins manager as well.

Read other 3 answers


.. hello helpful people ...
.. I am trying to install MS Access 97 on to my machine at work .. and it won't install because of an ODBC problem. There is a problem at the end of the installation .. -- The config. of the ODBC Microsoft Access Driver (*.mdb) driver failed.

.. I've tried to configure the ODBC settings myself and can't even create new ones .. it says,

-- The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could not be loaded due to system error code 1157.

.. after clicking the above warning .. it says,

-- could not load the setup or translator library
.. I've tried so much already ... installing most recent MDAC files from Microsoft .. I've used several different copies of MS Access.

.. installed MDAC (v.2.6) ... and tried installing MS Access 97 again .. same error :

-- configuration of ODBC driver failed.


.. my settings for Microsoft Access Driver (*.mdb) seem to be correct (files that are stated are in correct location).

.. but I have another folder in ODBCINST.INI .. and it is the only one that has files in a different location.

-- Client Access ODBC Driver (32-bit):

DRIVER = "C:\sqllib\bin\db2cli.dll"
SETUP = "C:\sqllib\bin\db2odbc.dll"

* neither of these files exist on my machine .. neither do the folders for that matter ... thinking I should create such files and folders .. or change the path of.

(feelin... Read more

A:.. MS Access 97 .. ODBC inst. probs.

A search for that error message came up with a few answers on on Google, though (predictably) zero on MS. At least you can know that you are not alone.

You might go and make sure you have the "right" version of MDAC. (There are many to choose from, god bless 'em.)

Several of the other sites mention using 2.5SP1 to resolve the problem, for what it's worth. I'd just keep trying MDAC versions until something clicks.

Or wait for someone who's seen this baby before to come around.

Read other 1 answers

Ok, here's the breakdown: Computer OS is NT4 SP6a, Office 97 full install, MDAC 6.1 SP1, and I have checked the components w/ ComCheck to see if they were Ok and they were. The problem is: Whenever trying to access part of the the database it comes up with 'ODBC--call failed' and then does not proceed any further w/ the database. I have reinstalled Acces, installed the newest MDAC (which is 6.1 SP1) and re-applied the service pack. No application errors in the event log even pertain to the error. See if you can crack this one. Thanks.

Joe Dyer

A:Access 97 + ODBC call failed

Read other 6 answers

I am working with MS Access 2003 and am trying to import or link odbc data. I am running XP sp2, have the latest updates on office 2003, have Jet 4.0 sp8. I have updated ODBC drivers and have several DSNs set up - both in system and user.

When I try to import external data - I change the file type to ODBC and the dialog box disappears.

Anyone have any ideas - Dell has never seen this before
New Info - the query can access ODBC databases - it seems that only the select data source wizard is having a problem

A:MS Access ODBC Data Source problem

Read other 16 answers

Where can I find the 32-Bit drivers for Access so I can connect to MyODBC?

Read other answers

I have two laptops at my company that have Windows 7 Home - thus cannot login to AD/Domain as a specific user. They in-turn use a local administrative account setup on those laptops. We have a database setup with linked connections to our SQL Server 2005.

Whenever we're trying to access those linked tables we get the following error message:
We can bypass this issue by manually typing in the Login/Password within this error prompt.
What's strange is that we have ODBC setup to use the SQL Server Authentication:
That SHOULD allow us to not use Windows Authentication (as you can see it's trying to use the 'Guest' account on Windows 7. I've tried making this change through both x32 and x64 versions of ODBC (located in wow64). I've searched all over the internet concerning this issue but no one seems to have anything similar. This used to work a few weeks ago and I don't know of anything we changed other than a few system updates.

The SQL Server's Security is setup to use both authentication methods:
Our SQL Server gives us an Error: 18456, Severity: 14, State: 11
A quick Google search explains that State 11 means, "Valid login but server access failure".

Any help please? The only solution I have right now is to install W7 Pro...

A:Access & ODBC connection issue on W7 Home, State 11

Sound like a Windows permissions issue to see the SQL server.

You could also map a network drive using other credentials. This will authenticate the computer onto the domain.

Read other 4 answers

I have an Access table linked to MSSQL. The table has a primary key with no additional indices. I receive write conflict errors when I attempt to update some records (not all) while in an access form or directly in the table via Access. Changes in SQL work fine. Very strange - some records can be changed, while others cannot, seemingly without any pattern related to position in the table or data contents. NO triggers exist in the DB. What is going on?

A:Solved: Access w/ ODBC MSSQL - Write Conflict

Read other 9 answers

When would you use Oracle instead of Access and what are the limitations on Access and Oracle

Read other answers

I set up and maintain an Access 2000 database in a hospital to track patients in a particular program. The hospital has signed with another info system operator and it looks like they are changing to Oracle. I know nothing about the database and am wondering how much different it is from Access and if I will be able to import my Access database and queries into the Oracle database. The hospital does not support Access and has not done so in the past. Our department is apparently the only one using Access; however, we may be able to keep using Access even tho we aren't supported by the IS operator. BUT if we can make the change w/o a lot of problems, maybe we should do so. I'm self taught on Access and will probably have to take outside classes on my own for Oracle.

Any suggestions for me.

Read other answers

I have Win7 and Office 2010 both 64 bit. I also have a 32 bit application running where I need a 32 bit *.accdb
 (MS Access) ODBC driver. Using the 64-bit version of the Odbcad32.exe is returning “The specified DSN contains an architecture mismatch between the Driver and Application”. So I need a
32 bit ODBC *.accdb driver for my application.
My problem:
When I open c:\windows\SysWOW64\odbcsys32.exe and try to ADD a new dsn there is only a *.mdb driver available for MS Access. Does anyone know how to
add a 32 bit MS Access *.accdb driver to c:\windows\SysWOW64\odbcsys32.exe? Maybe I missed something obvious but this is giving me headache after browsing through the Internet for a solution. 


A:32 bit ODBC driver for MS Access 2010 (*.accdb) is missing in Win7 64bit

Carl, I just figured out a solution... If you are running a 64-bit Computer and Running Access 2010, you will first need to download the AccessDatabaseEngine.exe from Microsoft.

After the download finishes, and installs, You will need to create an ODBC connection. Instead of creating an ODBC connection through your Administrative Tools, Data Sources (ODBC) interface, you will need to run the 64-bit instance of Data Sources (ODBC).
To do this, you will need to click your "Windows" + "R" buttons on the keyboard, and then paste "c:\windows\sysWOW64\odbcad32.exe" -- without quotes into the dialog. Then create the connection to the database as you would on a 32 bit machine.
I had the same issues with the *.accdb not showing up in my 64 bit ODBC connections. It then showed up after performing the above steps.
Hope this Helps,
Alex Mahrou

Read other 12 answers

Hi guys, I installed a bank application on my windows xp machine, that application has a server which loads the templates/data to be used on that application. However, after installing the app. I encounterred an error on most of the pc (except mine) error shows that "Source: Microsoft OLE DB Provider for ODBC Drivers [ODBC Driver Manager] Driver does not support this function"

The installation procedure of this application in XP was just a typical installation setup except that after completely installing it, I have to change the .ini file and path it to the server.

Its also a mystery to me that my error is on ODBC since I am not using any odbc connection for this one.

I hope anyone can help me on this one. Thanks

Read other answers

Hello guys,
1- I am using Oracle 10g Express Edition to learn SQL queries, please tell me what I can do more in Oracle 10g Express Edition and
2-I want to know what type of software applications I can make in Oracle Developer Suite as well.

thanks for detailed answer

Read other answers

CFusion vs Oracle vs Visual.net vs Access? Heeelp.

Here is an outline of the project that I about to start. In a nutshell, what I am trying to do is to build a robust internet-based application that will automate the processed outlined below. Optimizing the resources ($) is also an important goal.
Based on that info, can you give some advice as to what tools I can use to create this app.
I have ruled out MS Access unless I am convinced otherwise.

1. This project requires getting data from some legacy database. As of right now, someone has to log into the system on DOS and go through a series of commands and then dump the output into an Excel spread sheet. There are a couple of third party software packages and one of them is XXXXX Viewer. I have not had a chance to read up on this it (XXXXX Viewer) and I do not know which other application it interfaces with. If it does not interface with any other application, that is OK; uploading from an Excel DB can be automated.

2. That spread sheet is then copied into another Excel spreadsheet and processed using Visual Basic for Application. In the version to be built, there will be a lot of statistical analysis and mathematical modeling. This will require calling libraries form statistical packages. One of the modeling package is GAMS. This package can be accessed thru say a CGI script.

3. Using the processed data, graphs (some need to be in 3-D) are drawn. This application is heavy on charts. Right now since the customer is using... Read more

Read other answers

Hello everyone,
I desparately need your help in this issue:

I am running Sql server 2000 on an NT4 machine, but on Tuesday i got an error message:-

Warning State: S1T00,Native:0, Origin: [Microsoft][ODBC
SQL Server Driver] timeout error

What may cause this sort of error and how t prevent it??
The developers of this product said that a modem dial-in may have caused it. I do not believe this claim, but i needto know what caused and how to prevent re-occurances

thank you


A:Sql Server 2g Odbc Error

check your odbc settings and event viewer.

Read other 3 answers

I have ODBC set up to query data using an INI file, but when I connect remotely it errors out. What kinds of things should I check to see where the problem is.

I have edited the Host file to include the server ip

The setup uses an INI file for the definition file, the TCIP port and also a prefix, but I am not sure if any of those are an issue..maybe the Port ?

I would not normally use a password and one is not saved

Read other answers

i try to install Goldmine ver 9x today on new Win 7 Pro 32 bit PC
When I select SQL as my connection type i get the errror 

"the setup routines for SQL server ODBC driver could not be accessed. Please reinstall the driver"

I have tried to re register the dll  by running " regsvr32 odbcconf.dll "
I have also checked the registry and the values for SQL connection are corrent.
Any idea?

A:ODBC Driver Error

to resolve the case.
Send user copy of
sqlsrv32.dll file
The registry entries a slightly different as those stated in the document.  (http://support.microsoft.com/default.aspx?scid=kb;en-us;260558)
However I was able to match them up with those on a working windows 7 PC.  This seemed to do the trick


Read other 5 answers

I am trying to connect to my database from a company I use. However, I get this ODBC error 3151. They told me to look for the latest version of MDAC, make sure I am running a genuine version of windows, and check for any firewalls. I have done all of the above and still get the error. Any ideas?

A:ODBC Error 3151

Hello iakona55,

okay now , i need to ask some questions

do you ever go to the Windows Update site ?

if not do so and select the custome scan not the recommended

you will be given updates that are not installed thru the auto updater service / you will begiven other patches and updates that all work together with the (mdac)

now are you useing a 3rd party firewall / or the windows default ?

what is its name?

do you have SP 3 installed ?

do you have all the .net frameworks installed ?

please let me know

Read other 2 answers

I installed Windows 7 Ultimate on a PC and I am trying to set up the ODBC drivers to use with Crystal Reports. I ran CR on my XP machine and have the ODBC settings EXACTLY the same on both PCs. When I click 'Apply & Test Connection' in the ODBC Driver Setup window, it gives me the following error message:

Unspecified System Error = -11333
Unspecified System Error = -11356.[Informix][Informix ODBC
Driver][Informix]Unspecified system Error = -931. sqlerrm(idsgtne)

I have already tried to Disable User Account Access and turned off the Windows Firewall and my Anti-virus with no luck.

Any help would be greatly appreciated.

Thanks, Rich

A:ODBC Error in Windows 7

So far out of my area of expertise that I can't even read the documents.
Have a look at this Google search: http://www.google.com/search?q=infor...ient=firefox-a
If that doesn't help, I'd check the support functions at IBM: http://www-01.ibm.com/software/data/informix/

Read other 2 answers

I have Oracle 11i Vision installed on my PC. I normally access the login window by placing http://localhost.apps.com:8002/OA_HTML/US/ICXINDEX.htm in the browser. Lately I’ve been getting message “Internet explorer cannot access the webpage” with this URL. I thought this might be something to do with services in Administrative Tools, so I tried starting all Oracle services. By the way I am using Windows XP. I was able to start all Oracle services except the one called OracleConcMgrVIS. Each time I try I get the error massage “Could not start the OracleConcMgrVIS service on local computer. Error 1067: The process terminated unexpectedly.”

I have the feeling that it might be due to concurrent manager not starting that I am unable to access the login window for Oracle. I am I right? If not, what’s preventing me getting the login window with this URL (http://localhost.apps.com:8002/OA_HTML/US/ICXINDEX.htm)?

Can anyone help? I’ve checked discussions forum and someone mentioned something about checking to ensure that Oracle database is running. If that is correct, how do I check that the database is running? Please remember that I cannot even login to Oracle!

Read other answers

When I am testing an ASP page by Dreamwaever, I encountered an error about my IIS or PWS:

OLE DB Provider error for ODBC Drivers error 80004005
[Microsoft] [ODBC Driver Manager] Data Source Name not found and no default driver specified.

I went to the Knowledge Base at Microsoft site and pull out an article (190006).

My question is that my os happens to be Window 98II and their suggestion seem to be for WindowNT.

How to resolve this. Any help will be appreciated!!!

The following is an excerpt from the article:

The Global.asa file is not located in the root directory of the application.
To determine if a directory is designated as an application root and verify that it also contains the Global.asa file, perform the following steps:
1. In the Internet Service Manager (ISM), verify that the node is configured as an application.

To do this, verify that the node displays the package icon in the ISM. To further verify, view the property sheet for that node. On the Virtual Directory tab, under Application Settings, an active name should be listed for the application. If the name is "Default Application" and it appears dimmed, the node is NOT an application.
2. Verify that the Global.asa file is located in the root directory of the application.

To determine the root directory of the application, view the property sheet for the application. Check the Local Path setting on the Virtual Directory tab.

A:(Solved) ODBC 80004005 error

I would check out the info on Macromedia's site.




Read other 3 answers

When I go to certain secure websites I get an error which reads.. "Microsoft OLE DB Provider for ODBC Drivers error "80040e57"[Microsoft][ODBC SQL Server Driver][SQL server] String or binary data would be truncated. /Includ/utils.asp. line 902"

A:ODBC SQL Driver Error 80040e57

It's an error in the data you're trying to insert, not your code (since it's a SQL server error). Odds are that one of the fields you're trying to insert is too long for its matching database column's size (for example, sending a 35-character value to a database column that will only accept 25 characters).

Your options are: 1) increase the size of the column that's giving you trouble, or 2) somehow shorten the data to fit in the column.

80040E57 error

Read other 2 answers

Hello All,

I've recently migrated servers (NT 4.0 sp6) to Win2k3 Standard, and I now have this error message on a webpage. The problem only occured after the server change. I'm not very well versed in ASP, so any help is greatly appreciated.


Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Qry'. Make sure it exists and that its name is spelled correctly.

/mmsdata/get_block.asp, line 17
-ASP Script-
<!--METADATA TYPE="typelib" FILE="c:\program files\common files\system\ado\msado15.dll"-->
Option Explicit

Dim oCmd, oParam, oRst, intAreaID

set oCmd = server.createObject("ADODB.Command")
oCmd.ActiveConnection = "MMSDB"
oCmd.CommandText = "Qry-Get_Block"
oCmd.CommandType = adCmdStoredProc

intAreaID = CInt(cstr(request.querystring("areaID")))

set oParam = oCmd.CreateParameter("The_Area", adInteger, adParamInput, , intAreaID)
'name of para, type, direction, size, value
oCmd.Parameters.Append oParam
set oRst = oCmd.Execute


<SCRIPT language ="javascript">

function GetStructureName(obj) {
i = obj.selectedIndex;
var strURL = new String;
if (i>1) {
strURL = "" + parent.pltdata.location;
strURL.toLowerCase(); ... Read more

A:ODBC Drivers error '80040e37'

I would check your stored procedure. The only reference to Qry I see is right here: oCmd.CommandText = "Qry-Get_Block" Is that supposed to be an underscore or a dash after Qry??

Read other 2 answers

I am getting this exact error message when I try to run any of the Office programs, IE, MS Project and probably some other programs.

"Error 1919. Error configuring ODBC data source:MS Access Database, ODBC error 6 component not found in this registry. Please verify that the MS Access database exists and that you can access it"

How do I verify and access the stupid thing? Nothing really triggered this, I just opened Project on time today, and ti all of a sudden asked me to insert the cd, and when I did, it loaded something, and then I got that error.

any ideas on what might have caused this, and how to fix it? Thanks

A:Error 1919 ODBC problems.


Read other 1 answers

The computer I am having an issue with is running Windows 7 32bit. It is up to date. When trying to turn queries in Excel 2010 it gets an ODBC License Unhanded Error. The same file works in Excel 2000. I will attach the screen shots of the errors. Other testing I have done is put excel 2010 on an XP computer, and it worked there. I put it on another windows 7 computer that has a fresh install, and it still doesn't work.

Not sure where to look now or what is going on with these errors searched online and couldn't find anything.

A:ODBC License Unhanded Error

When you installed the driver, did you remember to right-click and "Run As Administrator" to elevate your privileges?

Windows 7 uses the UAC (User Access Control) and user applications, including the Windows Shell, are then started with a restricted token, resulting in a reduced privilege environment even under an Administrator account. When an application requests higher privileges or "Run as administrator" is clicked, UAC will prompt for confirmation and, if consent is given, start the process using the unrestricted token.[5]

Running with restricted tokens can result in the registry not being properly updated during installation.

You might even try running Excel "As Administrator" and see if that works.

If it does, you probably need to re-install your driver.

Read other 1 answers

After upgrading from a Win98 to a Win2000 PC, I am unable to refresh data on an Excel file that is on stored on a file server. I get the following error: [Microsoft][ODBC driver manager]Data Source Name not found and no default driver specified I just cancel out or there after that. Funny thing is if I log in as Administrator, I have no problems. So, its pointing to a permissions thing, but don't know enough about this area.
Thank you for your help

A:ODBC Drive Manager error message?

I really have no idea, but I did find a couple of articles regarding this error, which might provide pointers:




Good luck,

Read other 2 answers

i am a begginer in oracle. i installed oracle 9i at my home pc. it was working properly before i try to create another database using Database configuration assistant. after that i tried to login scott/tiger but got following error:

ERROR:ORA-12560: TNS protocol adapter error.

i can work on SQLWORKSHEET ON DIFFERENT SCHEMAS BUT sqlplus.exe gives error mentioned above.i need quick help.......plz


Read other answers

I have developed a problem on notebook regarding doing a mail merge with an Excel file. It says that it cannot establish a DDE Link (or something very similiar to that) and then it defaults out of the pages. I have tried to re-install MS Office 2000 twice now, and it still has not corrected itself. Can one of you Office gurus give me a hand here on this one. This is a feature that I constantly need for work.

Thanks so much in advance...


[Edited by Dreamboat on 04-06-2001 at 12:04 AM]

A:Office 2000: Mailmerge w/Excel gives DDE Error. ODBC anyone?

Open your file and hit the Get data button. At the bottom of that dialog box should be a "select method" button. Click on that before picking your Excel file and then pick the Excel file.

If that does not help, you may have been on the right track reinstalling. I'm sure it's something with ODBC, but I don't know anybody who knows about this stuff (I'm going to reword your topic) and by the time we find out, you might as well have reinstalled it. So, if you don't want to wait, read on...

Also, never reinstall Office without first using Eraser. It's here:


Read other 3 answers

I have a MS Word application which uses a DSN-less connection to access a remote SQL database and which runs properly under a 32 bit OS. However, on my Windows 7 x64 systems with Office 2010 (32 bit) I get the following error when running the application:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I have done a bunch of searching, and have found a number of suggested solutions. The one which seems most likely to work is to install the Office System Driver Data Connectivity Components 2010.

Is this the best approach for solving the problem? If so, should I install the 32 or 64 bit version? If this is not the best approach, what would you suggest?

Thank you.

A:Win7 x64 / Office 2010 - ODBC connect error

i don't try yet Ms office 2010.
but i think the work is same with the other Ms.office
i'm also run the excel and connected to the dbase using ODBC.
did you already add the dbase source in it?

Read other 8 answers

Is there a fix? I checked microsoft and it sounded like changing server config. which I can't do its not mine.Any help? Thanks

A:I get this:Microsoft OLE DB Provider for ODBC Drivers error '80040e21'


Read other 1 answers

HI! I have been trying to install a product called Thumbsplus which was giving me a ODBC Driver Manager Error - Database source name not found and no default driver specified error.

After trying a fews things I starting looking at the ODBC Data Source Manager in windows 8 and noticed that I could not access the System DNS tab. ( I would get a warning " you are logged on with a non-administrator privileges. ) even thought the account Is an administrator account. So I logged off and entered in as administrator and still the same message.

Something is wrong and I suspect it has little to do with the thumbsplus program as I should be able to enter into the system dns tab without receiving this error message.

Can someone plz shed some light on this issue?

PS: If I say OK after the dialog message the manager with open up and allow me to click the add button but since I dont know how to add the apropriate info there I did not go further, hence to say the error message probably did cause thumbsplus to not install correctly.
Here is a video of what happens http://www.webcandesign.com/bugs/odbc.mp4

A:ODBC Driver Manager Error - Database source name not found

The "non administrator" message you are getting is very annoying but it will still let you add a system DSN. It is a known issue but nothing something you should be worried about in this instance.

That being said, I just installed the application in question and was able to without issue. It also didn't create it's own DSN. During my installation I selected the first option for the database creation "Shared database but separate settings"
This creates a Microsoft access Jet database in "C:\ProgramData\ThumbsPlus" folder.

Not sure if this matters, but do you have MS Office installed?

Read other 10 answers

Mac OS X 10.6.1
perl 5.8
mysql 5.1
Installed ODBC connector: http://dev.mysql.com/downloads/connector/odbc/5.1.html#macosx-dmg
I am trying to connect to a mysql DB using the perl API.

The connect command looks like this:
$dbHandle = DBI->connect("DBI:ODBC:gfr:localhost", "gfr", "gfr");

It produces the error:
DBI connect('gfr:localhost','gfr',...) failed: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (SQL-IM002) at x.pl line 30
error = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (SQL-IM002)

I'v done hours of rummaging around the web to find a solution but to now avail.

In desperation I executed the following "find" command:
cd /
sudo find . -name "*odbc*" -print

It produced the following output (only relevant part shown):
./usr/local/li... Read more

A:Solved: mysql connection using ODBC fails with error SQL_IM002

By using a combination of the information at
and the link within that page under "these simple instructions" (http://www.truerwords.net/articles/osx/install_dbd_mysql.html)
I managed to get DBD working instead of ODBC. That is sufficient for me.
I did the above with one difference. I used a later version of the latest non-beta DBD module.

Read other 1 answers