Is it possible to connect to a Microsoft Access database
without a DSN? If so, how??
Answers were Sorted based on User's Feedback
Answer / binu. v. pillai
Yes, we can
<?php
//Connect access database
$con=odbc_connect("DRIVER={Microsoft Access Driver
(*.mdb)}; DBQ=" . str_replace("/", "\\", $_SERVER
["DOCUMENT_ROOT"]) . "\foldername\dbname.mdb", "db_username"
, "db_password")or die("could'nt connect database");
if (!$con) {
die('Could not connect: ' . odbc_error());
}
?>
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / ramachandra dixith
ya its working niceley in my local system
still i have to check in server...
any way code is connecting database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ghan shyam
yes it is posible to connect ms access database without dsn
you have to provide Driver for database and database path in odbc_connect function. like :
odbc_connect(DRIVER={Microsoft Access Driver
(*.mdb)}; DBQ="{database path}", "{db username if any}"
, "{db_password if any}") or die("could not connect to database");
| Is This Answer Correct ? | 0 Yes | 0 No |
Name some of the constants in php and their purpose.
How session manage in wordpress
Which php mvc framework is best?
Can we use include (?abc.PHP?) two times in a PHP page ?makeit.PHP??
what is mean by portal
What is the name of the scripting engine that powers PHP?
What are getters and setters php?
What is meant by content management system?
3 Answers Global Logic, IBEE, TCS, Toyota,
What is php full form?
Is php dying 2018?
Write a program to display table of a number using php?
What is difference between single quotes and double quotes in php?