473,322 Members | 1,526 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

logout for ODBC source ?

Hi!
In MS Access/PostgreSQL combination I have login form. After user writes all
neccessary inputs and push the button, a startup procedure creates DSN-less
connection string, receates all linked tables and change connection string
in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? How to close all ODBC connections and enforce
new login ?
I tried to perform new login with the same login form after already being
login, but it seems that It accepts even wrong passwords after connection
once established (!?) It seems that consecutive login does not affect at
all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.
Nov 13 '05 #1
7 2365
Zlatko Matiæ wrote:
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes all
neccessary inputs and push the button, a startup procedure creates DSN-less
connection string, receates all linked tables and change connection string
in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? How to close all ODBC connections and enforce
new login ?
I tried to perform new login with the same login form after already being
login, but it seems that It accepts even wrong passwords after connection
once established (!?) It seems that consecutive login does not affect at
all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.


Wait for MS to fix Access so that it closes ODBC databases when it's
done with them?

--
[OO=00=OO]
Nov 13 '05 #2
?! :)

"Trevor Best" <no****@besty.org.uk> je napisao u poruci interesnoj
grupi:42***********************@news.zen.co.uk...
Zlatko Matiæ wrote:
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes
all neccessary inputs and push the button, a startup procedure creates
DSN-less connection string, receates all linked tables and change
connection string in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? How to close all ODBC connections and
enforce new login ?
I tried to perform new login with the same login form after already being
login, but it seems that It accepts even wrong passwords after connection
once established (!?) It seems that consecutive login does not affect at
all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.


Wait for MS to fix Access so that it closes ODBC databases when it's done
with them?

--
[OO=00=OO]

Nov 13 '05 #3
Zlatko Matic wrote:
?! :)

"Trevor Best" <no****@besty.org.uk> je napisao u poruci interesnoj
grupi:42***********************@news.zen.co.uk...
Zlatko Matiæ wrote:
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes
all neccessary inputs and push the button, a startup procedure creates
DSN-less connection string, receates all linked tables and change
connection string in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? How to close all ODBC connections and
enforce new login ?
I tried to perform new login with the same login form after already being
login, but it seems that It accepts even wrong passwords after connection
once established (!?) It seems that consecutive login does not affect at
all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.


Wait for MS to fix Access so that it closes ODBC databases when it's done
with them?


My experience with SQL Server and ODBC is that I open a database
variable and have linked tables. Everything is closed and db vars set to
nothing before I close the app. If I close the front end MDB from Access
it does not close the connection to SQL Server until I actually exit Access.

If I close and re-open the app without exiting Access and I log in as
another user I have the problem that my app thinks I'm somebody and SQL
Server thinks I'm somebody else.

You can imagine the problem if the server thinks that numpty logged in
ATM is an admin.

--
[OO=00=OO]
Nov 13 '05 #4
Right!
That bothers me too...
"Trevor Best" <no****@besty.org.uk> je napisao u poruci interesnoj
grupi:42***********************@news.zen.co.uk...
Zlatko Matic wrote:
?! :)

"Trevor Best" <no****@besty.org.uk> je napisao u poruci interesnoj
grupi:42***********************@news.zen.co.uk...
Zlatko Matiæ wrote:

Hi!
In MS Access/PostgreSQL combination I have login form. After user writes
all neccessary inputs and push the button, a startup procedure creates
DSN-less connection string, receates all linked tables and change
connection string in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? How to close all ODBC connections and
enforce new login ?
I tried to perform new login with the same login form after already
being login, but it seems that It accepts even wrong passwords after
connection once established (!?) It seems that consecutive login does
not affect at all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.

Wait for MS to fix Access so that it closes ODBC databases when it's done
with them?


My experience with SQL Server and ODBC is that I open a database variable
and have linked tables. Everything is closed and db vars set to nothing
before I close the app. If I close the front end MDB from Access it does
not close the connection to SQL Server until I actually exit Access.

If I close and re-open the app without exiting Access and I log in as
another user I have the problem that my app thinks I'm somebody and SQL
Server thinks I'm somebody else.

You can imagine the problem if the server thinks that numpty logged in ATM
is an admin.

--
[OO=00=OO]

Nov 13 '05 #5
Bri
Zlatko Matiæ wrote:
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes all
neccessary inputs and push the button, a startup procedure creates DSN-less
connection string, receates all linked tables and change connection string
in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? How to close all ODBC connections and enforce
new login ?
I tried to perform new login with the same login form after already being
login, but it seems that It accepts even wrong passwords after connection
once established (!?) It seems that consecutive login does not affect at
all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.


Are you doing the RefreshLink after you change the Connection? If not,
then the Links are not actually changed in memory. If you are already
doing this then there may not be a solution. I expermented with changing
the connection to invalid values and it errors on the RefreshLink.

--
Bri

Nov 13 '05 #6
Hi!
No, I haven't used RefreshLink yet....I will try.
"Bri" <no*@here.com> je napisao u poruci interesnoj
grupi:Pg0oe.1562597$8l.856396@pd7tw1no...
Zlatko Matiæ wrote:
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes
all neccessary inputs and push the button, a startup procedure creates
DSN-less connection string, receates all linked tables and change
connection string in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? How to close all ODBC connections and
enforce new login ?
I tried to perform new login with the same login form after already being
login, but it seems that It accepts even wrong passwords after connection
once established (!?) It seems that consecutive login does not affect at
all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.


Are you doing the RefreshLink after you change the Connection? If not,
then the Links are not actually changed in memory. If you are already
doing this then there may not be a solution. I expermented with changing
the connection to invalid values and it errors on the RefreshLink.

--
Bri

Nov 13 '05 #7
TableDef.RefreshLink didn't help me.
Bye.

"Bri" <no*@here.com> je napisao u poruci interesnoj
grupi:Pg0oe.1562597$8l.856396@pd7tw1no...
Zlatko Matiæ wrote:
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes
all neccessary inputs and push the button, a startup procedure creates
DSN-less connection string, receates all linked tables and change
connection string in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? How to close all ODBC connections and
enforce new login ?
I tried to perform new login with the same login form after already being
login, but it seems that It accepts even wrong passwords after connection
once established (!?) It seems that consecutive login does not affect at
all after ODBC conncetion once established...
So, how could I close ODBC connection and enforce new login ?
Thanks.


Are you doing the RefreshLink after you change the Connection? If not,
then the Links are not actually changed in memory. If you are already
doing this then there may not be a solution. I expermented with changing
the connection to invalid values and it errors on the RefreshLink.

--
Bri

Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
0
by: Julia Baresch | last post by:
Everyone, I posted the message below back in February and didn't get any information. I also wasn't able to find any documentation in MS Help, web site, or other groups. I'm posting now with...
5
by: Alec | last post by:
Hi All, I am currently trying to link in Access 97 to a table in a MSSQL 7 server. Initially the link is fine, however, when I close the access database and re-open it from the same network...
2
by: Crazy Cat | last post by:
Hi all, I am having trouble getting linked Oracle 9 server in MS SQL Server 2005 Express to work properly. My machine is running Windows XP. The Microsoft and Oracle OLE DB Providers have...
2
by: somersbar | last post by:
im trying to get a basic ASP.NET application running. im trying to display data from a microsoft access database on my web form. im trying to bind the data to a data-grid. but i get the following...
0
by: bazzer | last post by:
hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in...
16
by: network-admin | last post by:
We have Problems with Access query on Oracle 10g Database with ODBC Connection. The Query_1 is such as select * from xtable where ycolumn <"S" Result = ODBC Faild...
7
by: Salad | last post by:
I am converting an application from A97 to A2003. I have 2 tables created by another application as a Foxpro.dbf. The table has no index. The connect string in A97 is FoxPro...
3
by: Salad | last post by:
With the database window open I click on Help, then click on "About Microsoft Office Access". A dialog window is presented and there are 4 buttons at the bottom right of the form. One is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.