Untitled Document
Results 1 to 6 of 6

Thread: Query issue to Oracle database

  1. #1
    Hello,

    We are a longtime RMS/Shiprush user, but recently moved to Retail Pro. I would like to continue to use Shiprush as we love the interface. It looks like there's no direct integration, but we are trying the desktop version and connecting to the Oracle database via ODBC. Inside the connection manager I can get a connection to the Oracle db just fine. I have a basic query just to test the connection select CUST_ID from CUSTOMER. This always returns ORA-00942: table or view does not exist. I thought it might be an issue with the query, so I opened Excel on the same computer, used the same DS_REPORTS ODBC connection and looked at the sql statement in there
    SELECT CUSTOMER.CUST_ID
    FROM CMS.CUSTOMER CUSTOMER

    I then pasted this into the query window in Shiprush and I got the same error. I'm not exactly sure where to go from here as it seems isolated to just Shiprush being able to retrieve the data.

    Thanks,
    David

  2. #2

    Join Date
    Apr 2004
    Posts
    16,851
    SYSOPS is offline
    It could be related to the user login information you're providing to get connection as well. Or it could be rights related and the user doesn't have rights to access fully.

    What is your full connection string? Have you attempted to access using something like query analyzer (aka SQL Server Management Studio)?

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  3. #3
    Provider=MSDASQL.1;Password=hidden;Persist Security Info=True;User ID=reportuser;Data Source=DS_REPORTS;Mode=Read

    Password hidden for security reasons.

    I have tried to access it from another computer using Oracle's sqldeveloper and I can get in. I can also get in on this PC via ODBC in excel and get data out.

  4. #4

    Join Date
    Apr 2004
    Posts
    16,851
    SYSOPS is offline
    I have our QA team reviewing connecting to an Oracle database. Case 74444. We will update here with more information.

    Thank you,
    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  5. #5
    I actually got this to work. I'm not sure what exactly I changed, but the query started to return data from our Retail Pro Oracle installation. I'm not at the store anymore, but I will paste the query used here to potentially save some headaches for another user.

    Thanks for the help!

  6. #6

    Join Date
    Apr 2004
    Posts
    16,851
    SYSOPS is offline
    Thank you for the update and please do let us know what may have changed in your query.

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

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
  •