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 |
=== represents what?
2 Answers Ephron Systems, NetTrackers,
Describe the importance of DABA BASE ABSTRACTION LAYERS in PHP and database connection?
What is the correct and the most two common way to start and finish a php block of code?
How can you get the size of an image in PHP?
Can we run php in apache tomcat?
Which software is used to run php programs?
Does PHP 5 support exceptions? State Whether True or False?
How to create reusable code in php?
How do I start a php session?
What is $_ post in php?
Do you know what is use of count() function in php?
Is php 7.0 stable?