Hi. I don't know the correct wording here, so forgive me.
I am opening a table (Actually a passthrough query) that sends the login info and what not, but once it runs, there is no login request for any other actions.
What I want to do is sever the connection, so the next action has to re-log in.
Why? Because the same ODBC source, with different log in information, yields different table data.
Any suggestions would be very helpful. Right now, all I can do is run one, exit the DB completely, go back in, and rerun. Or wait about 5 minutes for the connection to terminate on it's own.
Thanks,
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
I am opening a table (Actually a passthrough query) that sends the login info and what not, but once it runs, there is no login request for any other actions.
What I want to do is sever the connection, so the next action has to re-log in.
Why? Because the same ODBC source, with different log in information, yields different table data.
Any suggestions would be very helpful. Right now, all I can do is run one, exit the DB completely, go back in, and rerun. Or wait about 5 minutes for the connection to terminate on it's own.
Thanks,
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.