OpenEuphoria

Re: Matt's ODBC

• Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Nov 15, 2006
• 569 views

George Walters wrote:
>
> Matt, I'm trying to figure out the best way to deal with users and passwords
> in my software using your ODBC wrapper. I'm thinking it would best be done 
> with your dataSourcesODBC( ) routine if it could also return the user and 
> password in addition to the DSN's which is also stored in the same place on
> XP. Is this possible, or 
> does this not make sense? Currently I have "root" and "" hard coded in the 
> programs, which I think is not the way it should be done, and certainly not
> functional when accessing the DB remotely.

Yes, I think hardcoding like that is the wrong way to go.  I don't think
that users and passwords are stored anywhere that odbc can access it.  The
users and passwords are set on the database itself.  If you wanted, you
could store them yourself locally (encrypted, of course).  

A better way is probably to use openDriverConnectionODBC().  It will have
the ODBC driver prompt the user for his id and password.

Matt