dbTalk Databases Forums  

32-bit and 64-bit workstations

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss 32-bit and 64-bit workstations in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert Paresi
 
Posts: n/a

Default 32-bit and 64-bit workstations - 08-19-2009 , 08:29 AM






Hello,

If the server is 32-bit, and have the ODBC running on it. No issue.

Client then gets a 64-bit workstation.

Where is the exact information for me to create my own 64-bit ODBC driver
installation, and what files do I use?

I am currently using dbcon9.dll, dblgen9.dll and dbodbc9.dl -- only those
three and works great for 32-bit.

Are there different files I need to get?

-Robert

Reply With Quote
  #2  
Old   
Arthur Hefti
 
Posts: n/a

Default Re: 32-bit and 64-bit workstations - 08-19-2009 , 09:02 AM






SQL Anywhere comes with Setup for 32/64 Bit (at least in Version 10).
The registry entries in 64 bit for 64 bit applications are located as
you're used from 32 bit. When installing 32 Bit ODBC on a 64 bit
windows they're located at HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC.
You will need 64 bit ODBC only when you run 64 bit applications. 32 bit
applications use 32 bit ODBC on 64 bit windows.

Arthur

Robert Paresi wrote:

Quote:
Hello,

If the server is 32-bit, and have the ODBC running on it. No issue.

Client then gets a 64-bit workstation.

Where is the exact information for me to create my own 64-bit ODBC
driver installation, and what files do I use?

I am currently using dbcon9.dll, dblgen9.dll and dbodbc9.dl -- only
those three and works great for 32-bit.

Are there different files I need to get?

-Robert

Reply With Quote
  #3  
Old   
Jeff Albion [Sybase iAnywhere]
 
Posts: n/a

Default Re: 32-bit and 64-bit workstations - 08-19-2009 , 09:04 AM



Robert,

Robert Paresi wrote:
Quote:
Where is the exact information for me to create my own 64-bit ODBC
driver installation, and what files do I use?
You will have to use a manual deployment mechanism on x64 - our
Deployment Wizard cannot build x64 installs at this time.

The manual install instructions for the driver are in the docs:
http://www.ianywhere.com/developer/p...9/00000658.htm

Quote:
I am currently using dbcon9.dll, dblgen9.dll and dbodbc9.dl -- only
those three and works great for 32-bit.

Are there different files I need to get?
It depends - do you have a 64-bit application that would make use of the
64-bit drivers? If not, just install the 32-bit drivers as always.

(Remember that the 32-bit ODBC administrator is under
C:\windows\syswow64\odbcad32.exe and the 32-bit regedit is under
C:\windows\syswow64\regedit.exe).

If you want to install the 64-bit driver, the 64-bit driver ODBC .dlls
are under %ASANY9%\x64. They can then be installed with the 64-bit
registry editor (C:\windows\system32\regedit.exe) and manipulated with
the 64-bit ODBC Administrator (C:\windows\system32\odbcad32.exe).

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Reply With Quote
  #4  
Old   
Robert Paresi
 
Posts: n/a

Default Re: 32-bit and 64-bit workstations - 08-19-2009 , 09:44 AM



Hello,

Quote:
SQL Anywhere comes with Setup for 32/64 Bit (at least in Version 10).
We don't give the user/workstation a 100meg installation program. We
simply install the three files ourselves and update the registry ourselves
with our own installation program. We wouldn't use the SQL Anywhere Setup
program for this.

Are you saying just change the ROOT to "Wow6432Node" and it will work?
But, what are the three files I will use instead?

-Robert

"Arthur Hefti" <arthur (AT) catsoft (DOT) ch> wrote

Quote:
SQL Anywhere comes with Setup for 32/64 Bit (at least in Version 10).
The registry entries in 64 bit for 64 bit applications are located as
you're used from 32 bit. When installing 32 Bit ODBC on a 64 bit
windows they're located at HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC.
You will need 64 bit ODBC only when you run 64 bit applications. 32 bit
applications use 32 bit ODBC on 64 bit windows.

Arthur

Robert Paresi wrote:

Hello,

If the server is 32-bit, and have the ODBC running on it. No issue.

Client then gets a 64-bit workstation.

Where is the exact information for me to create my own 64-bit ODBC
driver installation, and what files do I use?

I am currently using dbcon9.dll, dblgen9.dll and dbodbc9.dl -- only
those three and works great for 32-bit.

Are there different files I need to get?

-Robert

Reply With Quote
  #5  
Old   
Jeff Albion [Sybase iAnywhere]
 
Posts: n/a

Default Re: 32-bit and 64-bit workstations - 08-19-2009 , 10:02 AM



Robert,

Robert Paresi wrote:
Quote:
Are you saying just change the ROOT to "Wow6432Node" and it will work?
But, what are the three files I will use instead?
If you're installing the 32-bit DLLs, yes, installing the registry
entries underneath the \ODBCINST.INI key (Underneath "\Wow6432Node")
will install the 32-bit drivers, with the files you already have.

Cheers,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Reply With Quote
  #6  
Old   
John Smirnios [Sybase]
 
Posts: n/a

Default Re: 32-bit and 64-bit workstations - 08-19-2009 , 10:22 PM



Hmmm. I think it's more complex than that. 32-bit processes cannot, by
default, see the 64-bit parts of the registry which makes it difficult
for a 32-bit installer to install 64-bit. If you are a 32-bit app,
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC is actually mapped to
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC. There's a Win32 API call
to disable that though I don't recall the name off-hand. I would
recommend running
regsvr32 full_path_to_dll
for the 32 and 64 bit versions of each DLL that must be registered.
Regsvr32 does all the jiggery pokery to handle launching another version
of itself to match the bitness of the DLL if necessary.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Jeff Albion [Sybase iAnywhere] wrote:
Quote:
Robert,

Robert Paresi wrote:
Are you saying just change the ROOT to "Wow6432Node" and it will work?
But, what are the three files I will use instead?

If you're installing the 32-bit DLLs, yes, installing the registry
entries underneath the \ODBCINST.INI key (Underneath "\Wow6432Node")
will install the 32-bit drivers, with the files you already have.

Cheers,

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.