Set a Connection object's .Connectionsource property at run time
I would like to be able to set a connection object's .Connectionsource property
at run time.
At design time I create a connection object in the dataEnvironemt designer.
It is a JET 4.0 OLE provider and this is set on the "provider" tab. I then
set the full path and database name on the "connection" tab. This works fine.
If you hit F4 and view the value in the Connectionsource property, it contains
both the provider and connection info.
I need to set this at run time because when my app gets installed somewhere
else, the database will be in another path.
I store the path to the database in a .ini file that gets read at run time
but when I try setting this property directly in the main module of my app
as well as other places, I allways get an error message. Help !!!
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL