[freetds] can FreeTDS be use for MS Access?

martin martin at siamect.com
Thu Nov 17 07:56:34 EST 2005


I'm running PHP from Apache using PDO which is great and it uses FreeTDS
(so it's not off topic I hope) to talk to other databases including
MS-SQL ,MySQL and more. It is quite transparent and I use only an
include file of 5 rows or so to decide what database to use...all other
is the same... like this:

<?php
// Connect to a database using driver invocation

//MS-SQL
//putenv ("TDSVER=7.0");
//putenv ("TDSPORT=1433");
//$dsn = 'dblib:host=149.133.144.144;dbname=Tst_Data';
//$user = 'mydomain\myusername';
//$password = 'xxxx';

//MySQL
$dsn = 'mysql:dbname=test;host=localhost';
$user = 'root';
$password = '';

?>  

So if you need to mess with Access then make Acess dump the data into
MS-SQL and then you can run PDo from PHP on your Apache.
Best regards
Another Martin

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Bing Du
Sent: Thursday, November 17, 2005 4:17 AM
To: freetds at lists.ibiblio.org
Subject: [freetds] can FreeTDS be use for MS Access?


Hello,

I've not tried it myself yet.  Is it possible?  If not, anybody know or
use any open source solution for Access?  As far as I know, FreeTDS can
talk to Sybase and MS SQL.

Thanks,

Bing
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

-- 
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date:
11/10/2005
 

-- 
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date:
11/10/2005
 




More information about the FreeTDS mailing list