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
- 8481 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 |
How do I use isdigit function?
How to print \ in php. Only \ with out using . or *.
Is php a dying language?
Is php strongly typed?
how to track no of users logged in?
Why do we use htaccess and where?
What is session in c#?
what is the best function that can be used to connect to mysql database and in what cases that we can use below functions ? 1. mysql_connect() 2. mysql_pconnect() please give your answer with all pros and cons
Which software is used to run php programs?
Tell me what is the use of isset() in php?
Do you know how to enable error reporting in php?
What are the different functions in sorting an array?
PHP 
