I need huge help in this one:
I am trying to connect ot MS SQL database through DBD-ODBC. The following
is my code:
my $dbh = DBI->connect('dbi:ODBC:Test','','');
# Prepare a SQL command to select all fields and records from table
# 'members'
$sth = $dbh->prepare ("select mhmdtytn from testdta.f59mdlhd where mhupmj
>100140");
# Execute the command and buffer the results
$sth->execute ||
die "Could not execute SQL statement, maybe invalid?";
I am entering nothing for username and password since I am using my machine
an I have trusted connection to the database. Well, this script doesnt
execute and I believe its because its going in without any username and
password. So I hard coded sa's login and password to connect to the db.
Still I have been unsuccessful. I am running all this on an NT box.
I would appreciate any suggestions.
Perry Chaturvedi
Sirius Computer Solutions
"Excellence is not a single act, its a daily habit." -Aristotle
---
You are currently subscribed to perl-xml as: [[email protected]]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
