Chapter 14 - Problems with ODBC/dBASE connection
THis relates to the ODBC example. I'm running 64bit version of windows 7. I'm able to create the ODBC System DSN using the 32 bit version of ODBC Admin program (%systemdrive%\Windows\SysWoW64\odbcad32.exe). I can create the connection OK and create a connection from within my package in Visual Studio. Test connection is successful but as soon as I click columns or preview I get the following error:-
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [ODBC Source [1]]: Open Database Connectivity (ODBC) error occurred. state: 'HY090'. Native Error Code: 84. [Microsoft][ODBC dBase Driver]Invalid string or buffer length
Error at Data Flow Task [ODBC Source [1]]: There was an error while trying to get schema information. state: 'HY090'. Native Error Code: 84. [Microsoft][ODBC dBase Driver]Invalid string or buffer length
------------------------------
BUTTONS:
OK
------------------------------
Can anyone give any guidance on how to fix this or what the cuase might be?
|
