|
This is a follow up question to my original SQL Anywhere Client: where is it? question. I recently had the need for an x64 install of the ODBC drivers and the OLEDB drivers for SQL Anywhere 11. I figured all I had to do was run the Deployment Wizard, but I found out that the Deployment Wizard does not have an option to generate a 64 bit msi. After Googling I found documentation on manual rolling out the client in "dbprogramming_en11.pdf", one of the pdf files that come with SQL Anywhere. The process seems incredibly convoluted and complex. Also, with this method it does not seem like I am generating a neat msi package that I can hand over to our administrators. Rather than try and program something, I found that the easiest and quickest way to get to where I needed to be was to just install a developers version of SQL Anywhere. At least that got me all the client software installed and registered, but this can't be how the rest of the world does this, can it? And we can't be the first to want to install x64 drivers for SQL Anywhere? What am I missing? Edit: I just found out that, unlike what the doccumentation says, the SQL 12 Deployment Wizard does allow me to create a 64 bit deployment. Is there any way I can use that to create a SQL 11 deployment (is there even a difference or would it just work?) |
|
So you are running 64 bit applications (which is still rather rare, methinks)? In this case I guess Calvin's answer to your original question should work for 64 bit, too, except that you would have to use files from the bin64 sub folder and extend this to use OLEDB files, too, i.e. to include
and to register the first both files, too. Note: I have not tested this myself, and I'm unaware if there's a 64 bit regsvr32.exe to be used to register these DLLs (as in the odbcad32.exe 32/64 bit confusion)... Comment Text Removed
Comment Text Removed
1
With regsrv32.exe MS introduced the same naming confusion as with odbcad32: %WINDIR%System32regsvr32.exe is for 64-bit dlls, while %WINDIR%syswow64regsvr32.exe handles 32-bit Files. Otherwise you'll get error messages. I am NOT running 64 bit apps, just a 64 bit OS. I still need a 64 bit installation as the generated 32 bit msi generated by the deployment wizard does not work! @Robert: AFAIK a 32 bit app running on a 64 bit OS still needs its DB client APIs in 32 bit. Therefore a Deployment Wizard generated 32 bit client API install should do (and does in my case). @Volker: Interesting. In all the experimenting we did to get things to work, and after your comment, I am now unsure if I actually saw the 32-bit client fail, or if I drew a wrong conclusion along the way. We will give installing the 32-bit drivers a go before we try anything else. I will report back! @Volker: I have generated the 32-bit msi, both from a 32 bit and a 64 bit platform, and tried to install it on the 64-bit server. I do not see my SQL 11 ODBC driver when trying to add an odbc datasource. When I install the developer version it is right there. When I run that same msi on a 32-bit platform it is right there as well. Disappointed... @Robert: Are you sure to use the correct 32-bit version of the ODBC administrator, i.e. %WINDIR%syswow64odbcad32.exe (see Reimar's comment above)? @Volker: With the msi I do not really get to choose what regsrv gets used. And when I installed the msi, and then manually afterwards registered the 2 dlls with the regsrv32 in the syswow64 dir it also did not work. I really do not understand why there isn't just a no-hassle standard install available that just installs all available client protocols (ODBC, OLEDB, ADO.NET, JAVA, etc) for x64. @Robert: I have just taken a 32-bit 11.0.1.2376 install with just the ODBC/OLEDB client APIs (created on a 32-bit system with the Deployment Wizard), and installed it successfully on a 64-bit Windows 7 system. All ran fine, all is installed/registered correctly in the 32-bit subsystem, the ODBC entries only show up in the Wow6432Node of the registry as expected. So it generally should work without hassle (and doesn't need any manual intervention or registration). - You might ask technical support for more information/help... More comments hidden
|
Just in case you already have licenced SA12 - of course then you could use a SA12 client to connect to a SA11 server, and could really use the SA12 64 bit Deployment Wizard. Just in case...
@Volker: What would the minimum license ($-wise) be that I need to pull that off? Is a developer's licence enough?
@Robert: I'm whether part of the iAnywhere staff nor in sales, so I can't tell. But see my comment on my answer: I guess a 32 bit install should be sufficient.