I had an automated process that ran perfectly in a previous version of Toad; every day at 8:00 pm the automation scritp would run producing a series of text files that would be used for reporting in a seperate system. Since we have upgraded Toad this process no longer works. I have narrowed the errors down to the SQL, in particular the error of “[Microsoft] [ODBC Microsoft Access Driver] Too few parameters.”
The data source that i am pulling from is an SQL Database and does not involve MS Access at all.
Here are my questions:
- How do i get around the current ODBC error message?
- Why does Toad want to default to a Heterogenous query connection?