Re: Re: Ms SQL Server and perl.

[scain]

Unfortunately, MSSQL::Sqllib has several limitations when it comes to MSSQL Server 7.0 and greater. Be sure to check the limitations listed at the bottom of the module description.

Also, this is very odd, but the module Moonie suggests is not found in CPAN, but it is at the site he gives (a Canadian mirror.)

Scott

[Moonie]

scain is correct, there are several limitations with MSSQL 7 and beyond with the new datatypes. Be sure to read ALL the documenation before you decide to use it. It may not be the best choice for your situation.

If you do wish to download the module to just check it out, you'll find that you can download it from here on Cpan. Let me know if you have problems.

[hacker_j99]

Is this Module writen to be placed of the windows machine (which i dont have access to) or a Sun Sparc machine (the only thing I can use due to limitations set by my boss)

really I dont have a choice in the MSSQL 7 or not.. I work for "Engineering College Computing" a branch of the Engineering College located on the University of Toledo.. My task has been assigned to connect to the main college SIS (student information system) so that the college can ezily get the enrolled students and all their stats.

(kinda funny that none of the profs or "experts" know how this is done or dont want to spend time at it but they trust a high ranking student lab tech to get the job done... hum... Do you see grade changes in the future?)

[Moonie]

Unfortunately, I don't think this module is the right one for you without making changes to it. BUT there is an interesting website that may or may not help you. Check this out Unix and MSSQL. There are several alternatives out there.. but you may be interested in Sybperl. From the site: Sybperl is the collective name for three different modules: DBD::Sybase, Sybase::CTlib and Sybase::DBlib. DBD::Sybase is a DBI driver using CT-Library, while the other two offers direct interfaces to the client library. As MSSQL::DBlib evolved from Sybase::DBlib, it would not be too much of a task to retarget MSSQL::Sqllib to use this library instead. In that case, you could use MSSQL::Sqllib.. but you'd need to modifiy it to fit your needs. You may want to use DBD::ODBC instead. Anyways, I hope this helps a bit. Wouldn't it be awesome if MS could interface a bit with Unix. (I guess.. when pigs fly.. who knows..)

Update: The documentation for DBD::FreeTDS is here