Re: Pear::DB and FreeTDS
| From: | Adam Hubscher | Date: | Fri, 17 Dec 2004 13:55:44 +0000 |
| Subject: | Re: Pear::DB and FreeTDS | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-16283@lists.php.net to get a copy of this message | ||
so far the DSNs i have tried are:
mssql://user@pass:host:port/db
mssql://usr@pass:tcp(host:port)/db
and the freetds config:
[MyServer2k]
host = (my hostname)
port = 2433
tds version = 8.0
Utilizing tsql to connect, I have been able to connect using freetds, and
login properly. Just, I dont know how to do it with pear::db?
"Markus Wolff" <wolff@21st.de> wrote in message
news:41C2B54B.1070709@21st.de...
> Adam Hubscher wrote:
> > Hello, I am having a slight problem with utilizing PHP, MSSQL, PearDB
and
> > FreeTDS. I have tested the connection with FreeTDS, and I have
successfully
> > connected. However, after trying many different combinations of DSNs for
> > pear::db, I have not figured out how to get it to connect!
> [...]
> > I have php 5.0.2 compiled with freetds support, as well as mssql
support. I
> > am using apache 1.3.3. any other information I suppose I can give o.o
SQL
> > server 2000 too btw.
>
> How does your FreeTDS config entry for the SQL server look like? And
> what exactly did you try as DSN yet?
>
> CU
> Markus