I’m having trouble connecting to SLX via Perl because I can’t figure out how to pass the connectionString information. Does anyone have a code example of a successful slx db connection using perl and the slxoledb.1 provider??
Your problem is likely the integrated security. Have you tried explicitly specifying a username and password in the connection string?
use Win32::OLE::Const ‘Microsoft ActiveX Data Objects’;
my $Conn = Win32::OLE->new(“ADODB.Connection”);
my $RS = Win32::OLE->new(“ADODB.Recordset”);
$DSN = “Provider=SLXOLEDB.1;Integrated Security=SSPI;Initial Catalog=SLXSUPPORT;Data Source=slx;Extended Properties=PORT=1706;LOG=ON;Location=;Mode=Read;”;
$Conn->Open( $DSN );