Connect to Sage Line 50 using ODBC - invalid username & password

[mikesolomon]

I'm try to create a connector from Sage Line 50 to sugar

I want to use the Sage ODBC DSN

I have tested the dsn using excel and it works but when I use it from php I get the following error

Warning: odbc_connect(): SQL error: User ID or Password invalid, SQL state 28000 in SQLConnect in C:\inetpub\wwwroot\sage_poll.php on line 19 Error connecting to the ODBC database: User ID or Password invalid

my PHP code is:

$odbc['dsn'] = "SageLine50v17";
$odbc['user'] = "manager";
$odbc['pass'] = "password";

$conn = odbc_connect($odbc['dsn'], $odbc['user'], $odbc['pass']);
if (!$conn) {
die("Error connecting to the ODBC database: " . odbc_errormsg());
}

Any help in making this work would be much appreciated

[dougancil]

I'm try to create a connector from Sage Line 50 to sugar

I want to use the Sage ODBC DSN

I have tested the dsn using excel and it works but when I use it from php I get the following error

Warning: odbc_connect(): SQL error: User ID or Password invalid, SQL state 28000 in SQLConnect in C:\inetpub\wwwroot\sage_poll.php on line 19 Error connecting to the ODBC database: User ID or Password invalid

my PHP code is:

$odbc['dsn'] = "SageLine50v17";
$odbc['user'] = "manager";
$odbc['pass'] = "password";

$conn = odbc_connect($odbc['dsn'], $odbc['user'], $odbc['pass']);
if (!$conn) {
die("Error connecting to the ODBC database: " . odbc_errormsg());
}

Any help in making this work would be much appreciated

Mike,

A case has been created about this issue which is viewable in the Support Portal. An engineer will review the case and contact you as soon as possible.

Thank you,
Doug Ancil
SugarCRM Support