Sqlserver ODBC: is there something available like substitute in sql.ini?

forum.connectivity (1998-2005) & forum.td.connectivity (2005-2010)
Johann
Austria
Posts: 181
Joined: 30 Mar 2017, 09:58
Location: Vienna

Sqlserver ODBC: is there something available like substitute in sql.ini?

Post by Johann » 02 Oct 2009, 12:14

 Posted by:  Mag. Johann Gregorich 

Hi to All,

I'm looking for a solution to substitute parts of a sql-statement during
runtime, similar to the substitute definitions in sql.ini, but in a normal
odbc environment (without any odbc router from gupta/centura/unify). The app
is not a TD-App, but a reporting systems like business objects etc.

What I want to change on the fly, is e.g sysadm.table_xy to
test.table_xy

Any hint in that direction is very appreciated

Regards
Hans

Ingo Pohl

Sqlserver ODBC: is there something available like substitute in sql.ini?

Post by Ingo Pohl » 07 Oct 2009, 08:58

 Posted by:  Ingo Pohl 

First Idea was to look for some free odbc-tracer and to use their
sourcecode.
But what i saw so far was that they use the build in tracing functionality.
Those ones have the con that you cant manipulate the statement

Maybe this is a direction where you should point to...
I mean there must be somehwere a tracing tool which let you not only log the
statement but manipulate it also...

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 1 guest