
Question:
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??
Answer:
Your problem is likely the integrated security. Have you tried explicitly specifying a username and password in the connection string?
Try this:
use Win32::OLE;
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 );
Subscribe To Our Newsletter
Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!
You have Successfully Subscribed!