Data type for parameter 13 has changed since first SQLExecute call

More
12 years 2 months ago #10313 by gkovacs
I am migrating my production VisImp Ent 7.7.8.5 fom windows server 2003 to windows server 2008 R2. In the 2008 environment I am getting Data type for parameter 13 has changed since first SQLExecute call when performing an import from text into odbc datasource for progress database using datadirect odbc driver. Everthing is the same between the machines (VisImp version, odbc driver version) except for server os change. I have attached a test logfile but this is happening across all of my text datasources which feed the same data target. I can grant you server access for troubleshooting if necessary. You will need cisco vpn unless you have a remote help portal I can connect to.

Please Log in or Create an account to join the conversation.

More
12 years 2 months ago #10314 by gkovacs
log

File Attachment:

File Name: vimplog.txt
File Size:2 KB

file upload
Attachments:

Please Log in or Create an account to join the conversation.

More
12 years 2 months ago #10315 by admin
This might help

knowledgebase.progress.com/articles/Article/5484

Is there particular reason why you are using ODBC and not direct PostresSQL connection?

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
12 years 2 months ago #10320 by gkovacs
The WorAround looks like resolved the problem. I am connecting to a progress database not postgresql.. I am doing postgresql with another company I work with. -gene

Please Log in or Create an account to join the conversation.

More
12 years 2 months ago #10321 by admin
Great

Thank you for the update

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save