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...I f you give correct
username, new DSN-less connection will be accepted even if the password is
wrong...tablede f.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. 1 2492
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 consecutivel y 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...I f you give correct username, new DSN-less connection will be accepted even if the password is wrong...tabled ef.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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)
|
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!
- DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection
works when I hit the driver's "test connection"
|
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! However, the way in which it has stopped
working is very strange.
Here is an example program that demonstrates my problem:
================
|
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 fine but my
connections are not terminating. I "Close" the ADODB.Connection and
set it to "Nothing". Only terminating Access will release the
connection.
This is a problem because the connection being open keeps the ISDN
modem tied up and when...
|
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 lacation on a different
machine, it tells me that the ODBC connection to 'SQL Server Name'
failed.
How can I create the linked table permenant no matter what machine the
networked database is opened on?
| |
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 so I managed that connection is
established by executing a query that returns current_user...I have two
questions regarding that issue:
1. Is it possible to establish ODBC connection without performing query, so
that such connection is used for...
|
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 technologies. I use codebehinds as standard
Does anyone else find that developing with ASP.net takes more work than asp.
|
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: conn.Close set
conn = nothing
Now, I am working with a global.asa file, and the following:
sub Application_OnStart
conString = "driver={sql server}......"
Application("conString")=conString
set Conn = Server.CreateObject("ADODB.Connection")
|
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 still
has an active connection as long as the application is still running.
I have to close the application to actually close the active
connection to the database. Is this normal behaviour? Is there a way
to really close the connection while the...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |