407-248-1481
QuoteWerks Turkey Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Request a Demo
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 4
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)