I am trying the add a .csv file as a data source in TOAD data point 5.2.1. the file imports OK an displays in my Nav Manager and Object Explorer. I can even view the tables and details. but if I ty to run a SQL query on this data It get this errror: Object reference not set to an instance of an object.
Hmmmm, is there anything "special" about this particular file then?
How are you executing your SQL... via the Editor or via the Query Builder?
What happens when you right-click the CSV in your object explorer and choose Generate SQL->Select Statement->To Editor and execute it?
I had to rename the app date files and rerun toad, That seem to solve it, expect I could not use any of the fields in ‘Where’ clause, or select them. So I ended up creating a new data set from the table and importing that.