Hi,
Query 1
========
Is it possible to use Perl DBI to connect to SQL Server?
I think all DBD drivers (mysql,Oracle,etc) need different syntax for
connect.
Supposing I want to connect to database runnnig at 10.0.0.1 port 1433 and
schema name is "schema1" username and password to connect to database is
"user" and "pass".
my $dbh = DBI->connect(**what is the syntax to write the string here??**)
|| die $DBI::errstr;
Query 2
======
I wanted to connect to one Oracle database through Perl DBI.
Initially I was trying with Perl 5.10, then I installed Perl 5.6 and
installed DBI, DBD-Oracle throough ppm.
I can connect to the Oracle database through toad.
If I try ,
my $dbh =
DBI->connect("dbi:Oracle:HOST=10.10.10.1;PORT=1533;UID=userid;PWD=pswd"
)|| die $DBI::errstr;;
I get error:
DBI connect('HOST=10.10.10.1;PORT=1533;UID=userid;PWD=pswd','',...) failed:
Can't connect using this syntax without specifying a HOST and a SID at
D:\scripts\test1.pl line 4
Can someone please let me know what is the correct way to connect?
Thanks & Regards
Gautam
