I'm looking for an ODBC driver to connect to a Sybase Adaptive Server Anywhere 9.0 database from an XP based system. Anyone out there have any recommendations on a solution that is preferably free, or otherwise, not too expensive?
Thanks in advance.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I have the distribution disks and have installed the ODBC drivers, but they don't appear to work as I expect. They want to start the database and seem to operate in somewhat of an exclusive mode. In my case, the database is already open by another application, I just want to query some data from it. Do you have any suggestions on what I might change with the Sybase drivers or other drivers that would work better?
It is not a driver problem, it is either the version of ASA and/or the mechanism by which it is being started. There is a remote possibility that you have a network configuration issue as well.
There is a "personal" version of ASA which is designed to support a single user collocated on a desktop machine. If that is what you are using, you won't have much success trying to attach a second user on a different machine to it. Are the multiple users hitting this database now?
Next, even if you have the full "server" version of ASA, you want to start it up as a service (assuming Windows) rather than rely on the ODBC driver to start it. The option to have the ODBC driver start the database server on demand only works when the client and server are on the same platform.
Next, you need to look at the network parameters you are starting the database server with. As an aside, ASA is a real live database, not a shared file system. The only way to access the database is by running the engine and connecting to that engine. The engine starts up and listens on an IP address and port. A common mistake is having the "server" machine have a dynamically assigned address. This makes it pretty difficult to find the server from client machines. Next, I have seen situations where somebody use only the Windows machine name in the configuration instead of an IP address. Windows name resolution is flakey on a good day and is not a reliable way to address a database server. If you have a DNS server, you can use that name but don't rely on Windows Naming to do it for you. Finally, I have seen a few cases where the database server was setup to listen on IP addr 127.0.0.1; the loopback address. The problem is that the loopback address is only available on the local machine so you are forever prevent from seeing it on the network.
Assuming you don't have network configuration problems, once you get the database engine started as a service, there is a mechanism in ASA that allows the client drivers to find the database engine on the network by dbsrvr (not machine) name.
Best of luck,
Bill
Business Accounts
Answer for Membership
by: grant300Posted on 2009-06-03 at 09:34:44ID: 24538354
If you are licensed for ASA 9, you will find the ODBC drivers on the distribution. Not muss, no fuss, no extra $.
Regards,
Bill