Toad World® Forums

Question about Toad Data Point

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:

  1. How do i get around the current ODBC error message?
  2. Why does Toad want to default to a Heterogenous query connection?