Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 myODBC -> No Login page?

Author  Topic 

neutcomp
Posting Yak Master

111 Posts

Posted - 2003-10-09 : 04:08:22
Hello,

I dont know If this is a good place to ask but I will do so.
I have a Access application that is connected with a mySQL database.

For the connection there is installed a myODBC driver. It works fine, but the firsttime the application has to have some information from the database the myODBC screen will popup and asked me to enter a username. Is there a way I can automatiqly fill in the username. So I dont have to bother the user with this popupscreen?

Thanxx
Bjorn

<edit> Moved to Other Topics </edit>

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-09 : 12:26:37
For other ODBCs, the information is stored in the registry. It is possible that you can just create a reg file that will do this for the user.

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC

You could then deploy the reg file using a login script or through the installation of your software.

Tara
Go to Top of Page

neutcomp
Posting Yak Master

111 Posts

Posted - 2003-10-10 : 02:15:22
Oke, I will try to find the right register key.
And maby I find a way to generate a reg file where the password is stored.

Thanxx for the idea!

Cya
Bjorn
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-10 : 12:47:22
Just take a look at the registry key mentioned above. Then see if one exists for the one that you setup on your machine. Then make the modification to it, if possible. Then you can export that information into a reg file using File..Export. When it saves with a reg extension, all that you have to do is double click on the file for it to load the registry with the information. To take a look at the file, just right click and go to edit.

Tara
Go to Top of Page
   

- Advertisement -