from readme:
WorkArounds2=8192. Workaround for Microsoft Access 2000 when it calls
SQLStatisticsW and SQLGetData for column number 10. Microsoft Access
only asks for the data as a two-byte SQL_C_WCHAR, which is insufficient
buffer to store the UCS2 character and the null terminator. Thus,
the driver returns a warning, "01004 Data truncated", and returns a
null character to Microsoft Access. Microsoft Access then passes
error -7748. Setting this workaround causes Microsoft Access to not
pass the error -7748.
from another email - from a sysbase group
Step by step solution:
get a connection to the database but if I choose a table
I get the error:
"Reserved Error (-7748); there is no Message on this error".
I fixed the error by following solution.
1. Bring up regedit
2. Go to the following directory:
HKEY_LOCAL_MACHINE -> Software -> ODBC -> ODBC.INI -> your_DSN_name
3. Select your data source and chose "edit" -> "New" -> "string value"
from the menu (for more information, see "More Details", below)
4. Change the name of the new string value to read "WorkArounds2"
5. Double click on "WorkArounds2" in the right hand panel and bring up a box with data value
6. Change data value to 8192
I found the fix is working without modifying the DSN
definition on user machines.
Partager