Ask a Question

Sybase connection from string

New Contributor

Sybase connection from string

Hi community, 


I am trying to create a connection with a sybase database but I can't. I need use it to execute update and insert statements.


The code I am using to test the connection is the next:


var connection = ADO.CreateConnection();
connection.ConnectionString = "Provider=Sybase.ASEOLEDBProvider;Srvr={SERVER_IP};User Id={USER_NAME};Password={PASSWORD}";


 But, when I execute the code, the next error is shown:

JavaScript runtime error.

The specified provider was not found. It may not be installed correctly.

I don't know if it is caused by the connection string or by the driver.

How can I specify the correct connection string? (some one can give me an example?)

And how can I install the driver to do the connection?

Champion Level 3

See examples of Sybase ASE OLE DB Provider connection strings. Ensure you have the correct ODBC driver installed (32-bit or 64-bit) too.

Maybe do you know where can I find those drivers?

Because I used the same examples previously to do the connection, but I have the next error: 

JavaScript runtime error.

The specified provider was not found. It may not be installed correctly.

Champion Level 3

Have you tried doing an internet search for the exact driver you require?

Yes, is the first thing that I did. First I installed CDATA JDBC to use it, but TC give me the same error, as I didn't install the driver.



TestComplete bitness must match bitness of OLE DB provider/ODBC driver (whatever you are going to use). Has this requirement been met?

If it has, use to get an idea of the required connection string.


  /Alex [Community Champion]
[Community Champions] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Champions]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Champion] signature is assigned on quarterly basis and is used with permission by SmartBear Software.
Champion Level 3

If you are using JDBC, then you need to use the correct connection string.


Is this not the driver your require, ?

Showing results for 
Search instead for 
Did you mean: