From: "Vitaliy Babiy" <[EMAIL PROTECTED]>
> "Learn Perl" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi guys, > > just wondering how to establish a DBI connection from a
> unix machine to a > WINNT machine running MS SQL server? do I have to
> specify an OBDC?
>
> I think you can do it as usually.
>
> For example:
> ------------------------------
> my $dbname ="aissm";
> my $dbhost ="localhost";
> my $dbuser ="root";
> my $dbpass ="gfhjkm";
>
> my $dbh =
> DBI->connect("DBI:mysql:$dbname:$dbhost","$dbuser","$dbpass");
> ------------------------------
Eric wanted connection with MS SQL, not Mysql!
I believe there are some ODBC drivers available for unix, but I don't
know if they are free. You should be able to use DBD::Sybase though.
my $dbh
= DBI->connect("DBI:Sybase:$dbserver","$dbuser","$dbpass");
but I've never tried.
At worst you could use DBD::Proxy and run a Perl service/daemon on
the Windows computer. Again I never needed this, but DBD::Prozy
should tell you how.
Jenda
=========== [EMAIL PROTECTED] == http://Jenda.Krynicky.cz ==========
There is a reason for living. There must be. I've seen it somewhere.
It's just that in the mess on my table ... and in my brain
I can't find it.
--- me
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
