Connection: changing connection string in data environment
Connection: changing connection string in data environment
Author
Message
Jean Trude #1 / 1
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