ODBC importer not working with sql server 2008

[Philippe Maupoil]

Hi,
It seems that the ODBC importer utility does not work with sql server 2008. The PSD client is installed on XP sp2.
I first connected to the old sql server, clicked on the "import" button. The load started and completed successfully.
I then connected to the new sql server(2008) for the same table and data to the same target table, clicked on the "import" button and nothing happened.

I could not find any relevant topic. Is it a known issue?

Regards,
Philippe

 

[Marco Kalter]

Is your ODBC driver for SQL Server 2008 functioning correctly?

 

[Philippe Maupoil]

I have tested the ODBC connection successfully when setting it up.
Besides, when connecting via the PSD ODBC importer utility, I can see the list of all tables, select them and view the data in the "Result Preview" panel. On the other hand, the problem appears when starting the import by clicking on the "import" button, nothing happens and no error message comes up.

 

[Philippe Maupoil]

Can I have an update on this pls as I am using it often. Thanks.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.