|
|
|
>You'll also need ODBC drivers. DBI::ODBC
>connects to existing ODBC drivers much as
>DBI::mysql connects using installed mysql libraries.
Thanks for the input; however, if the ODBC applet in your NT4.0 control panel is set up to access the proper MSSQL database, you need only provide $dsn (database source name), $log (login ID), and $pwd (duh) to connect to MS-SQL. This way, you don't need to provide the driver. For more information on how to set this up, read the extremely informative "Programming with Perl Modules" (a constituent portion of the Win32 Perl Kit.) Make sure that you select the SQL ODBC driver when you set up your NT 4.0 though, or it won't work. Also, reading MS's SQL Administration handbook will give you some clues on how to set up the ODBC interface with the ODBC applet.
My question is a bit more fundemental than this and probably can only be answered by Mike Heinz. Will the current mini-vend code support ODI::ODBC to interact with MS-SQL, if not is there a version being written that will do this? Or, is it possible to interact with MS SQL Server in a different way? If not, who wants to help develop the perl to do this?
vandy