Last post Jan 05, 2021 06:16 AM by venkatzeus
Jan 04, 2021 05:34 PM|venkatzeus|LINK
Is it possible to connect to JDBC database link from ASP.NET web application ?
I have a jdbc link, to which I want to connect and query a table.
String databaseURL = "jdbc:mysql://localhost:3306/test";
How to achieve this in C# ?
Jan 05, 2021 05:54 AM|XuDong Peng|LINK
In Java, you could obtain a Connection instance that is connected to a particular database by calling
DriverManager.getConnection(url) using the
databaseURL you mentioned.
But in C#, if you want to connect to MySql database, you need to use
MySql.Data.MySqlClient reference, and follow its specifications and use the correct connection string to get the connection instance.
string connStr = "server=localhost;database=test;port=3306;user=xxx;password=xxx";
MySqlConnection conn = new MySqlConnection(connStr);
You could also refer to this offcial document.
Jan 05, 2021 06:16 AM|venkatzeus|LINK
The Jdbc connection url I have is the IBM Robot scheduler.
I have this JDBC link only as a database connection.