How do you code a successful SalesLogix database connection using perl and teh slxoledv.1 provider?

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 );