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

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

ODBC 32bit is launching 64bit ODBC administrator. No menu opens 32bit.

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server
In Windows 7 maybe all 64bit OS's are setup for 2 different types of ODBC connections.  Try running these and adding your connection in one or the other.
I have not found the navigation for each version as the control panel I think uses 64bit even the one marked 32bit seems to be pointing to 64bit.  There is no visual key that tells you which one you are using.  If you add a key called 64bit and then click the 32bit icon you still see the 64bit.  Most applications will use the 32bit ODBC so you will have to manually navigate to add connections.
To setup an ODBC link for 32bit application you must use
To setup an ODBC link for 64bit application you must use

My question is why does the 32bit icon point to the wrong one?  Is there a KB or update for this?

View Complete Post

More Related Resource Links

C# target 32bit and 64bit desktops with SMO included

I have an application that uses three SQL 2008 R2 SMO assemblies.  I need to target 32 and 64 bit machines that are running either 32 or 64 bit versions of SQL 2008.  I have no idea how to handle an Any CPU build for the application.  Since the SMO assemblies are either 32 bit or 64 bit, do I have to create a 64 bit build of my app and also a 32 bit build of my app.  I have no idea how to proceed with the build at this point.  This is my first app to support 64 bit machines and servers; I have only had to work in 32 bit in the past. Also, I do not know where the best forum for this question would be.  It is not a SQL question unless the answer is in the SQL assemblies.  I am developing on 64 bit Win 7 with VS 2010 and .Net 4. The C# app is wpf. The application needs to run on 32  and 64 bit Vista machines with 32 and 64 bit SQLExpress 2008 instances, and it also needs to run on 2003 and 2008 32 and 64 bit servers running 32 and 64 bit SQL 2008 servers. Any help would be appreciated.  I expect that I don't know what I don't know on compiling apps and including assemblies in an Any CPU world. Thanks, LD

SharePoint 64bit + 32bit Office JET Drivers?

Hi Guys, I'm in a bit of a pickle here! I have a document library which contains Excel files on Moss 2007 (64bit). When a file gets upload to the library, a workflow kicks off with some custom activities I've wrote in C#. One of the activities opens the SPFile object (the Excel data) for the SPListItem object thats currently been added. It dumps the stream to a temp file on the hdd (a random .xslx file) and attempts to open it.... but i get this error:   The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.   So i dig about a bit and it turns out there is no 64bit jet drivers for windows 64bit. If i compile my activity to 32bit, it doesnt seem to be able to interface with the 64bit installation of sharepoint!!   What can i do to get round this?!   Many thanks! Will

64bit/32bit UDL properties editor?


I'm used to creating udl files and using the built-in Data Link Properties editor. But now I have a 64bit workstation, and when I open a udl file with the editor, it only gives me a list of 64bit drivers.

Is there a way to open a udl in a 32bit editor?


Migrating Jobs: SQL 2005 32bit > SQL 2005 64bit


I am trying to migrate jobs between SQL Server 2005 32 bit to SQL Server 2005 64bit.  I follow the steps in the KB Article to copy a job by scripting it and then running the SQL against the new server.  The query executes fine, but it only creates a skeleton of the job with nothing in the body.  There is no schedules, steps, name, etc.  The resource versions are different and tonight my plan is to apply the service packs to ensure there is no discrepency in either version.  Also these are all TSQL jobs not DTS packages.  Any ideas?

can we install SQL Server 2008 R2 - 64bit on Window Server 32bit?

can we install SQL Server 2008 R2 - 64bit on Window Server 32bit?

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

Basic ODBC Connection to connect to Crystal ???


I have visual studio 2008 professional with the inbuilt crystal reports version 10 I think.  I create everything from my laptop and IIS runs from my laptop as well.

I have created the most basic report to try and figure out a problem I have, anyways the report contains one database field that is it .... which I connect to by ODBC.  I then create a web form add the crystal report viewer to the report and the crystal report source run the web page and it loads the data from the field as I would expect to the crystal report viewer !!

I have several ODBC connections setup on my machine one using integrated security the other using SQL authentication both are system DSNs.  Now when I publish my application and access it from IIS and not the localhost I can access everything from my application ok except when I go to form that has the crystal reports I get this error (ODBC used here is the 'sa' account)

Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error in File

If I use the other ODBC that uses Windows authentication I get this error message

Logon failed. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database  requested by the login. T

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>

SQL Server doesn't exist or access denied while connecting with Access 2010 ODBC

Hello all. I am using Access 2010 and SQL Server 2008 (locally). I can easily connect to server using SSMS and it works excellent. But when I want to import a table to Access 2010 using ODBC, it says that "SQL Server doesn't exist or access denied". It worked previously - almost 3 days ago, but now, it doesn't! Please help! Thanks Mohammad Javahery

Can't Create ODBC to Local SQL Server Express 2008

Hello. I have SQL Server Express 2008 SP1 LOCALLY on my Windows XP Professional SP3 box. I have databases already created in Access 2007 that I imported into SQL. Now I want to keep the front end Access forms for data entry but have them connect to the databases in SQL. What I can't seem to do is connect from Access to the SQL db's because I can't create the ODBC connection. When I try to connect, I get the following two 'Connection failed' errors: 1. SQLState: '08001' SQL Server Error: 10061 [Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it. 2. SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][SQL Server Native Client 10.0]Login timeout expired Additionally, this information may help. 1. Windows firewall is turned off. 2. In SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS, Shared Memory, Named Pipes and TCP/IP are all 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). 3. In SQL Server Configuration Manager > SQL Native Client 10.0 Configuration > Client Protocols, the above three are also 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). Double-clicking TCP/IP tells me that the default port is 1433. 4. Running "netstat -ano", I see no entries for [myIPaddress]:1433.

Connectivity Issue through ODBC

Here's the scenario: On the server: (Windows 2003, sql server 2005 sp 3) 1. named server is running on port 1433 2. all protocols except VIA is enabled 3. Remote Connections is enabled for both tcp and named pipes on surface area configuration 4. SQL Browser is running 5. Windows Firewall is disabled 6. Network firewall has allowed TCP traffic to port 1433, one way. 7. can ping the client 8. Local Securty Policy to access this computer from the network is permitted to everyone 9. SQL User and windows user can login to the server 10. No login failed connections on the error logs On the client: (WIndows XP sp2) 1. server can be ping 2. telnet server 1433 is successful 3. NSlookup can resolve server name 4. System DSN and USer DSN using SQL Server driver works to other servers Creating a DSN to the server results to Connection Failed:  SQL State 01000' SQL Server Error: 53 [Microsoft][ODBC SQL DRIVER] [DBNETLIB] CONNECTION.OPEN(CONNECT()). CONNECTION FAILED SQL STATE '08001' SQL SERVER ERROR 17 [Microsoft][ODBC SQL DRIVER] [DBNETLIB]Server Does not Exists or access is denied. What am I Missing here?

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

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.    

SQL Server 2008, ASP Classic, IIS and ODBC.

Hi.   I'm using Windows XP SP3 SQL Server 2008 Login:sa Password:12345 http://img2.pict.com/9d/b2/65/3153366/0/sql.jpg   ODBC - Am I doing it correctly? http://img2.pict.com/ee/6b/8b/3153363/0/800/odbc.jpg   Loading the 'Main.asp' file and got this error;   http://img2.pict.com/cd/8e/ad/3153435/0/800/ptb.jpg   Line 106 refers to the underline text below; (cn.Open "DSN=Trains;UID=sa;PWD=;DATABASE=Trains") &lt;%@ Language=VBScript %&gt; &lt;% Response.Buffer = True Response.Expires = -1000 %&gt; &lt;HTML&gt;&lt;HEAD&gt;&lt;TITLE&gt;Main Page&lt;/TITLE&gt; &lt;base target="_self"&gt; &lt;BODY bgProperties=fixed bgColor=#FFFFFF leftMargin=0 topMargin=0 bottommargin10&gt; &lt;DIV style="LEFT: 5px; POSITION: absolute; TOP: 80px"&gt;&lt;/DIV&gt; &lt;style type="text/css"&gt; body           {font-size: 8pt; font-family: verdana; color:white;} table, tr, td  {font-size: 10pt; font-family: verdana; color: black;} a:link         {font-size: 8pt; font-family: verdana; color:black; text-decoration: none;} a:visited      {font-size: 8pt; font-family: verdana; color:black; text-decoration: none;} a:

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
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