These forums are read-only and considered to be an archive. Please use the new Community for future interaction and posts.

Will File Vista support MYSQL?

Will File Vista support MYSQL?
Ester 7/8/2007 12:26 AM
We have not tested it against MySQL but I think it can already work. FileVista uses OleDb connections so if you have the exact database structure in MySQL then it should work as expected.

To create the database in MySQL, you can use the script at App_Data/database/CreateSqlServerDB.sql.

Then, you will need to change the connection string in App_Data/FileVista.config file to a MySql connection string like:

Provider=MySQLProv;Data Source=DATABASENAME;User Id=USERNAME;Password=PASSWORD; 

Let me know about the results.
Cem Alacayir 7/11/2007 4:36 AM