I've tried this approach under IIS using ASP, works perfectly, but under Apache it says "Cannot open with jet". If code is: $db = 'C:\Program Files\Microsoft Office\Office11\SAMPLES\Northwind.mdb'; $conn = new COM('ADODB.Please, help me to connect to DB from PHP under Apache without DSN. Connection') or exit('Cannot start ADO.'); // Two ways to connect. $conn-Open("DRIVER=; DBQ=$db") or exit('Cannot open with driver.'); ...Note: If connecting from your home computer, you need a My SQL client like Navicat, php My Admin, Workbench or Dreamweaver.See our article on Managing Your Database with Applications for some suggested programs and more details.Hello adesh, 50MB is the size limit for database imports on a shared server.You will need to contact Live Support to have them import anything larger than that.In order to get your SQL file to load you will need to remove the CREATE SCHEMA line at the beginning of your code, this tutorial here can help If the database that you are trying to import is over 50 MB in size, then you will be able to import the database through php My Admin on shared servers.Only VPS/Dedicated server accounts with root access can import a database larger than 50 MB using the command line access.
It is possible for someone to use their c Panel username and password to connect to the database.
Having a dynamic IP address means that the connecting IP address can change periodically depending on the Internet Service Provider (ISP).
You must update the connecting IP in Remote My SQL every time it changes.
In this tutorial, we will show you how to import a My SQL Database using php My Admin.
We'll assume that you've already exported your database, and it is either a .sql, zip, or file.