Alex,

We might be interested in purchasing the Links SQL but have a few questions.

Our inventory database is run on an NT server. Our Information Services guy says that in order to use Links SQL, it will have to comply with ODBC drivers in order to interface with the NT server database.

What I'm wanting to do is use Links SQL as the manager of our site and then write some perl mods to allow it to read from the NT server database and pull in inventory records.

Does this sound possible? Does Perl support ODBC - and could Links SQL work in this scenario?

Thanks for the info.

Alex will have to give the yes/no on LinkSQL if he's tested it, but in general there are ODBC drivers for the DBI/DBD module.

http://search.cpan.org/search?module=DBD::ODBC

Hi,

Are you running MS SQL Server? If so, I haven't tested it. We do use a few non standard SQL commands like AUTO_INCREMENT and LIMIT statements (I think MS SQL supports LIMIT), so I can't guarantee it will work.

If the script is going to be on a unix machine, accesssing the database through DBD::ODBC, I'd be happy to give it a try though. We'd need telnet access.

Cheers,

Alex