I have a DataSet .XSD that contains all my table adapters and queries from our Oracle database. This has been working fine until our Oracle DBA implemented a Unicode conversion on the database this past weekend. Now when my .Net apps call a query from my .XSD, the query works, but the text fields displays blanks instead of the data.

I believe the problem to be with the driver I am using. My .XSD uses the '.Net Framework Data Provider for Oracle'.

I also have a VFP app that can query this same Oracle database just fine. I did not make any changes to this app. But my VFP app uses a System DSN that I created. This System DSN uses the Microsoft ODBC for Oracle driver.

I have been trying to get my .Net .XSD to use this System DSN but have not been able to.

How can I get my .Net .XSD to use a System DSN? Or, is there any other solution to get my .Net app to read Oracle Unicode tables?

Thanks,

Jerry