Hi,
Horodyski Marek (PZUZ) wrote:
I'm try to connect to MS SQL Serwer with code :
> And app crash in dbusearea() with :
oErr:severity_____ 2
oErr:osCode_______ 65527
oErr:subsystem()__SDDODBC
oErr:subCode______ 1902
oErr:description__Invalid field type
oErr:filename_____
oErr:operation____select ID_KLIENT, NAZWA from KLIENT where nazwa like
'%ZAKLAD%'
oErr:genCode______ 32
oErr:args_________U
Invalid field type is NAZWA.
I can open this select with :
"select id_klient from klient where ...."
Id_klient is numeric, nazwa is varchar.
Can anybody check this ?
I can not check because I do not have MS SQL, but to make error more
informative, I've passed field type to :osCode. You error log shows it
is value 65527. Since it is USHORT value, it can also mean -9, if it is
signed. I can not find nor -9 neither 65527 field type sql.h. Varchar is
defined equal to 12. More tests/docs required.
And another question : why I must change default rdd before :
RDDINFO( 1001, { "ODBC", "Driv ...
When I don't make this, app is crashed.
Because RDDINFO() uses default RDD by default. You can use 3rd parameter
to specify RDD, if you do not to change default.
Regards,
Mindaugas
_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
