search

rodhoward / node-sybase

23 stars 55 forks source link

sp_helpdb can not be found #2

Closed solarisan2 closed 8 years ago

solarisan2 commented 8 years ago

I receive below error once trying to connect to sybase IQ database:

com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -265: Procedure 'sp_helpdb' not found

bradenpowers commented 8 years ago

I see this error as well.

martvaha commented 8 years ago

I think that Sybase IQ does not have the procedure 'sp_helpdb' and this project works only with Sybase AES.

There's a line in node_modules/sybase/JavaSybaseLink/src/SybaseDB.java:51:13 that calls this procedure. I don't know why it's being called, but if you remove it and recompile the Java source, it should work with Sybase IQ.

rodhoward commented 8 years ago

Thanks for your help Mart. I'm not sure why I put an sp_help in my code but removing it sounds like the answer.

On 15 Sep. 2016 9:48 pm, "Märt" notifications@github.com wrote:

I think that Sybase IQ does not have the procedure 'sp_helpdb' and this project works only with Sybase AES.

There's a line in node_modules/sybase/JavaSybaseLink/src/SybaseDB.java:51:13 that calls this procedure. I don't know why it's being called, but if you remove it and recompile the Java source, it should work with Sybase IQ.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/rodhoward/node-sybase/issues/2#issuecomment-247306774, or mute the thread https://github.com/notifications/unsubscribe-auth/AF_kCTgK93897g_PKEbiWnMlCf2B4Vr9ks5qqTChgaJpZM4IR8eV .

rodhoward commented 8 years ago

I have finally got back into my code and fixed up a few things. The reason that I had sp_help in the connect was to test the connection was fully working. Not a great reason if its causing incompatibility with other versions of Sybase. I have taken it out so this issue should be fixed in version 1.0.9.