Skip to Content.
Sympa Menu

freetds - Re: [freetds] can FreeTDS be use for MS Access?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "martin" <martin AT siamect.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] can FreeTDS be use for MS Access?
  • Date: Thu, 17 Nov 2005 19:56:34 +0700

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






Archive powered by MHonArc 2.6.24.

Top of Page