Connection: changing connection string in data environment 
Author Message
 Connection: changing connection string in data environment

Is it normally possible to change the connection string of a connection that
is part of a data environment?
The connection has a connection string already set in the development
environment but we wish to use an udl file in the production environment.
This file could then be changed without having to modify the program code.
When I try to connect using
    dataenvironment.Connection1.Open "File Name=" & "file.udl"
I get the error message  no 3001 saying that the parameters are not valid or
in conflict with other parameters or out of authorized limits.
This command works well with a connection object declared in code.
Is there a solution to this problem?  Or the connection cannot be changed?
Thank you very much,
Jean Trudel

Tue, 03 Dec 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Changing Data Environment Connection String

2. Problem while changing the connection string in Data Environment

3. Data Environment and setting the connection string via code

4. Changing Database Connection In Data Environment

5. Changing Connection Name in Data Environment

6. Changing Data Environment Connection at runtime

7. Deploying ADO Data bound controls / changing connection string

8. closing ADO data controls and data environment connections

9. MS SQL connection string for remote internet connection?

10. Need Connection string for VB6 DAO DSN-LESS Connections to SQL Server 2000

11. Connection string for DSN-less Informix connection

12. Connection String vs. Connection Object


Powered by phpBB® Forum Software