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 |
What is the use of stripslashes in php?
Is it possible to remove the html tags from data?
hey i m a trainee n jus wanted to ask that initially i was given the opportunity for .NET bt that project is abt to complete , nw i m asked to join a project of php on linux which is about to start , so wt say . is it a wise decision to join this project . will i be having job opportunities when i l complete my training after 4 months ? Plz suggest something ASAP .
What is the best website to learn php?
What is the apache?
Is there a way to encrypt text from php?
What is the difference between $_files['userfile']['name'] and $_files['userfile']['tmp_name']?
How is it possible to know the number of rows returned in the result set?
Tell me is it possible to protect special characters in a query string?
Which Scripting Engine PHP uses?
What is the use session in php?
Which PHP function would you use to send an email?