I copied these 2 dlls to the win32 subfolder of my 64-bit SQL Anywhere installation, then ran the regsvr32 from C: Windows SysWOW64 to register them. I found I had a copy of the 2 OLE dlls (dboledb9.dll and dboledba9.dll) in a folder where I'd saved my original 32-bit installation file, SA902_Win32_Developer.exe.
Those are the files that I used to load Sybase on my Windows 2008 R2 server, and, as noted above, I ended up with a driver file in both my win32 and 圆4 directories however, when I used the same 2 executables to load Sybase on my Windows 7 desktop, I only ended up with one driver file in the 圆4 folder.īy the way, I tried uninstalling and reinstalling Sybase on my desktop but, that did not resolve the problem.
How do I get the 32 bit version of the driver? The only installation files I have for Sybase Developer's edition are 'SA_902_X64_developer.exe', plus the Emergency Bug Fix 'SA9_Full_WIN_X64.902_EBF_3951.exe' (i.e. However, on my Windows 7 desktop, I only have the file in folder C: Program Files Sybase SQL Anywhere 9 圆4. On my Windows 2008 R2 Server, where the driver shows up in the Connection Manager dialogue, I have 2 dboledb9.dll files: one is in folder C: Program Files Sybase SQL Anywhere 9 win32 the other is in folder C: Program Files Sybase SQL Anywhere 9 圆4. Arthur, You may be right about my needing a 32 bit version of the driver. We have production packages pulling data out of Sybase into MS SQL, and I'd prefer not having to log on to the server in order to maintain these or to create new Sybase to SQL packages. Is anyone aware of any additional steps I need to take in order to make this work.
Sql anywhere 9 64 bit download - X 64-bit Download - 圆4-bit download - freeware, shareware and software downloads.
FireDAC requires one of the Sybase SQL Anywhere x86 or 圆4 ODBC drivers to be. Databases: DB2, MySQL, Oracle, PostgresSQL, SQLite, SQL Server, Sybase. SAP Sybase Adaptive Server Enterprise ODBC driver. In both cases (on my desktop, where it doesn't work, and on the server, where it does) I am right-clicking in the Connection Managers pane and selecting 'New ADO.NET Connection'.
After having had my PC updated from Windows XP to Windows 7, the problem I am having is that when I try to create a Connection Manager to access the Sybase database, using BIDS/Visual Studio on my desktop, the OLE DB driver is not listed under 'Provider:' on the Windows 2008 R2 server where I also installed SQL Anywhere 9, and which also has BIDS/Visual Studio, the 'Provider:' dropdown in the Connection Manager dialogue lists 'Sybase Adaptive Server Anywhere OLE DB Provider 9.0'. I downloaded the SQL Anywhere 9 for Windows 圆4 (Developer Edition) back when it was available on the Sybase website as an unlimited trial version, in order to get two components: Sybase Central for querying the database, and the OLE DB provider for developing MS SQL Server Integration Services packages to extract data from the Sybase database and load it into MS SQL databases for reporting and analysis. The reason for the out-of-date SQL Anywhere is that this is the level of the embedded database used by our POS application, Micros. I have SQL Anywhere 9 for Windows 圆4 (Developer Edition) installed on a Windows 2008 R2 server and on my Windows 7 desktop.