Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Terminate Connection to ODBC Source

Status
Not open for further replies.

Blorf

Programmer
Dec 30, 2003
1,608
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top