Having an issue using TOAD for Data Analysts. I am testing some ETL. The source is SQL Server 2008, and the target Oracle 11 on a unix box. I can use TOAD to make successful selects against either the source or the target by themself using the coneections I have set up in TOAD, and I can build a heterogeneous query just as the manual says, and the background watermark “Heterogeneous Query” pops in on query builder, but when I try to run the query, I get following error:
[Microsoft][ODBC Microsoft Access Driver] Reserved error (|); there is no message for this error.
I click OK on that higher level warning, end up with a “Toad for Data Anlaysts Error Message”, label as “Toad for Data Anlaysts 18.104.22.1688”, message within states:
Invalid use of OdbcFunction call. Invalid number of parameters.
at Quest.Toad.Db.Functions.OdbcFunction.ImplementCall(Connection conn, String function, String parTotal)
at Quest.Toad.Db.SqlFunction.EvaluateSql(Connection connection, String sql, Object parameters, IDataParameter& outparameters, Int32& inParameterIndex, Int32& outParameterIndex, Boolean function)
I’ve googled but not found this error. Similar ones, but not this one. Have now read the documentation and see that TOAD is actually using an MS Access database it loaded during it’s installation to my machine. I’ve also read posts here that state that even though I built these connections in TDA that TOAD will “generatee on the fly” ODBC connections to the two different data sources, suck into the Access DB, and do the work there. So somehow, this “generating the ODBC calls on the fly” is apparnelty not workng for me.
In reading the error message I saw the initial reference to an “invalid number of parameters” . . . could this somehow be related to fact that source SQL Server not installed on its default port, and is instead using a differing port than 1433? If so, how do I help TOAD get aorund the obstacle. If not, any ideas on what exacty is the iissue and help would be greatly appreciated!
I am “under the gun” for figuring this out, so Please do feel free to e-mail me follow up questions at firstname.lastname@example.org or call me on my mobile at (336)-816-2586.
Thanks in advance for any assistance you can offer folks!