Is there anybody in the NMS community who can tell me how this can be achieved?
(luaSQL does not currently support Sybase, accord to their website)
NSA (on windows) supports OLE DB/ODBC, so it should be possible to use database.open () with a valid connection string. Provided that you have the a Sybase OLE DB/ODBC provider installed. Usually comes with the installation of the client.
Check out this site http://www.connectionstrings.com/sybase-adaptive for connection-strings that could work.
E.g. using an ODBC driver for Adaptive Server Enterprise 15.0:
Thanks Carstein, it works fine from nsa. However, I started out by using the NAS Lua, which still does not work.
Anyhow, I will write a NSA probe instead, which will do the same as a Lua script.
One other thing: Is it possible to encrypt the DB password in nsa?
It could be a problem with the version of the NAS. There were some issues related to the database.open function.
Yes, you can encrypt the password in the NSA script. The requirement is that you encrypt the whole connection-string using the -p/-P option.
Can you expand on the issues with the NAS?
It was actually a problem with the underlying database library we use that was built into NAS 3.44. The problem was that the if you used a valid connection-string in database.open() that targeted a provider that was unknown to the library, then it failed to initialize itself towards ADO. So, even if you inserted a valid connection string it could fail since it did not default to ADO.
This is fixed in the 3.50 currently out in beta.
Retrieving data ...