Hi Thearon,
The beginning Visual Basic book 2005, is a great book where we can work with Oracle and SQL servers,and using BLL/DAL which it is the ideal method for serious developer in developing 3 Tier application, and avoiding creating Dataset through the wizard.

However, I have a problem to apply your code in my projects, where we the developers do not have Admin rights to use the registry.
Please, can you help to get the Login Screen working without using the object of the "RegistryKey" in the WDBASE.VB module?

I appreciate any help in running your application in Oracle 9.2 without the RegistryKey.
Best Regards,
Stephen

Stephen,

You can use the application's configuration file. Open your project in Visual Studio and then double click on "My Project" in the Solution Explorer. When the application properties window appears, click on the Settings tab on the left side. You can place the information that you would have stored in the registry here.

Remember to also copy these settings to any other application that would normally need to read those settings from the registry.

Thearon

Thanks Thearon:
The Scope should be "User" or "Application"?
For now my setting is scope:User, Type:Connection:
Value: Data Source=OracleDB;Persist Security Info=True;User ID=USERNAME;Password=PASSWORD;Unicode=True

So where I should add the line: objReg = Registry.LocalMachine.OpenSubKey("SOFTWARE\" & _
                    Company & "\" & Application & "\Database", False)

Do I keep it in the WDABASE?
Thanks

Stephen,

If you want the application to be able to update the settings then the scope should be "User" as this allows read and write capability. A scope of "Application" is read only.

Assumming you are using SQL Server and the connection string was set in the WroxDataAccess project and called "Connection", you could use the following line of code to build your SQLConnection object:

Connection = New SqlConnection(My.Settings.Connection)

This will retrieve the connection string from the component's configuration file and instantiate a new SqlConnection object.

Thearon

Thank you Tearon very much, your answer is very helpful.
I am using ORACLE 9.2+ VS2005 Win Forms, My connection string is defined as:

Public cn As OracleConnection = New OracleConnection(ConfigurationManager.ConnectionSt rings("OraDB").ConnectionString)

Thanks and best regards,
Stephen