Since we use connection strings instead of DSN"s (as does just about anyone who wants to retain the sanity of their Support staff), it would be helpful to have documentation of the Lianja SQL Server ODBC driver.
thanks,
Hank
Since we use connection strings instead of DSN"s (as does just about anyone who wants to retain the sanity of their Support staff), it would be helpful to have documentation of the Lianja SQL Server ODBC driver.
thanks,
Hank
Hi Hank,
I'll add it in. The basic string is as follows:
For the local machine you can also use:Code:lcDSNLess="DRIVER=Lianja ODBC Driver;" ; + "SERVERNAME=192.168.123.123;USERNAME=server-user;PASSWORD=user-password;DATABASE=southwind" lnConnHandle=SQLSTRINGCONNECT(lcDSNLess) if lnConnHandle > 0 sqlexec(lnConnHandle,"select * from shippers") list sqldisconnect(lnConnHandle) endif
orCode:SERVERNAME=?;USERNAME=?;PASSWORD=?
Code:SERVERNAME=localhost;USERNAME=?;PASSWORD=?
Thanks!
BTW: the Wiki is looking very good. Should I find missing commands/functions, would the best course of action be to ticket them, or report them here?
Hank
Thanks.
Tickets are best: they can be easily tracked and dealt with and there's usually not much to discuss.
This information can now also be found in the Documentation Wiki.
Bookmarks