407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6166)

Error When linking to a SalesLogix Product List

This information applies to :

Article ID
6166

Created/Updated
November 29, 2005

Category
Product Database


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:

When using the Professional/Corporate Edition of QuoteWerks 4.0 and trying to link to a SalesLogix Product List, I am receiving the following error:

Error Opening recordset in ConnOpenRecordSet():
Error (-2147217865) Invalid object name 'TableName'.
SQL=SELECT * FROM TableName

Cause:

The SalesLogix Table owner is sysdba and not DBO.

Solution:
In Enterprise Manager, you can create a View that links to the Table in SalesLogix with the Owner set to DBO or other user. By default, the Owner should be DBO.

To create a View:
- Select the Database in Enterprise Manager
- Select Views under the database
- Under Views, right-click and select New View
- The SQL String is: SELECT * FROM sysdba.TableName
- In QuoteWerks, Link to the View Name that you call the View.

The SQL String for the Products is:
SELECT * FROM sysdba.PRODUCT

New Search