CODEWITHSUNDEEP
connection-stringsybasesqlanywhere
Yisroel M. Olewski
Yisroel M. Olewski

Reputation: 1626

How to connect remotely with Sybase SQLAnywhere.SAConnection?

I'm trying to connect with .net to a remote sybase sql anywhere database.

I don't see much info online how to connect, mostly ODBC or DSN files.

I tried this connection string:

Data Source=myserver.com;Port=2638;Uid=myuser;Pwd=mypass

Which gives the following error

Invalid connection string. Invalid or missing keyword near 'Port' Parameter name: connectionString

So I tried to include the port with the server, like this:

Data Source=myserver.com:2638;Uid=myuser;Pwd=mypass

Which gives a new error:

DSN 'myserver:2638' does not exist

So, what is the correct connection string?

PS. Using sybase central, I was able to connect to the database, so it's not a network / firewall / port issue.

Thanks!

Upvotes: 3

Views: 2388

Answers (1)

Graeme Perrow
Graeme Perrow

Reputation: 57248

You want to use HOST=myserver.com:2638;uid=myuser;pwd=mypass. The list of valid connection parameters is documented here.

Upvotes: 2

Related Questions