Creating a Data Source Name (DSN) : ODBC « Win32 « Perl

1. Perl
2. Win32
3. ODBC

Creating a Data Source Name (DSN)

   


 use Cwd;
 use Win32::ODBC;

 $DriverType = "Microsoft Access Driver (*.mdb)";
 $DSN = "Email Contacts";
 $Description = "Description=Email List and Contact Information";
 $DataBase = "EmailContacts.mdb";
 $dir = cwd();
 if (Win32::ODBC::ConfigDSN(ODBC_ADD_DSN,
                            $DriverType,
                            ("DSN=$DSN",
                            $Description,
                            "DBQ=$dir\\$DataBase",
                            "DEFAULTDIR=$dir",
                            "UID=", "PWD="))){
    print "Successful configuration of $DSN!\n";
 }
 else{
    print "Error Creating $DSN\n";
    Win32::ODBC::DumpError();
    die;
 }
 my $myDb = Win32::ODBC->new($DSN);
 my $connection;
 if (! $myDb){
    print "Failed to Connect $DSN\n";
    Win32::ODBC::DumpError();
    die;
 }else {
    $connection = $myDb->Connection();
    print "Successful Connection $connection, $DSN\n";
 }
 $myDb->Close();

   
    
    
  

Related examples in the same category