Toad World® Forums

Getting Object reference not set to an instance of an object. Error

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.

No idea where to go to from he

re.

Where do you store the CSV file? Does importing the file work fine?

The cvs is on a local drive and as you can see from above, it imports fine and I can view the table and data.

I have other .csv and excel files that are brought in the same way and they have no issues.

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.

Glad you were able to get around the issue.