* Chandrakant Reddy <[EMAIL PROTECTED]> [2004-11-18T03:20:49] > Any one tried to connect Mssql server from perl which is on Solaris Machine. > I installed Class::DBI::MSSQL using CPAN and also go through the > perldoc Class::DBI::MSSQL but didn't get much.
Are you actually using Class::DBI? Do you know what Class::DBI? I
don't suggest using Class::DBI(::MSSQL) until you know you can connect
normally.
By "normally," I mean with the standard Perl database interface, DBI.
To connect to MSSQL with DBI, you'll want to use the DBD::ODBC or
DBD::ADO drivers, both on the CPAN. ADO requires Win32. ODBC requires an ODBC
system. On Win32, a connection to MSSQL via ODBC might look like this:
my $dbh = DBI->connect(
'dbi:ODBC:driver={SQL
Server};server=mydbserver;databasename=northwind;Trusted_Connection=no',
$user,
$password
)
FWIW, Class::DBI::MSSQL is meant to be used with ODBC.
I can offer no advice for using ODBC from a non-Win32 system.
> I need one sample script and also what are the api's available in
> perl to connect MSSQL server database.
Try googling for "dbi tutorial"
--
rjbs
pgpobEJNesq3S.pgp
Description: PGP signature
