Synametrics Technologies

I am attempting to upload 32 rows of data to a remote Oracle server using WinSQL v9 on a Windows 7 LAN system running the 32-bit Microsoft ODBC Administrator and a 32-bit Oracle client v11.2.0.     Not all rows 'make it' to the remote (Internet) server.   Usually, only every 3rd or 4th row makes it to the remote server table.  

This process works flawlessly on my DSL PC, which runs WIndows XP, and 32-bit Oracle client v10.2.      When I connected the Windows 7 LAN PC to the DSL line, it got the same errors that it did on the LAN.

I ran WinSQL in debug mode, and saw these errors:

10/18 3:40PM Fetching available catalog names

10/18 3:40 PM Unable to fetch catalog list. -SQLTables returned an error.    Message: SQL Error State:S1C00, Native Error Code: 0, ODBC Error: [Oracle][ODBC] Driver not capable.

Please advise any ideas!     Thanks!!

I was able to solve this problem using this procedure:

1. Installing (Registering) the WinSQL Oracle driver.
2. Creating a Microsoft ODBC data source for the remote Oracle server using the WinSQL Oracle driver (instead of Oracle's  v11.2 driver)
3. Creating a separate Microsoft ODBC data source for the same remote Oracle server using Oracle's  v11.2 driver (instead of the WinSQL Oracle driver).
4. Upload the data to that remote Oracle server using the ODBC data source that used the  WinSQL Oracle driver.
5. To query the data on the remote Oracle server, I used Showcase Query and the ODBC data source based on  Oracle's  v11.2 driver.

Hmm,

This is really strange. Regardless of the ODBC driver you use, queries should end up with the same result. I know the problem is fixed, but if you are curious run WinSQL in debug mode and switch try recreating the problem with the other driver. WinSQL will log error messags to a file when it is run in debug mode. Check http://web.synametrics.com/DebugMode.htm for help.

Imran