Mysql Odbc Driver 32-bit

[James Talbot]

Ihave a 32-bit application that must run on a Windows x64 server using a 64-bit version of MySQL.

Should I use a 32-bit ODBC driver or a 64-bit ODBC driver?

Or should I install a 32-bit version of MySQL too?

To work around this problem, use the appropriate version of the ODBC Administrator tool. If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe. To indicate the type of DSN, you can add "_32" to the 32-bit user DSNs and "_64" to the 64-bit user DSNs.

When I look at the ODBC Data Source Administrator on my desktop (where the query fails), the drivers tab shows 2 MySQL drivers: MySQL ODBC 5.3 ANSI Driver and MySQL ODBC 5.3 Unicode Driver. I tried uninstalling the MySQL drivers and installing the latest MySQL drivers with the same error.

Sounds like a bug in Toad Data Point. We bundle our own mySQL drivers, so the error you are getting should not be a problem. What version are you using? Can you download the latest Toad Data Point, which is 4.1?

Yes, I am attempting to run the query in TDP. Yes, windows is a 64 bit version. I did uninstall the MySQL ODBC drivers, and installed the 64 bit MySQL ODBC drivers. The download file is entitled: mysql-connector-odbc-5.3.7-winx64. Do you think I need to reinstall using a different file?

Possible reason(s):

ADO Error: 0x80004005

Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application in NI_Database_API.lvlib: DB Tools Open Connec (String).vi->NI_Database_API.lvlib: DB Tools Open Connec (Path).vi->Untitled 1

I have included a screenshot of the code with the error message. The questions becomes, what do I need to do to fix it, and how do I have it point to the User DSN I created? It looks like you can create a File DSN, but that doesn't seem to get many anywhere either. I am confussed how I would wire the User DSN to the open connection vi so I don't have to have the prompt always come up. When I 'test connection' from the User DSN config window from the Admin Tools in Control Panel, I connects without issue, so it would appear to be that tring to make the connection from Labview is the problem. I do have a user ID and password, and I saved them in the User DSN config, do I really need to re-enter them at the Labview level? I guess the thing that jumps out me here is that it says it has a mismatch, I am trying to use the latest driver (5.1), and the example above is using MySQL ODBC 3.51. Does this cause a problem with the 'Microsoft OLE DB Provider for ODBC Drivers'?

So my issue might be 64 vs 32 bit ODBC driver. I know that installed the 64 bit driver. I will download and install the 32 bit tomorrow. I did forget to mention that I am using a 32 bit version of Labview. It does beg the question do I need to use the 32 bit version of MySQL as well, or is the driver able to talk to a 64 bit database server? Basically everything needs to be 32 bit?

Yeah, this issue is solved, definitly have to use all 32-bit pieces if you are using 32-bit labview (seems obvious, but with the new single installer they have at MySQL for Windows it trys to act smart and install whichever type matches your OS).

One little note, to configure a DSN file using the 32-bit driver, you have to use the 'C:\Windows\SysWOW64odbcad32.exe' because the normal one you run from Admin Tools does not list the 32-bit version of the MySQL ODBC driver. At this point, I could point to the file, and get everything running without issue both locally and remotely.

Let me ask the simple question first. Are you running a 64-bit version of Windows? When I open the windows folder, I see the sysWOW64 listed right under the system32 folder. The next step (which I am slightly unsure of) did you already install all the 32-bit pieces needed for MySQL? I am looking currently at a cleanly installed Windows 7 (no MySQL), and I don't see the sysWOW64odbc.exe that I listed. So I assume that executable must be installed when you perform the MySQL install. That is probably a poor assumption on my part.

THAT very well be what I need to do is install the 32 bit of mySQL!! That is my fault, the way I read your posts I assumed that the WOW64 was already there. Ok, I will look at getting that installed and going from there, Thanks!

I have a spreadsheet that is tied to a MySQL table and it gets updated when you click the update button in excel. I have installed the mysql drivers and such and it works fine on all machines except this laptop.

What happens is that you have a 64 bit operating system, which usually comes with a more modern equipment, and specially a 64 bit server OS, which is most likely to be the case, and you need to install an ODBC driver that would work with a 32 bit application.

On the other hand, if you try to install the 32 bit driver, the system will not recognise it, and it will not appear in your default Data Sources (ODBC) inside the control panel, so you will not be able to configure it and connect to MySQL.

Here you will be able to see your 32 bit ODBC driver and configure it to connect with the MySQL database, in the same way as you would do on a 32 bit system. That was all about installing and configuring MySQL ODBC 32-bit driver on 64-bit PC. Stay tuned for my next post on using MySQL ODBC driver with C# Application.

I am looking for advice about installing CIP in my company. My goal is to have a central database residing on a Linux RH server station running mySQL and having installed an ODBC interface to communicate with the clients.

- is the CIP-E / CIS Database (SQL) in the middle a database running on my Linux machine, then a mySQL database whith ODBC shell? I see in the picture "SQL 2005 or later" so I assume that a Microsoft SQL server is needed right, right? But I am supposing that a combo of ODBC+mySQL will also do the job

I am really confused by this architecture diagram ... anyway I tried to move on so I installed the ODBC drivers for Linux RH from -us/download/confirmation.aspx?id=36437# and I installed them on my company server machine .

Then I am reading "Before you begin" and I see 'Gather required inputs, such as the Database Server name, Web Server name (if not the same as the Database Server), Database User Credentials, and the Centralized Location that will house the Cadence OrCAD Capture Symbols, Allegro PCB Footprints, Technical Datasheets and other essential files)'. I have no clue how to determine these names: do they pre-exists? probably the Database Server name is the IP address of the machine where the web server resides (or the CIP-E / CIS database of Figure 1??). Overall there is a lack of examples in this manual :(

Page 17 is a key page: I think I fall into this case "If you plan on using separate Database and Web Servers to host the CIP Database and CIP Web Engine, you can remotely install the Database to a desired SQL Server Instance" How can I remotely install blah blah blah? I look at Figure 10 now: what is ? is the \\ of the machine where the ODBC+mySQL demon is running? on my linux machine I installed the ODBC and added two users to mySQL so I was thinking it was sufficient for Figure 8 (I check SQL server authentication using login ID and password below" but it does not work: I get the message box telling "There was an error logging in to Microsoft SQL server. Error [DBNETLIB] ConnectionOpen ... blah blah". So the installation program is looking for a Microsof SQL server. That means ODBC does not work? Is there only one SQL server in the game, residing in the CIP-E/CIS database right?

I tried to run CIP-E Starter Library first, with no success :( What is the name of the database catalog? Should I choose it and upposedly the instalaltion program will populate it by connecting to cadence? I choose one (but I see a browse button which makes me understand this is already existing: very confusing again) and go: now I get a different error "there was an error logging on to Microsoft SQL Server (it is STILL looking to a Microsoft server!) ... Specified SQL server not found"

OrCAD Capture CIS running on Windows, using a MySQL ODBC driver communicating with a MySQL database running on Linux, possible. Refer to the cisug.pdf, in the doc\cisug directory of the Cadence SPB product installation, chapter on Setting Up OrCAD Capture CIS, your database will require, at least the four required fields, and any others that you need for your requirements, when you set up the ODBC connection, use the MySQL driver and configure that. You will need to configure a 32-bit ODBC source if you are running a 64-bit Windows edition. What is behind the ODBC configuration is transparent to OrCAD Capture CIS.

CIP is built to use Microsoft Windows based technologies, Microsoft Internet Information Services as the web server and Microsoft SQL Server as the database, these are listed as "requirements" in the CIP documentation. You can run OrCAD Capture CIS, Microsoft IIS and Microsoft SQL Server on the same client machine but this configuration is probably not too great for a multi-user environment. You can run Microsoft IIS and Microsoft SQL Server on the same machine for CIP, if required, you don't need to have dedicated Windows Server hardware for each function.

Deploying CIP may cause you to convert your existing CIS database to their schema structure. But, their database expert brilliantly designed their schema. The whole solution turned out to be the top reason to switch this company from Mentor Graphics.

The choice of operating system only matters where you deploy the CIP service. CIP is written to only work with Microsoft IIS web services. While it uses Java, it's a Microsoft executable. For a large number of users, investement in a MS-Server OS license will pay off.

3a8082e126