T
Tim Bücker
Hello.
I am trying to get a connection to MySQL using OleDb but it seems that I am
making something wrong.
I´ve found this source in the net but it doesn´t work for me:
System.Data.OleDb.OleDbConnection con;
con=new System.Data.OleDb.OleDbConnection("");
con.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test;";
con.Open();
Where can I set the path to my localhost where mySql is running?
Trying to put it in Data Source I get an exception - invalid filename
Is the provider ok? Don´t I need a username and password?
And how does the connection string look when I want to create my FIRST
database?
Can I then leave the Data Source empty?
Having less experience working with databases I am also thankful for any
good resource tips on the net.
Thanks to anyone who can help me out!
Desperate greetings,
Tim.
I am trying to get a connection to MySQL using OleDb but it seems that I am
making something wrong.
I´ve found this source in the net but it doesn´t work for me:
System.Data.OleDb.OleDbConnection con;
con=new System.Data.OleDb.OleDbConnection("");
con.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test;";
con.Open();
Where can I set the path to my localhost where mySql is running?
Trying to put it in Data Source I get an exception - invalid filename
Is the provider ok? Don´t I need a username and password?
And how does the connection string look when I want to create my FIRST
database?
Can I then leave the Data Source empty?
Having less experience working with databases I am also thankful for any
good resource tips on the net.
Thanks to anyone who can help me out!
Desperate greetings,
Tim.