ODBC Driver 11 error when connecting SQL Server

General discussion forum about all databases other than SqlBase.
landaware
Argentina
Posts: 12
Joined: 30 Jul 2017, 18:27
Location: Argentina

ODBC Driver 11 error when connecting SQL Server

Post by landaware » 13 Dec 2017, 15:22

Hello,

I have experiencing some trouble with MS ODBC Driver 11 when I'm connecting to SQL Server (2k5,...2k16). The old driver which is coming with Windows is working ok (SQLSVR32.DLL version 6.01... I'm using since 10 yrs and I have no problem with that version). Just I tried to upgrade my app to this new driver but I'm only getting errors for every where.

Error: [Microsoft][ODBC Driver 11 for SQL Server]Restricted data type attribute violation

This apply for CB30 and SqlTalk.

Can I get some help from this community?

Thanks and regards,
Steven

visionpro
Mauritius
Posts: 6
Joined: 21 Jun 2017, 02:07
Location: Mauritius

Re: ODBC Driver 11 error when connecting SQL Server

Post by visionpro » 14 Dec 2017, 05:04

Hi
I can't use ODBC driver 11 for SQLServer. My main issue is error 'Invalid character value for cast specification' for field DATE & DATETIME.

I did a simple query to populate a table window.

Date Selection: [f_Date ] - [t_Date] where f_Date is 10/11/2017 and t_Date is 14/11/2017
The select Statement is as follows:
SELECT TRHVCH,TRHDAT, NADNAM FROM SA_SALHDR
INTO :tbl3000.colTrhvch,
:tbl3000.colTrhdat,
:tbl3000.colNadnam

WHERE TRHDAT >= :f_Date AND
TRHDAT <= :t_Date

I got the above error.



But, SQLSRV32.dll coming with windows works fine.

The problem is on all TD versions < 7.

Hope someone can help to find a solution.


rgds

samad

landaware
Argentina
Posts: 12
Joined: 30 Jul 2017, 18:27
Location: Argentina

Re: ODBC Driver 11 error when connecting SQL Server

Post by landaware » 26 Dec 2017, 17:47

Yes correct I got same error message.
:shock:

FRBhote
India
Posts: 100
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: ODBC Driver 11 error when connecting SQL Server

Post by FRBhote » 27 Dec 2017, 05:07

Try this?
You do not have the required permissions to view the files attached to this post.

Return to “General Discussion”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests