Use Public Constant in ConnectionString Property

[cnealy]

I declared a Public Constant in a .bas module.

Public Const iConnectionString As String = _
"Data Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\TCJPD\VB Project Files\Test_TCJPD_Data.mdb;" & _
"Jet OLEDBatabase Password=tcjpd"

Now I'm trying to use the constant as the connection string throughout the application. However, when I reference the constant in the properties window of an ADODC, the connection fails. Is it possible to reference a public constant from the properties window?

 

[JpPhysics]

Check your Connection String

ADODC.ConnectionString = "driver={SQL Server};" & _
"server=bigsmile;uid=sa;pwd=pwd;database=pubs"

 

[cnealy]

ConnectionString is fine. I referenced it in code, and it worked fine. The problem is using the Constant in the Properties Window of an ADODC.

For example, this works fine in code.
cn.ConnectionString = iConnectionString

However, if I type iConnectionString in the Properties Window for the ConnectionString property of the ADODC, I can't connect to the database.