Well, I've searched the interwebs like crazy and I am unable to find this driver.
Active1 year, 8 months ago
I am trying to convert data from a client's database that was built using the ASA 8.0 engine. ASA 8 has been out of support since 2008. The software company that created this no longer supports it, so can't provide me with the drivers. I've scoured the web and can't find anything.
Sql Anywhere 11 Odbc Driver
I managed to get the installation files for this old software called BailCredit built by a company called SentryLink. I found what I presume to be the ODBC driver in the installation files (dbodbc8.dll) and I've tried manually registering that (Windows Server 2008 R2) but didn't get anywhere. When I try to create a new datasource, the ODBC Data Source Administrator gives me an error.
Jul 31, 2019 Microsoft ODBC Driver 17 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, Analytics Platform System, Azure SQL Database and Azure SQL Data Warehouse. I want to transfer data from a SQL Anywhere database to a Microsoft SQL Server database on a second computer. The second computer is running Windows Server 2008R2 and the only application installed on it is Microsoft SQL Server 2008. I believe I could do this if I had on ODBC driver for SQL Anywhere installed on the second computer. Hi @all I've a Sybase SQL Anywhere 9 Server on a Windows server. I've a client with Windows 7. I want install only the ODBC driver for access to the server. But, how find I the ODBC driver? The SAP SQL Anywhere Database Client includes the following components: Full set of available client interfaces, such as ODBC, JDBC, ADO.NET and so on. Administration tools such as SQL Central and Interactive SQL. Note: During installation you will. The SQL Anywhere installer makes changes to the Windows Registry to identify and configure the ODBC driver. If you are building an installation program for your end users, you should make the same registry settings. The simplest way to do this is to use the self-registering capability of the ODBC driver.
My company has done hundreds of data migrations and this is the first time I've had to resort to this.
I'd post a link to the database file, but simply can't because of privacy.
Please help if you can! Thanks in Advance.
Matt
Michael Gardner
![Download Download](/uploads/1/2/6/2/126233057/918683832.png)
5,7205 gold badges19 silver badges30 bronze badges
QuietSeditionistQuietSeditionist
3571 gold badge4 silver badges15 bronze badges
3 Answers
For 64 Bit operating system you need to copy the dll's to %windir%syswow64 so you need to change install.cmd to the following code. The rest is the same.
It take's me a few hours to figure it out i hope it help someone else.
prabowo.priyoprabowo.priyo
This is how I finally solved it.
OPTION 1:
Get a copy of the following files from a computer with a working setup of the SQL Anywhere ODBC driver:
Create an install.cmd file with this:
Create an SAS8.REG file with this:
Run install.cmd
This will work when Windows is installed in C:WINDOWS, otherwise edit the registry entries.
OPTION 2:
If someone left a copy of the Powerbuilder CD in the client's computer, look for the folder asa801runtime and install that to get the ODBC driver working
Sql Anywhere 12 Odbc Driver Download
EDIT:
Example connection string with default username/password:
Carlos AlloattiCarlos Alloatti
Answering my own question:
I wasn't able to find this commercially available anywhere. I happened to be able to get my hands on the installation for the software package that was using SQLAnywhere 8. By installing this, it installed the necessary drivers (but only worked on 32-bit OS).
QuietSeditionist
Sql Anywhere 17 32 Bit Odbc Driver Download
QuietSeditionist
3571 gold badge4 silver badges15 bronze badges