Hi @Angsuman Ganguly ,
To access any database through ODBC, you must first install a 32-bit ODBC driver on your device.
thanks but tried with the same and getting a different error
@Angsuman Ganguly
Download and install mysql odbc drivers: 32 bit version
https://dev.mysql.com/downloads/connector/odbc/
Use connection string and replace with your corresponding values(server-address,dbname,username,password):
DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=server-address;DATABASE=dbname;USER=username;PASSWORD=password;OPTION=3;
Tried but getting same error. Username and password can be random ? I tried Mysql password but didn't help
Hi @Angsuman Ganguly ,
Could you try following the steps detailed in this tutorial and see if that works out for you?
Kind Regards,
Ashwin A.K
How was this issue resolved. I am facing the same issue for connecting the Oracle DB. Any pointers will help greatly.
Procedure to connect to an Oracle Database.
Instructions
- Check which driver required from driver matrix.
- Download the driver.
https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
- Then add the jdbc connection string.
https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html
Additional Information
https://www.codejava.net/java-se/jdbc/connect-to-oracle-database-via-jdbc
https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdbc/JDBC-getting-started.html#GUID-00FE03D7-48D6-4DA5-A3A0-8768D2936AB8
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.