Results 1 to 2 of 2

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

  1. #1
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,638

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

    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 Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk

    SugarCRM Enterprise 6.5.12

  2. #2
    dougancil Guest

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

    Quote Originally Posted by mikesolomon View Post
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. SOAP login() - Invalid Username/Password.
    By dsandor in forum Developer Help
    Replies: 13
    Last Post: 2013-05-23, 07:49 AM
  2. Installation says Invalid username/password
    By aviator in forum Installation and Upgrade Help
    Replies: 3
    Last Post: 2010-02-10, 06:22 PM
  3. database username and/or password is invalid
    By susserg in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2009-02-20, 06:43 AM
  4. database username and/or password is invalid
    By susserg in forum Installation and Upgrade Help
    Replies: 4
    Last Post: 2009-02-12, 07:04 AM
  5. Invalid Username & Password & Can't Connect To DB Please Help
    By jbridgesdesign in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2008-02-23, 11:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •