DBI 1.48 connection failure to MS SQL

I have a script that connects to ms sql server with
DBI::ODBC. But this code works only for DBI 1.37
version, not for version 1.48. I get connection failed
error and looks like the driver connection was not
built. DBI was trying to login as the system user
instead of the DB user. Any one has seen this problem
before? What change from 1.37 to 1.48 could cause this
problem? Thanks a lot.

my $dbh = DBI->connect("DBI:ODBC:driver={SQL
Server};server=$dbHost;Database=$dbn;UID=$dbUsr;PWD=$dbPw")
or die "could not connect to db, ", DBI->errstr, "\n";


Claire



__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com

Re: DBI 1.48 connection failure to MS SQL

This may be a very obvious question did you recompile your DBI:ODBC at the
same time?

"Claire Lee" wrote in message
news:20060110060707.9389.qmail@web60221.mail.yahoo.com...
> I have a script that connects to ms sql server with
> DBI::ODBC. But this code works only for DBI 1.37
> version, not for version 1.48. I get connection failed
> error and looks like the driver connection was not
> built. DBI was trying to login as the system user
> instead of the DB user. Any one has seen this problem
> before? What change from 1.37 to 1.48 could cause this
> problem? Thanks a lot.
>
> my $dbh = DBI->connect("DBI:ODBC:driver={SQL
> Server};server=$dbHost;Database=$dbn;UID=$dbUsr;PWD=$dbPw")
> or die "could not connect to db, ", DBI->errstr, "\n";
>
>
> Claire
>
>
>
> __________________________________________
> Yahoo! DSL - Something to write home about.
> Just $16.99/mo. or less.
> dsl.yahoo.com
>

Re: DBI 1.48 connection failure to MS SQL

"Claire Lee" wrote

>I didn't recompile. What I did was just use the script to try to
>connect. Do I need to recompile? How do I do it? Thanks.

>Jing

There are a number of tutorials on the web for this. If you tell me what
sort of operating system you are using I might be able to point you in the
right direction?



"Claire Lee" wrote in message
news:20060110060707.9389.qmail@web60221.mail.yahoo.com...
> I have a script that connects to ms sql server with
> DBI::ODBC. But this code works only for DBI 1.37
> version, not for version 1.48. I get connection failed
> error and looks like the driver connection was not
> built. DBI was trying to login as the system user
> instead of the DB user. Any one has seen this problem
> before? What change from 1.37 to 1.48 could cause this
> problem? Thanks a lot.
>
> my $dbh = DBI->connect("DBI:ODBC:driver={SQL
> Server};server=$dbHost;Database=$dbn;UID=$dbUsr;PWD=$dbPw")
> or die "could not connect to db, ", DBI->errstr, "\n";
>
>
> Claire
>
>
>
> __________________________________________
> Yahoo! DSL - Something to write home about.
> Just $16.99/mo. or less.
> dsl.yahoo.com
>

Re: DBI 1.48 connection failure to MS SQL

> "Claire Lee" wrote
>
>I'm on Windows XP. Forgive my ignorance, can you
>explain why DBI:ODBC needs to be recompiled? Why do
>you think this may be the problem? I've always thought
>I can download a module and use it. Never thought a
>later DBI version will be incompatible with an older
>one. Thank you for help.



The Perl DBI uses a mod called DBD::ODBC. Looks like the two on you system
are out of sync.

Hopefully you are using ActivePerl so you can use PPM to serach for and then
install the latest DBD::ODBC mod.

Re: DBI 1.48 connection failure to MS SQL

> > "Claire Lee" wrote

>>Downloading the latest DBD::ODBC does solve the
>>problem. Thank you very much.

Your welcome

Cheers

""John Scoles"" wrote in message
news:20060111131154.487.qmail@lists.develooper.com...
> > "Claire Lee" wrote
> >
> >I'm on Windows XP. Forgive my ignorance, can you
> >explain why DBI:ODBC needs to be recompiled? Why do
> >you think this may be the problem? I've always thought
> >I can download a module and use it. Never thought a
> >later DBI version will be incompatible with an older
> >one. Thank you for help.
>
>
>
> The Perl DBI uses a mod called DBD::ODBC. Looks like the two on you
system
> are out of sync.
>
> Hopefully you are using ActivePerl so you can use PPM to serach for and
then
> install the latest DBD::ODBC mod.
>
>