Untitled Document
Results 1 to 2 of 2

Thread: sql search fails

  1. #1
    Greetings,

    I have added a mssql query to the 'cm' screen that should read from my default shipping table.
    when i was creating the odbc data, i asked for the software to test the connection to the server.
    The connection was fine.

    However, when i execute the sql query in the search screen, it reports a connection failure.

    I'm hoping that someone has some advice or insite on this issue.

  2. #2

    Join Date
    Apr 2004
    Posts
    16,462
    SYSOPS is offline
    Basic questions as we don't have many details:

    Have you installed any SQL tools on the machine itself and test that you can
    - Connect to the database
    - Run a SQL query against it

    Is the database location to the machine, on the same network, or out in a cloud?

    Is this a MSSQL database?

    Thank you,
    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
  •