ODBC Connector override via VB

------_=_NextPart_001_01C534D4.8EC5BA62
Content-Type: text/plain;
charset="ISO-8859-1"

Hi

I am using MySQL ODBC 3.51 driver as the connection mechanism between a MySQL 4.0.20-standard DB and a Microsoft Access 2000 front-end. The ODBC is setup to default login into the DB as guest with associated privileges. What I'd like to do is provide a login/password screen on the Access front-end that allows a user to login in as a different user and hence override the guest settings in the ODBC connector.

The intention is to allow anyone on the project to access the DB and view reports, but only select uses to make changes. My problem is if I set the ODBC connector to login as a myself (Admin privileges) I am able to access the DB using the front end with my expected privilege levels. Conversely, If I attempt to override using the Access front-end I end up with guest privileges and not my own. Does anyone have a VB code snippet that allows you to override the default ODBC settings on a given machine or suggestions on how I should attack this issue.

Robert M. Bartis



------_=_NextPart_001_01C534D4.8EC5BA62--

RE: ODBC Connector override via VB

I would recommend http://www.vbmysql.com/projects/vbmysqldirect/

It's what I use in VB rather than MyODBC.

I don't think there is a way of overriding the permissions you created
with the DSN except to make the connection again. With VBMySQLDirect it
works like ADO and you make the connection from your program.

I have a similar situation to you with one of my applications. When the
program is fired up normally, the user gets connected to a standard
account that only has read access. If the program is run with a command
line that has the word "login" on it then it pops up a login dialog box
and makes the connection with the user name and password that is entered
there. That's what I use when I use the application.

John Bonnett

-----Original Message-----
From: Bartis, Robert M (Bob) [mailto:bartis@lucent.com]=20
Sent: Wednesday, 30 March 2005 12:42 PM
To: 'myodbc'
Subject: ODBC Connector override via VB

Hi
=20
I am using MySQL ODBC 3.51 driver as the connection mechanism between a
MySQL 4.0.20-standard DB and a Microsoft Access 2000 front-end. The ODBC
is setup to default login into the DB as guest with associated
privileges. What I'd like to do is provide a login/password screen on
the Access front-end that allows a user to login in as a different user
and hence override the guest settings in the ODBC connector.=20
=20
The intention is to allow anyone on the project to access the DB and
view reports, but only select uses to make changes. My problem is if I
set the ODBC connector to login as a myself (Admin privileges) I am able
to access the DB using the front end with my expected privilege levels.
Conversely, If I attempt to override using the Access front-end I end up
with guest privileges and not my own. Does anyone have a VB code snippet
that allows you to override the default ODBC settings on a given machine
or suggestions on how I should attack this issue.
=20
Robert M. Bartis=20

=20

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg