I'm trying to connect to a sybase database from excel/access.
At my previous job, I was able to do this by using a simple connection string such as:
strConnString = "Provider=ASEOLEDB;Data Source=10.0.237.32:4074;Initial Catalog=asdf;User ID=asdf;Password=asdf;"
But I'm having a hard time finding the ASEOLEDB. Is this something that needs to be installed? If so, is it something I can quickly download and do? Or is this a part of the sybase enterprise sofware that needs to be installed? fortunately(?) for my previous job, the ODBC was there already when I started using my computer, but this doesn't seem to be the case right now.
Also, if this requires the full installation of the sybase enterprise sofware, is there any other way to get this working? From what is available to me from just a simple windows-excel installation?
I have a java program that seems to be able to connect to the sybase database already... I don't know if this means that I have the necessary things available on my current machine to connect through excel.
Any input will be greatly appreciated. Thank you!