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.24 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-06-03 10:43 Message: Logged In: YES user_id=43607 Originator: NO For the upcoming release (target: this month) I have removed the ODBC driver from the MonetDB5-SQL installer. Now you need to install the ODBC driver separately. I have also made the 32-bit and 64-bit versions into independent packages (so that installing the second doesn't remove the first). I installed first the 64-bit version and then the 32-bit version, and I was able to use both the 32-bit and 64-bit versions of the test program I have without having to change any registry entries. When I look with the registry editor, I see the entries you mention already contain the correct paths. Brad, if I give you the two driver installers, can you test whether you still have problems? ---------------------------------------------------------------------- Comment By: Brad Denney (bdoglo) Date: 2008-04-22 22:29 Message: Logged In: YES user_id=1211469 Originator: YES I still was having problems with this, but I seem to have a work-around solution which you could use as a guideline for future versions of the installer (if you think it is appropriate). In order for everything to work properly, the 32-bit and 64-bit ODBC drivers should both be installed. To do this I first installed the SQL-64 version with the ODBC driver option checked. I then installed the 32-bit ODBC driver. The problem this creates is the installation causes ODBC to look for both drivers in the same place (and with the same name). You need to fix where ODBC is looking by going into the registry and editing the following entries: With regedit go to the registry heading: My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\MonetDB ODBC Driver + Change the "Driver" entry to the 32-bit installation path. In my installation this was: "C:\Program Files (x86)\CWI\MonetDB ODBC Driver\lib\libMonetODBC.dll" + Change the "Setup" entry to the 32-bit setup dll path. For me this was: "C:\Program Files (x86)\CWI\MonetDB ODBC Driver\lib\libMonetODBCs.dll" +Also change My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MonetDB\Driver to the 32-bit driver installation path, which for me was: "C:\Program Files (x86)\CWI\MonetDB ODBC Driver\lib\libMonetODBC.dll" Next I changed the 64-bit driver and setup paths under the registry heading: My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MonetDB ODBC Driver + Change the Driver entry to the 64-bit installation driver dll path. For me this was: "C:\Program Files\CWI\MonetDB5\lib\libMonetODBC.dll" + Change the Setup entry to the 64-bit installation setup dll path. For me this was: "C:\Program Files\CWI\MonetDB5\lib\libMonetODBCs.dll" After all that you should be able to add working data sources from the ODBC administrator found in Control Panel/administrative Tools. I tested it in Excel with the example given in the documentation and it connected just fine. ---------------------------------------------------------------------- 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: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
