dbTalk Databases Forums  

SQL Anywhere 10.x ODBC on Windows 2008

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


Discuss SQL Anywhere 10.x ODBC on Windows 2008 in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jorge Quintana
 
Posts: n/a

Default SQL Anywhere 10.x ODBC on Windows 2008 - 12-03-2009 , 12:42 PM






Has anybody configured ASA 10 ODBC on a Windows server 2008? we have an
application that we use ASA 10 our installation program creates the registry
entries in for registering the ODBC drivers but it did not work in Windows
2008, I guess registriy settings are different.

Any help will be greatly appreciated

Jorge

Reply With Quote
  #2  
Old   
Kory Hodgson (Sybase iAnywhere)
 
Posts: n/a

Default Re: SQL Anywhere 10.x ODBC on Windows 2008 - 12-03-2009 , 12:56 PM






Is it an x64 OS? If it is there is a 32 bit ODBC manager and a 64 bit
ODBC manager. Be sure you use the version for what bitness the client
application is using. So if it is a 32 bit client application it must be
in the 32 bit ODBC manager or corresponding registry entries.

Jorge Quintana wrote:
Quote:
Has anybody configured ASA 10 ODBC on a Windows server 2008? we have an
application that we use ASA 10 our installation program creates the registry
entries in for registering the ODBC drivers but it did not work in Windows
2008, I guess registriy settings are different.

Any help will be greatly appreciated

Jorge


Reply With Quote
  #3  
Old   
Jorge Quintana
 
Posts: n/a

Default Re: SQL Anywhere 10.x ODBC on Windows 2008 - 12-03-2009 , 02:36 PM



Windows 2008 is 64 bit, i was able to manually register odbc drivers to make
it appear in the ODBC manager but when i tried to set up and odbc data
source i got an error that it says something along the lines of "error
uploading translation library"



"Kory Hodgson (Sybase iAnywhere)" <khodgson (AT) A_SPAM_FREE_sybase (DOT) com> wrote in
message news:4b1809ef$1 (AT) forums-1-dub (DOT) ..
Quote:
Is it an x64 OS? If it is there is a 32 bit ODBC manager and a 64 bit ODBC
manager. Be sure you use the version for what bitness the client
application is using. So if it is a 32 bit client application it must be
in the 32 bit ODBC manager or corresponding registry entries.

Jorge Quintana wrote:
Has anybody configured ASA 10 ODBC on a Windows server 2008? we have an
application that we use ASA 10 our installation program creates the
registry entries in for registering the ODBC drivers but it did not work
in Windows 2008, I guess registriy settings are different.

Any help will be greatly appreciated

Jorge

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

Default Re: SQL Anywhere 10.x ODBC on Windows 2008 - 12-03-2009 , 03:20 PM



Hi Jorge,

I'm going to assume that you're using and deploying the 32-bit ODBC
drivers...? These will not be able to be run from a 64-bit application
or the 64-bit ODBC administrator.

---

With 64-bit Windows Systems, there are "two" ODBC Registry locations to
be concerned about:

The 64-Bit ODBC Driver Registry:
\\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI

The 32-Bit ODBC Driver Registry:
\\HKEY_LOCAL_MACHINE\SOFTWARE\Wow64Node\ODBC\ODBCI NST.INI

There are also two ODBC Administrators that access the 32-bit/64-bit
drivers:

64-Bit ODBC: C:\Windows\system32\odbcad32.exe
32-Bit ODBC: C:\Windows\SysWow64\odbcad32.exe

You should ensure that you are "manually" registering the 32-bit drivers
underneath the 32-bit registry and managed with the 32-bit ODBC
administrator.

Regards,

Jorge Quintana wrote:
Quote:
Windows 2008 is 64 bit, i was able to manually register odbc drivers to make
it appear in the ODBC manager but when i tried to set up and odbc data
source i got an error that it says something along the lines of "error
uploading translation library"
--
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
  #5  
Old   
Jorge Quintana
 
Posts: n/a

Default Re: SQL Anywhere 10.x ODBC on Windows 2008 - 12-04-2009 , 02:11 PM



Thanks Jeff, I got it to work, I was running the 64 bit ODBC Manager and was
not able to see the ODBC datasource our installation program configures.



I know have better understanding on how the 32 bit applications install on
Windows 64 bit



Jorge



"Jeff Albion [Sybase iAnywhere]" <firstname.lastname (AT) ianywhere (DOT) com> wrote in
message news:4b182bb5$1 (AT) forums-1-dub (DOT) ..
Quote:
Hi Jorge,

I'm going to assume that you're using and deploying the 32-bit ODBC
drivers...? These will not be able to be run from a 64-bit application or
the 64-bit ODBC administrator.

---

With 64-bit Windows Systems, there are "two" ODBC Registry locations to be
concerned about:

The 64-Bit ODBC Driver Registry:
\\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI

The 32-Bit ODBC Driver Registry:
\\HKEY_LOCAL_MACHINE\SOFTWARE\Wow64Node\ODBC\ODBCI NST.INI

There are also two ODBC Administrators that access the 32-bit/64-bit
drivers:

64-Bit ODBC: C:\Windows\system32\odbcad32.exe
32-Bit ODBC: C:\Windows\SysWow64\odbcad32.exe

You should ensure that you are "manually" registering the 32-bit drivers
underneath the 32-bit registry and managed with the 32-bit ODBC
administrator.

Regards,

Jorge Quintana wrote:
Windows 2008 is 64 bit, i was able to manually register odbc drivers to
make it appear in the ODBC manager but when i tried to set up and odbc
data source i got an error that it says something along the lines of
"error uploading translation library"

--
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
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.