Connection string to ms-access database not correct in deployed PHP site [duplicate]

Question

I have successfully made a connection to my access database on my local computer but when I upload my config.php file which contains the connection string on my web server and when the insert command runs it displays a blank page without making entries to the database.

 $conn = new COM ("ADODB.Connection")
  or die("Cannot start ADO");
  $connStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=/onlineadmission.mdb;Jet OLEDB:Database Password=;";
  $conn->open($connStr);

It works well on my local computer but not when uploaded.
Where is the problem?

Provide valid DB credentials

Nouphal.M
– Nouphal.M

2014-02-25 14:36:25 +00:00
Commented Feb 25, 2014 at 14:36 — Nouphal.M
– Nouphal.M, Commented Feb 25, 2014 at 14:36

Community · Accepted Answer · 2023-11-17 20:07:23Z

0

Are you sure that the selected driver (Microsoft JET OLEDB 4.0) is installed on the server?

Also put your code into an try-catch block to catch the COM exceptions

edited Nov 17, 2023 at 20:07

CommunityBot

11 silver badge

answered Feb 25, 2014 at 14:43

Simon Blok

664 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aniket Over a year ago

i did it.. no errors. but when i use firephp it says "500 Internal Server Error". i have tested the code on local machine i get the o/p properly

Collectives™ on Stack Overflow

Connection string to ms-access database not correct in deployed PHP site [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related