how we change Conection String in VB.NET?
Hari om 0 Newbie Poster
Santanu.Das 125 Santanu Das
What do you mean by change Conection String ?
Please describe it.
If you have some codes please post them.
Reverend Jim 4,968 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
It's just a string. Change it like any other string. If you don't know what to change it to please refer to connection string reference.
Sugmuffen 3 Newbie Poster
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;"
Santanu.Das 125 Santanu Das
@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.
Reverend Jim 4,968 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.