Unanswered question

Is it possible to connect to sybase database from Neoload?

I am trying to connect to a sybase database and fetch some records using database functions in Neoload. However I keep getting login error though I have provided the correct connection string and connection parameters.

Kanmani B.
Kanmani B.

Kanmani B.

Level
0
33 / 100
points

Answers

Keith L.
Keith L.

Keith L.

Level
2
1256 / 2000
points
Team

I have not heard of any customers connecting with Sybase, but I will ask Dev if there are any issues, as it is not one of the ones we specifically list or have tested with.

What is the error you are getting, or is there anything in the logs?

Sulav B.
Sulav B.

Sulav B.

Level
1
156 / 750
points

This most likely is be due to firewall in the Sybase Database Server denying connection from Neoload or might as well be permission issue. Please make sure your credentials are granted access to the server.

Kanmani B.
Kanmani B.

Kanmani B.

Level
0
33 / 100
points

I get the below error when I try to connect to Sybase from Neoload.
"An error occurred while creating the connection: java.sql.SQLException: Login failed"

Driver class name - net.sourceforge.jtds.jdbc.Driver
Connection URL - jdbc:jtds:sybase://XXXX:5000/XXXX/username=XXXX;password=XXXX
But the same credentials works fine when I connect using those credentials via toad.

Neil W.
Neil W.

Neil W.

Level
0
77 / 100
points
Team

Hi Kanmani - have you placed the Sybase JDBC driver in the correct location for Neoload to detect and use it? <NeoLoad>/lib/jdbcDrivers

Kanmani B.
Kanmani B.

Kanmani B.

Level
0
33 / 100
points

Hi Neil,

This worked as a database connection request after I changed the connection URL to
jdbc:jtds:sybase://XXXX:5000/XXXX/ and provided the user name separately as connection.user and connection.password.

When I try to create a sql variable, I set the database configuration as custom and provided the Sybase driver details and connection URL details. This method doesn't seem to work. Is the sql creation limited to only certain Database types? Is there any method to create a variable for Sybase through Custom Database configuration?