4
Contributors
5
Replies
16
Views
2 Years
Discussion Span
Last Post by Reverend Jim
0

What do you mean by change Conection String ?
Please describe it.
If you have some codes please post them.

0

Access example:

Dim strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb"

SQL server example (assuming SQL security is used):

Dim strConnectionString = "Server=localhost;Database=databaseName;User Id=sa;
Password=something;"
0

@Jim: Did you mean OP tries to use various database system simultaneouly in his app ?
MS SQL(20?? ?), MySql, Access, Oracle, DB2 everything simultaneously. Great Job.

0

That's certainly possible. I've written many applications that take data from one data source and update another. That requires two different connection strings (using two simultaneous connections). However, the OP might be wanting to change an application to switch from one backend database to another, say Access to MS SQL. That would require only one connection with a change to the connection string.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.