407-248-1481
QuoteWerks Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Start Free Trial
Customer Area

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 24.0 Build 2
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

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)