tags:

views:

1207

answers:

1
+1  Q: 

Are there any free Sybase ASE 12.5x ODBC Drivers available, or does anyone have any experience with any paid ones?

Are there any free Sybase ASE 12.5x ODBC Drivers available, or does anyone have any experience with any paid ones? I'm looking for a fast and simple solution, but don't necessarily want to pay big bucks.

Thanks in advance.

+3  A: 

How about FreeTDS. ASE uses the TDS wire protocol for connections. FreeTDS looks like it does TDS in C++ as an ODBC driver.

[Original answer, but useful for other people looking for a Java solution:] jConnect. I just downloaded it from Sybase directly. (here's the manual) Its a type 4 jdbc driver that uses the TDS protocol. The jdbc url for connections is a little funky.

Here's an article comparing the 2 official Sybase drivers, jConnect and iAnywhere.

Hm, I see you specified ODBC, now that I've posted this. Heres an ODBC-JDBC bridge that you could use. I see what you mean, there are a lot of pay ODBC drivers out there, but some have free trials... your best bet might just be to use the free jdbc driver and a free odbc-jdbc bridge.

Wait, you must have an installation of ASE somewhere already if you are trying to connect to it. There would have been one that came with that. Also, some of the developers editions you can download from Sybase are free.

John Ellinwood  2009-04-02 20:15:29
Thanks for the information, John. We'd prefer not to use JDBC, as we're interfacing via .NET only. Sorry, I should have clarified this in the question.
gibbo  2009-04-02 20:24:35
Sure, looks like FreeTDS might work.
John Ellinwood  2009-04-02 20:29:28
Thanks again, John. It looks like FreeTDS is a Unix/Linux only environment, though.
gibbo  2009-04-02 20:42:07
I was just looking through the source code for it, and theres a win32 section. I'm not sure what all is in there though.
John Ellinwood  2009-04-02 20:44:28
I don't have visual studio, but theres a MSVC6 folder that contains FreeTDS.dsp and FreeTDS.dsw. Check that out.
John Ellinwood  2009-04-02 20:45:41
Heres a windows installer for the FreeTDS dll. http://freetds.sourceforge.net/FreeTDS%20Setup%200.64.1.exe
John Ellinwood  2009-04-02 20:51:08
That did it! Thanks very much.
gibbo  2009-04-02 21:09:01

related questions

C++ SQLBindParameter
What Oracle driver should I install in my MS SQL server to be able to use DTS to copy data from the Oracle server to the MS SQL server?
Tool: ETL from an ODBC to SQL 05?
What is the simplest, most maintainable way to create a SQL Server ODBC Data Source?
How do I create a Jet ODBC link to a SQL Server view with periods in the field names?
Microsoft.ApplicationBlocks.Data.ODBCHelper ?
What are the access restrictions on accessing a DSN
.NET ODBC Connection Pooling
ODBC Connection Pool
what is the difference between OLE DB and ODBC data sources?
Reading a COBOL DAT file
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
How to programmatically configure an ODBC Datasource using C#
Best way to debug an ODBC driver on Windows
What is a Privileged instruction?
Control which columns become primary keys with Microsoft Access ODBC link to Oracle
How do you deal with NULL values in columns of type boolean in MS Access?
Using Rails 2.x with MS SQL Server 2005
C# ODBC Dialog
How do I get ms-access to connect to ms-sql as a different user?
How can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
Using MySQL on Visual Studio 2008
Using MS Access & ODBC to connect to a remote PostgreSQL
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Connect PHP to an AS/400