node-sybase icon indicating copy to clipboard operation
node-sybase copied to clipboard

dbname doesn't work

Open BartVanBeurden opened this issue 7 years ago • 1 comments

The dbname parameter doesn't appear to be working on my SQL Anywhere 16 server.

I've never worked with jConnect before (or java for that matter), but according to the Sybase Reference the database name is supposed to be passed using the ServiceName parameter (see section "How to Specify a Database with a jConnect Connection String"). However, a quick look at the Source Code appears to indicate that you're building the connection string like this: host:port/dbname when it should be host: port?ServiceName=dbname

On a related note, I cannot find any documentation on how to switch to a different database (without creating a new connection, that is).

BartVanBeurden avatar Jan 14 '18 06:01 BartVanBeurden

https://github.com/rodhoward/node-sybase/blob/master/JavaSybaseLink/src/SybaseDB.java

in line 58 change the url and compile again in .jar and manage to connect correctly to the database

conn = DriverManager.getConnection("jdbc:sybase:Tds:" + host + ":" + port + "?ServiceName=" + dbname, props); //jdbc:sybase:Tds:{host}:{port}?ServiceName={dbname}

OscVicMedi avatar Apr 16 '18 21:04 OscVicMedi