2. PHPRunner General questions
  3. Getting database to work on a remote server
This topic is locked

Getting database to work on a remote server

 		7/14/2009 12:55:54 AM
PHPRunner General questions
B
 bago07 author

I'm new to PhPRunner! I have an MSAccess database that I used to build my project. Everything seems to work just fine on my localhost!
I uploaded the output files to the remote directory in the hope that the database would function just as well as on my local machine. Well I was wrong!
I get the following message when following the link to the database:
"Fatal error: Call to undefined function odbc_connect() in /home/a3049260/public_html/Office Directory/include/dbconnection.php on line 7"
I was under the impression that the database files or database is coded in MYSQL when I build the application on my local machine and that they are then uploaded with all the other files when FTPing to the remote host. There seems to be little infomation on how to properly get the database on line.
If there is anyone out there that can give me step by step instructions on how to accomplish this I would be most greatfull.
Thank you for your troubles in solving mine!
bago07
J
 		Jane 7/14/2009

Hi,
please make sure that your server is Windows-based.

Support of the Access database is on the Windows-based hosting.
U
 		Urnso 7/17/2009

I ran into the same problem on some of my access tables. You will need to add the ODBC source on the server just like you did on your local machine.
Control Panel>Admin Tools>ODBC
Select System DSN tab

Click Add

Select Access driver from list.
Then name your data source as the same on your localhost Then select the database .mdb. That should do it.
Now when your php tries to connect to the .mdb it will have the ODBC link to it.
ode 7/28/2009

I have the same problem. I use win XP and xampp as a server, and I make a full application using phprunner in the server. But when i try to open the web from client computer, it display error. What should I do?