ODBC Driver 11 error when connecting SQL Server

[landaware]

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]

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]

Yes correct I got same error message.

[FRBhote]

Try this?