See This

[geopeter]

I'm using Oracle 9i and VB 6.0. What I want is that at the time of app start I want to make connection to oracle taking the username,password and hoststring from my User.Any body knows how to get the all the valid users and host strings of Oracle in VB.I want to show them to the user in a combo.Thanks in advance

[geopeter]

Is there any body out here. why no one is not even looking into this.

[Ecniv]

Erm.

Have a look at Environ$(<number>) where <number> is a valid number from 0 upwards.

If you use Debug.Print and loop through you can see all the environment settings on the computer, of which one might be the user name. Otherwise you'll need a log on screen.


Vince

[geopeter]

Ofcourse I require a Logon screen and in the Logon screen I have two combo one for User and other for Host String.And I need to fill those combos with valid users and host strings.

[Ecniv]

Have a look at ADOX as this has extended functions to ADO - might be a way of getting the user information.

I personally wouldn't use a drop down list, let the user type their logon correctly, or pull it from the machine.


Vince