I am developing some PHP programs for a website. I've been developing locally on my laptop using Apache. Locally, I can access, insert, and modify the tables in my ACESS database.
When I uploaded everything to the server, I can still acess the database to get info, but when I try to insert or update different tables I get a NULL return from odbc_exec.
Does anyone have suggestions?
2007-04-24 08:45:45 · 4 answers · asked by Navidad_98 2 in Computers & Internet ➔ Programming & Design
Just a suggestion but I would not try to use Access on a live server. MySql will way out perform it and its open source. Access only allows 5 connections at a time!
2007-04-28 01:07:32 · answer #1 · answered by Tracy L 7 · 0⤊ 0⤋
Don't forget to create a ODBC DNS on your server (under the Control Panel). The ODBC configuration is "per computer", you have to set it up on each computer.
Also, make sure that the IIS (or Apache) user has Write access to the DB.
Then, make sure that your Access database is accessible from both locations. If you have 2 database, you'll make them point to 2 different locations (but be careful when you program to make sure that any changes on your laptop DB is replicated to your server DB).
2007-04-24 08:56:52 · answer #2 · answered by Bernz 6 · 0⤊ 0⤋
maximum good cyber web hosting have mssql databases on them. You surely in simple terms want a script to take your kind imput and write it to the database. there are particularly some unfastened very own abode page scripts on the cyber web which you will adjust to try this. you may in all probability additionally locate one which you will actually use to create your database itself.
2016-10-30 04:57:41 · answer #3 · answered by student 4 · 0⤊ 0⤋
Make certain your user ID has the rights to insert and update.
2007-04-24 08:50:55 · answer #4 · answered by Krista 4 · 0⤊ 0⤋