473,324 Members | 2,548 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,324 software developers and data experts.

closing ODBC connection ?

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 ? I would like to allow users to login/logout
consecutively from MS Access front-end without need to close front-end.
I tried to perform new login with the same login form after already being
login, but it seems that Access accepts even wrong passwords after
connection
once established (!?) It seems that consecutive login does not affect at
all, after ODBC connection was once established...If you give correct
username, new DSN-less connection will be accepted even if the password is
wrong...tabledef.RefreshLink didn't help...
So, I think that I have to close all ODBC connections (linked tables,
pass-through queries) somehow and the enforce new login. How to do it ?

Also, I tried to use pg_shadow system table for inspecting whether password
is OK, but it seems that password is encrypted, so Access can't compare
password from pg.shadow and password on the login form. What to do in order
that Access can see actual password from pg_shadow ?

Thanks.
Nov 13 '05 #1
1 2452
On Sun, 5 Jun 2005 12:54:50 +0200, "Zlatko Matiæ"
<zl***********@sb.t-com.hr> 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 ? I would like to allow users to login/logout
consecutively from MS Access front-end without need to close front-end.
I tried to perform new login with the same login form after already being
login, but it seems that Access accepts even wrong passwords after
connection
once established (!?) It seems that consecutive login does not affect at
all, after ODBC connection was once established...If you give correct
username, new DSN-less connection will be accepted even if the password is
wrong...tabledef.RefreshLink didn't help...
So, I think that I have to close all ODBC connections (linked tables,
pass-through queries) somehow and the enforce new login. How to do it ?

Also, I tried to use pg_shadow system table for inspecting whether password
is OK, but it seems that password is encrypted, so Access can't compare
password from pg.shadow and password on the login form. What to do in order
that Access can see actual password from pg_shadow ?

Thanks.

Hi

Are DSN-less connections ODBC?
For ODBC you might be able to see what is going on by switching
tracing on. Be careful not to leave it on though as it produces a lot
of output!
David

Nov 13 '05 #2

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

Similar topics

0
by: Sean Anderson | last post by:
ODBC under System DSN Setup Access Driver give it the DSN (Data Source Name) MSA Click on Select and point to the myfile.mdb (your database file)
5
by: SerGioGio | last post by:
Hello, I am going nuts. I am trying to connect to my local ORACLE instance using ODBC. It used to work few weeks ago, but it fails now. Connection with: - SQL*plus: connection works! -...
0
by: Steve Barker | last post by:
Hi guys, I've written an application in C# that connects to a Paradox table via ODBC. My code has always worked fine, but now I've moved my application to another machine, it's stopped working!...
0
by: Kevin | last post by:
I am running INSERT INTO queries using ODBC connections to grab data from 3 different Sybase servers. 2 of these servers are remote and use an ISDN on demand connection to connect. My queries work...
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...
0
by: Zlatko Matiæ | last post by:
Hello. I created a login form that creates connection string (DSN-less) and starts procedure that connects to PostgreSQL server.I didn't know how to connect to server without performing anything...
13
by: Simon Harvey | last post by:
Hi All, I have a colleague that I wprk with that develops using ASP. I develop using ASP.net. He seems to make sites much faster than me and I am wondering if its because of the two different...
4
by: arbpen | last post by:
I am concerned about performance. Usually, in a situation where I am not using a global.asa (shared host, etc), I explicitly close the connection at the bottom of the page in a footer, eg:...
5
by: zacks | last post by:
If I close and dispose an ODBCConnection object, shouldn't the connection actually close? I have found that even after closing and disposing an ODBCConnection, the database it was connected to...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
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.