problem connecting to SQL server 2000

[John.F.Kennedy]

I am having a problem connecting to SQL server 2000 using DBI. Below are my
code and the error message I get could some point me in the right direction.

sub Connect_To_DataBase
    {
   my ($continue,$dsn);
        $continue = $TRUE;
    Create_Log("null","Attempting to connect to My Database");

    $dsn = "Driver={SQL Server};Server =MyServerName;Database=
MyDatabaseName ";

     $DBH = DBI->connect("dbi:ODBC:$dsn","username", "password",
          {
           RaiseError => 0,
           PrintError => 0,
           AutoCommit => 0
          } ) or
Create_Error_Log($DBH::errstr,1,"DFD1_A",1033,"DFD1"),$continue = $FALSE;

     return $continue;
    }

Error :  [Microsoft][ODBC Driver Manager] Invalid string or buf

Thanks
John Kennedy

_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs