initializing variable

[EyeTalion]

I have the code below in a module, but when I debug and check the value of strCon, the UserID and Password asre missing from the string, but when I put the cursor over origLogon and origPass they do have the correct values...how can I get the strCon variable to initilize?

thanks

Public strCon As String = "Provider=MSDAORA;Password=" & origPass & ";User ID=" & origLogon & ";Data Source=dbatest"

[trisuglow]

Looks fine to me. What data type are your origPass and origLogon variables? If they are strings then you shouldn't have a problem.

[EyeTalion]

Module Module2
Public origLogon As String
Public origPass As String
Public strCon As String = "Provider=MSDAORA;Password=origPass;User ID=origLogon;Data Source=dbatest"
Public objCon As New OleDbConnection(strCon)

[Cander]

origLogon and origPass do not have values when strCon is populated. Thts why. It doesnt work the way you are thinking where if they are set later, that strcon is going to automatically change. Un uh. Doesnt do that.

[EyeTalion]

is there a way I can go back and initilize strCon after I get values for the userid and password?

[Cander]

yeah
strCon = "Provider=MSDAORA;Password=" & origPass & ";User ID=" & origLogon & ";Data Source=dbatest"

[EyeTalion]

?

[Cander]

whats confusing? You just set the variable again.

[Pirate]

If you can put your code in a class and build a constructor which is mainly created for intializing variables . Whenever you intantiate obj from this class , then you have to provide these two variables .

[Cander]

more work than necessary for something so simple.

[EyeTalion]

whats confusing? You just set the variable again.

but it's in my module, how do I call it?

wait, I think it's beginging to sink in...just set the variable again in the form instead of the module?

[Pirate]

Cander is right but I thought of constructors as ideal option . strCon variable will hold the last value origLogon and origPass were set to ! It should work fine . And you can create two properties to set those two variables if you want .

[shutty]

Originally posted by Cander
more work than necessary for something so simple.

VB.NET is an OO language it should go in a class however simple.