407-248-1481

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 5.5 Build 1
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