Connect to SQL Server in Perl and in VBScript

Say my database name is Jessica_DB, my user name is jessica, and my password jessica_pwd. Perl To connect to Microsoft SQL Server using Perl with Win32::ODBC module use Win32::ODBC; my $dsn = “DSN=Jessica_DB;UID=jessica;PWD=jessica_pwd;”; my $DB = Win32::ODBC->new($dsn); $DB->Sql(“SELECT f1, f2, f3 FROM MyTable”); $DB->FetchRow(); ($f1, $f2) = $DB->Data(“f1”, “f2”); print “f1 = “. $f1; $DB->Close(); … Read more