Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Confused by DBI:ODBC Driver name

by karlk123 (Novice)
on Dec 23, 2011 at 20:10 UTC ( [id://944974]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    #!c:/perl/bin/perl
    
    ...
    {
      print "Handle = $dbh\n";
    }
    
  2. or download this
    DBI Connect:  DBI:ODBC:DRIVER={MS SQL 2005};server=localhost;database=
    +online_labs_qa;UID=xxx;PWD=yyy
    Driver = DBI:ODBC:MySQL
    ...
    Get DBI handle
    DBI connect('DRIVER={MS SQL 2005};server=localhost;database=online_lab
    +s_qa;UID=xxx;PWD=yyy','',...) failed: [Microsoft][ODBC Driver Manager
    +] Data source name not found and no default driver specified (SQL-IM0
    +02)(DBD: db_login/SQLConnect err=-1) at odbc_test.pl line 49
    Could not connect to database: [Microsoft][ODBC Driver Manager] Data s
    +ource name not found and no default driver specified (SQL-IM002)(DBD:
    + db_login/SQLConnecterr=-1) at odbc_test.pl line 49.
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://944974]
Approved by Marshall
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2024-04-23 15:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found