Thanks I thought it was something like that John Kennedy
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jeff Urlwin Sent: Wednesday, August 21, 2002 11:18 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: problem connecting to SQL server 2000 That's a bug in DBD::ODBC. The newer versions fix that, but -- the ActiveState repository is not updated yet. You'll have to build it yourself or create a DSN instead and use that. Regards, Jeff > 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 > > _______________________________________________ > ActivePerl mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > _______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
