.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

ODBC--call failed.[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismat

Posted By:      Posted Date: September 12, 2010    Points: 0   Category :Sql Server
I need to establish a connection between an Access 2003 database (32 bit) and an 11g 64 bit Oracle database on a server. I am running Windows 7 on a 64 bit laptop. I did a clean install of Oracle 11g for 64 bit. I have no problem accessing the Oracle database via the Oracle SQL Developer. I just have a problem from within Access. I hope someone can help me. I've been fighting this for several months. Thanks in advance!

View Complete Post

More Related Resource Links

"Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no def

When i attempt to fill my Crystal Report -named limitler.rpt and it is under the sub-folder Oraburslar of my project -, i get the following error; "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Error in File C:\DOCUME~1\KEMAL~1.ESM\LOCALS~1\Temp\limitler {148B6FE6-D5BE-4BC3-A13A-47CCCB79D78B}.rpt: Unable to connect: incorrect log on parameters." How can i handle this pro? Thanks in advance... Here is how i connect to database to fill the Crystal Report:string database = ConfigurationManager.AppSettings["Database"].ToString(); string password = ConfigurationManager.AppSettings["Password"].ToString();string username = ConfigurationManager.AppSettings["Username"].ToString(); string server = ConfigurationManager.AppSettings["Server"].ToString();ReportDocument report = new ReportDocument();report.Load(Server.MapPath("~/Oraburslar/limitler.rpt")); report.SetDatabaseLogon(username, password); CrystalReportViewer1.ReportSource = report; CrystalReportViewer1.BackColor = System.Drawing.Color.White;

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


trying to install sql server2005 on a windows 2003 server box.

getting msg below at the sql server .  i looked at other posts on trying to uninstall  SQL Native Access Client and norton antivirus.  i could never find the snac on the add - remove programs and this server does not have a virus protection program yet.

here's the history of the installs on the server:

wanted to test a 2005 upgrade so:

  1) installed sql server 2000 then sp4 then restored some databases to it - all OK

  2) tried to upgrade to sql 2005 but ran into problems and left it at that.

had a disk drive crash on the d drive so lost the installs but not the operating system

when the drive was replaced, left alone for a while

then wanted to test a straight 2005 install

  1) removed the broken 2005 attempt

  2) removed the 2000

  3) installed 2005 and got the error on the subject line:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in S

[Microsoft][ODBC Driver Manager] Data Source name not found and no device driver specified

I get the above error message when running my VB6 sp4 application on a new Win7 workstation (32 bit machine). The app runs fine on a WIn xp sp3 workstation. The app does require a DSN setup in the ODBC section and I setup the SQL connection the same as I do on an XP machine. I also test the connection on the WIN & machine and it "test successfully". After the error above the app returns a runtime error -2147467259 (80004005). I am attaching my connection string:
Connection string being used by ADO Data Control (part of VB6):
Any help would be appreciated.


ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).


I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
Stack Trace: 

[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

ODBC call failed

I try to export a table from Access 2007 to SQL-Server Express 2008R2 and it returns the error: ODBC call failed. [Microsoft][SQL Server Native Client 1.0][SQL Sever] Line1: Specifed Scale 1 is invalid (#1002). The problem is related with a datetime column, because if I drop this column it is possible to export. Thanks for your help.    

Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not e

Hi All, When we try to connect to a sql server 2000 using SQL server authentication, we are facing the below mentioned error msg. "Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied" But, once we connect to server using Windows NT login from the client machine, i.e., execute the below command in the run prompt and provide the credentials for windows login, we are able to connect to the server using sql server authentication(user name: sa) \\server_ipaddress\c$ When we went though some of the msdn links, found that windows firewall was the major cause. But, in the server 1. Windows Firewall is turned off 2. TCP/IP and NamedPipes are enabled 3. Default Port Number is 1433 Any user, who wants to connect to the SQL Server using SSMS, first have to perform a Windows NT login and then connect using SQL authentication.  Due to the above error, the DTS packages which are executing in a different server are getting failed. NOTE: Even after connecting to the server using Remote Desktop connection in a local machine, SQL authentication fails. Its manadatory to run the command \\server_ipaddress\c$ in each of the local machine. Any suggestion to resolve the above error is very much appreciated.   Thanks in advance, Raksha Hegde       

64 bit ODBC driver for Microsoft Access

Hello,I am trying to connect to one of my Access databases (.mdb file on my local) from ODBC connection. The problem is, I am using 64-bit Xp Pro and it does not see any Access driver on 64-bit architecture. Does anybody have 64-bit compatible ODBC driver for Microsoft Access ? Any other help also will be appreciated....

ODBC Call Failed - Error 3151


We have an Access database migrated from Access 97 to Acces 2007 with some linked tables to an SQL Server 2008 database. We are using a File DSN in the ODBC Administrator. Connection tests work fine there. In fact, we have a main form in the Access 2007 application that shows the data always correctly. The problem appears when we execute a task that makes the following call:

Dim dbs As Database
Dim rstAppend As Recordset

Set dbs = CurrentDb
Set rstAppend = dbs.OpenRecordset(strAccessTable, dbOpenDynaset, dbSeeChanges)

OpenRecordset throws the error number  3151 and occurs randomly but it appears quite frequently.  It's sporadic. When we don't get the error, the task works fine.

  1. It not happens always, mosty we're fine.
  2. When it happens it happens for all subsequent tasks tried. We have to close and reopen the Access database and pray to the good Lord that it works.

odbc call failed


when i try to run a query appeare the next error:

ODBC Call Failed

The query is a JOIN with a table on SQL Server 2005 and another query in the same project Access. I can read the query and table alone without any error and with tha same ODBC, when i JOIN this element appeare this error. My access version is 2007 and SQL Server is 2005 SP3.
How can i solve this situation?

Enrico Zerilli


EZ BizTalk Specialist

ODBC Call Failed


when i try to run a query appeare the next error:

ODBC Call Failed

The query is a JOIN with a table on SQL Server 2005 and another query in the same project Access. I can read the query and table alone without any error and with tha same ODBC, when i JOIN this element appeare this error. My access version is 2007 and SQL Server is 2005 SP3.
How can i solve this situation?

Enrico Zerilli


EZ BizTalk Specialist

Microsoft Paradox Driver ODBC


Is it possible to install  and where do I obtain the Microsoft ODBC Paradoc Driver for Windows 7? I can't seem to locate it in the ODBC Datasources Administrator like I could in WinXP and Vista on the drivers Tab.

Thanks Jon

Thank You Jon Stroh

persist security info not available by a codebase odbc driver



I want to interface the software Sage ventpartner with sharepoint.

For that i have to use the odbc {codebaseStand} driver and i know that the following string is working :


The pb is when i construct my bdc xml file i have to enter :

        <Property Name="rdbconnectionDriver" Type="System.String">{CodeBaseOdbcStand}</Property>
        <Property Name="rdbconnectiondbq" Type="System.String">c:\ventpart\database</Property>
        <Property Name="rdbconnectionuid" Type="System.String">administrateur</Property>
        <Property Name="rdbconnection Trusted_Connection " Type="System.String">yes</Property>
        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">Odbc</Property>
        <Property Name="SsoApplicationId" Type="System.String">23</Property>

ODBC Driver for SQL Server Compact Edition

I know that there is no ODBC driver available for SQL Server Compact Edition version 3.5.  Do you plan to add an ODBC driver in future release? If yes, is it high in your priority list?   The scenario why I am looking for an ODBC driver is to connect an MS Access application to a SDF file instead of MDB file.  This will enable me to easily sync the SDF file with SQL server repository using the new Data Sync Services.   Mario Cardinal MVP Solutions Architect

OMPM script cannot find ODBC Driver

I'm setting up a local OMPM (Office Migration Planning Manager) application, which requires an SQL Server database. I installed SQL Server Express successfully. When I run the OMPM script to create the database (CreateDB.bat) I get the following error: SQL-DMO Install Required: This operation requires the SQL Server ODBC Driver, version 3.80 or later, which comes with SQL Server 2000, SQL Server 2005 and SQL Server Express. I installed SQL Server Express with this file "SQLEXPR32_x86_ENU.exe" Could it be that the ODBC Driver was not registered correctly during the install of SQL Server Express? Alternatively, where can I find the missing driver? Thanks in advance, Maurice

odbc connection failed

i have microsoft sql server 2000. i am using program based on VB.when i try to run the components like  import database design, link table, etc then the message get displayed " ODBC connection failed".please give me the solution.please.....

[OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Distributed transaction enlistment fa

Ok, i have seen tons of articles on the error, but still can't figure it out. This is being executed through nested procedure calls, until it is roughly 3 levels deep, then makes a call to Sybase using dynamic SQL and OPENROWSET. The message that is returned is listed below. Yes, i looked up all I could find on it. The thing I find interesting is I can simply take the dynamic SQL and the openrowset call out and run it in query analyzer just fine. but when I run it through the procedure it generates the errors. Any thoughts?   [OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Distributed transaction enlistment failed.] Server: Msg 7391, Level 16, State 1, Line 1 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. [OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Load of XA library failed.] OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]. John M. Couch Insight Enterprises Inc. 6820 S. Harl Ave, Tempe, Az 85283 Email: john.couch@insight.com

Bug in ODBC SQL Server driver (SQLFetch hangs)

I have come across a bug in the ODBC driver for SQL Server when working against SQL Server 2008 64-bit with TDE where tables contain text-datatypes. We concluded that it is a bug after testing a simple SQL query using Microsoft ODBC test tool (odbcte.exe) and the workaround for us was to start using the "SQL Native Client 10" instead. However I would like to share this information if someone else come across this problem. Below I will describe the problem in more detail. The table has three columns with text datatypes and we use a simple select query against this table to return about 10 rows of data but SQLFetch hangs before all data is returned. It is unfortunately very difficult to reproduce the errror since even a very small change will change the behaviour. If we for example add or remove a column to the select statement then the problem will dissappear, if we call SQLBindCol before instead of after SQLExecute (or the other way around) the problem will dissapear, if we change the WHERE-clause to fetch a different set of rows the problems will dissapear. We have seen the problem though with a number of different SQL queries so it is reproducable.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend