I'm assuming you mean Microsoft SQL Server 7.0. . . and as for Linux, I'll make no assumptions (but it doesn't really matter).
Given that, the following should be of some use to you:
Linux, unlike Windoze, does not have a built-in ODBC manager. As such, you will need to install one of these packages to connect to SQL server. DBD::ODBC can take care of the rest (that is, unless you use DBD::Sybase. Why Sybase? Because MSSQL Server is derived from it).
For even more information, do a Perl Monks Super Search for SQL Server.
Next time, please be a little more descriptive ;)
HTH,
MrCromeDome
| [reply] |
ok ... Stick with DBD::ODBC
just for style and maintanablity of your code stick to DBD calls
rather than using ODBC or Sybase unique calls.
but you allready knew that .....
the largest problem I've had with ODBC is geting a connected to NT servers.
Once connected ODBC/MySQL/Oracal all work the same.
as for using ODBC on linux rather than any other sys.... if you use DBD::ODBC the same code should run on linux 2.2 2.4 or win2k with out changes.
Bill
| [reply] |
I have tried various driver manager: none of which install properly. I keep a tight system and am not willing to install a bunch of crap just to have a nice GUI to manage things. Is anyone aware of a simple ODBC driver which is set up in a simple manner, rpm would be best. I just need DBD::ODBC to use this in relation to perl. I just want something tight and easy to install. Any one been trhough this before? Please advise, Simon | [reply] |
