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 6234)

Importing Products - SQL Execute Error -2147217913

This information applies to :

Article ID
6234

Created/Updated
February 9, 2006

Category
Products

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Issue:
When performing a Product import via the import wizard, you receive a SQL Execute Error (-2147217913).

In the error message, you also see the time seperator for one of the fields using a charcter other than : such as /. An example of this is: #02/09/2006 11/14/15am#

Cause:
The format function that development uses will format the date into a USA format in terms of Month, then day, then year. However, the Format function only uses the "/" symbol in the format string as a placeholder, and automatically replaces it with the date separator symbol specified in the windows control panel. Some international users have specified a "." in the windows control panel as the date separator which is not accepted by Microsoft SQL, so if the date separator is a ".", we replace it with "/"'

Solution:
Try changing your time seperator in the Windows control panel to ":"

New Search

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