Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 914
  • Last Modified:

how should i connect mdb database with php on iis server?

how should i connect mdb database with php on iis server? please give me a simple demo.
0
designersx
Asked:
designersx
1 Solution
 
v2MediaCommented:
Set a user/pass on the mdb file.
Upload your mdb file to a folder above your website's root folder so it's inaccessible from the web.
Ensure IUSR_machinename has read/write permissions to the folder/file.
Create a system dsn on iis. If you don't have access to iisadmin, ask your webhost to create a dsn for you.
Connect and interact with the mdb using PHP's odbc functions (http://php.net/manual/en/ref.uodbc.php).
0
 
shobinsunCommented:
Hi,

for example:

$conn = new COM("ADODB.Connection") or die("Cannot start ADO");

// Microsoft Access connection string.
$conn->Open("Provider=Microsoft,.Jet.OLEDB.4.0; Data
Source=C:\\Xitami\\webpages\\sigorta.mdb");

// SQL statement to build recordset.
$rs = $conn->Execute("SELECT ad FROM baydar");

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now