insert into microsoft sql database
Posted on 2005-04-04
I'm having problems inserting into a remote database.
my $DSN = "DSN=mydsn;UID=myid;PWD=password;";
my $connection = new Win32::ODBC($DSN);
$SQL = "INSERT INTO tblUploadLog \(ID\, CreateDateTime\, Status\) VALUES \(\'101\', \'1\/1\/2005\', \'Problem\')";
Not sure what's wrong.
I ran this from a command prompt and there aren't any error messages.
I ran the same sql statement on the remote database manually with enterprise manager and it works.