I'm try to connect to MS SQL Serwer with code :
*------------
Local rdd
Cls
rdd := RDDSETDEFAULT( "SQLMIX" )
RDDINFO( 1001, { "ODBC", "Driver={SQL
Server};Server=MSSQL.alias.firma;Database=FIRMY;Trusted_Connection=yes;"
} )
DBUSEAREA( .T., "SQLMIX", "select ID_KLIENT, NAZWA from KLIENT where
nazwa like '%ZAKLAD%'", "CBKI")
RDDSETDEFAULT( rdd)
? Alias()
? "DB struct:", HB_VALTOEXP( DBSTRUCT() )
*------------
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 ?
And another question : why I must change default rdd before :
RDDINFO( 1001, { "ODBC", "Driv ...
When I don't make this, app is crashed.
Regards,
Marek Horodyski
_______________________________________________
Harbour mailing list
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour
