A software company, the original is in SQL server 2008, I want to move the database to the mysql database, but the software in the configuration file, how to write the connection string? New inquire!
The content of the original configuration file is like this:
[Connection]
The PROVIDER=sqloledb
The DATA SOURCE=192.168.0.3
Initial catalog=V5HMS
Uid=mysql_long
The PWD=1
Persist Security Info=True
; Integrated Security=SSPI

Mainly is to change the PROVIDER=sqloledb, seek to connect mysql, the PROVIDER=this how to fill out, I found the Internet is similar to the PROVIDER=mysql PROVIDER, but always prompt "fi in" PROVIDER "was not found!

CodePudding user response:

This is the application reads the config file? If so you just modify this is useless, you should modify program code to modify