Graphics

I try to connect DataLinq with a MySQL database running on the same computer where Xpression is on.

I use Xampp as local webserver with MySQL/PHPMyadmin

If i open the DataLinq Server and Add New.. On the Add Datalinq Source i select ADODB Source in the ADODB Datalinq Configuration i Select Template... and then i picked Template MySQL

Provider=MySQLProv;

Data Source=[DataBase];

User Id=[UserName];

Password=[Password];

change it:

Provider=MySQLProv;

Data Source=[127.0.0.1];

User Id=[MyUserName];

Password=[MyPassword];

when i hit OK and Test my Connection i get a error

Failure: Provider cannot be found. It may not be properly installed

i run Xpression V5.9 Build 3162

How can i get it to work?

You need to remove the square brackets :)

#XPression

When you click on the installed providers tab, do you see the MySQL provider listed?

If not, you will need to find the MySQL installer for the OLE DB connector. Try searching the web for 32 bit MyOLEDB connector and give that a try. It should show up in the 'Installed Providers' tab.

#XPression