Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to connect to a Microsoft Access database
without a DSN? If so, how??
- 3 Answers
- 8648 Views
- I also Faced
- E-Mail Answers
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 |
Explain what is the static variable in function useful for?
What is php trait?
Write down the benefits of php7?
What is the difference between htmlentities and htmlspecialchars in php?
Tell me are parent constructors called implicitly inside a class constructor?
What is php key?
How to change the principal password?
What are the rules in creating php variable?
How does php isset work?
Explain the visibility of the property or method?
What happens when submit button is clicked?
What is the meaning of "enctype= multipart/form-data" ?
PHP 
