Bugs item #1944336, was opened at 2008-04-16 22:06 Message generated for change (Comment added) made by sjoerd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1944336&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/ODBC Group: Clients 1.22 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Brad Denney (bdoglo) Assigned to: Sjoerd Mullender (sjoerd) Summary: x64 ODBC system error 193 Initial Comment: I am running MS Win XP x64 SP2 with Intel Xeon CPU's. The ODBC driver appears to install but whenever I try to connect to a ODBC datasource I create, I get system error 193. This happens with the install from: MonetDB5-SQL-Installer-x86_64-20080214.msi I also tried not installing the ODBC driver in the installation and installing it seperately, but the same error occurs. ---------------------------------------------------------------------- >Comment By: Sjoerd Mullender (sjoerd) Date: 2008-04-22 14:16 Message: Logged In: YES user_id=43607 Originator: NO On Windowx XP x64 there are two versions of the ODBC Data Source Administrator program, a 32 bit version and a 64 bit version. Search for the file odbcad32.exe on your system. I found one in C:\WINDOWS\System32 and one in C:\WINDOWS\SysWOW64. The two give different lists of available ODBC drivers, so in only one of them you will find the MonetDB ODBC driver. Of course, the program you get by default is the 64 bit one, so you won't see the 32 bit driver. I hope this helps. ---------------------------------------------------------------------- Comment By: Brad Denney (bdoglo) Date: 2008-04-18 22:08 Message: Logged In: YES user_id=1211469 Originator: YES Okay, I installed MonetDB-SQL-64 without the ODBC drivers. I then ran the ODBC-32 installation. The lib folders of the ODBC files had the files you mentioned that were missing and the size and dates were identical. But just in case I copied over the two DLL's from a copy of them from a prior MonetDB-SQL-32 install. The problem I have is the 32-bit drivers never show up in the MS/ODBC Data Sources tool. I would be happy using the 32 bit version of MonetDB-SQL if I could get the ODBC drivers working. When the 64-bit drivers were installed they showed up in the drivers list of the "Data Sources" tool even though I couldn't use them with my 32-bit apps. Any ideas of how I can get this working? ---------------------------------------------------------------------- Comment By: Sjoerd Mullender (sjoerd) Date: 2008-04-18 20:15 Message: Logged In: YES user_id=43607 Originator: NO The missing DLLs are zlib1.dll and iconv.dll. You can get them from a 32 bit install of MonetDB5-SQL or MonetDB4-XQuery. They are in the lib subdirectory of the installation, and they should be placed in the lib subdirectory of the ODBC installation. Do make sure you get the bit widths right! You should probably also not have a 64 bit version of the ODBC driver installed next to the 32 bit version. In other words, when you install the 64 bit server, say No to the question whether you want to install the ODBC driver. I hope this works. I haven't tested the official distributed versions. I compiled new ones and tested with those. ---------------------------------------------------------------------- Comment By: Brad Denney (bdoglo) Date: 2008-04-18 18:28 Message: Logged In: YES user_id=1211469 Originator: YES Thanks for the comment. Okay, so I need the 32 bit driver for my 32 bit apps. That makes sense. What are the missing files I need for the ODBC-32 driver working (when using the 64-bit server) and where do I find them? Or are the ODBC installers going to be updated? ---------------------------------------------------------------------- Comment By: Sjoerd Mullender (sjoerd) Date: 2008-04-18 16:57 Message: Logged In: YES user_id=43607 Originator: NO I can't reproduce the error message. Can you produce details on what exactly you did to get this error message? One of the things to keep in mind here is that if your ODBC using application is 32 bits, it needs the 32 bit ODBC driver. The driver that is part of the 64 bit SQL installer is a 64 bit driver, so can't be used with 32 bit applications. However, I have found that there are some problems with the separate ODBC installers (both 32 and 64 bit). These installers are missing two DLLs that are essential for operation. Loading the driver by the ODBC driver manager will fail due to the fact that these DLLs are missing. After I fixed the bug with the installer I was able to use both the 32 bit and 64 bit ODBC driver on a 64 bit system (Windows XP Professional x64 Edition). I have tried this with a small test program that is part of our sources (both compiled for 32 and 64 bits) and with Excel importing data from a database query. Excel with the 64 bit driver does not work since it is a 32 bit application (is there a 64 bit version of Microsoft Office?). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1944336&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
