RE: [SM-USERS] SM on Windows server + SQL Server

[Freedman, D. B - A. VA - C. <Dan...@us...>]

Thank you Rafael,

	I was able to get SM to work via ODBC, the docs on Pear were
close, but unclear, so good old trial and error helped me find the
settings:

Odbc://userid:pwd@DSN

Thanks again,

Dan



-----Original Message-----
From: Rafael Martinez Guerrero [mailto:r.m...@us...]=20
Sent: Friday, October 01, 2004 6:46 AM
To: Freedman, Daniel B - Arlington, VA - Contractor
Cc: squ...@li...
Subject: Re: [SM-USERS] SM on Windows server + SQL Server

On Thu, 2004-09-30 at 21:07, Freedman, Daniel B - Arlington, VA -
Contractor wrote:
> Hi all,
>=20
> 	I am running SM (now 1.43) and trying to use SQL Server as my DB
> for addresses and prefs.
>=20
> I set up the database and ODBC but now SM wants a type in the DSN
string
> like MYSQL//host etc
>=20
> The code looks at the lead in to pick what connection type to use but
I
> only see 3 type in there.=20
>=20
> Has anybody else done this or have any input
>=20

No with ODBC or MSSQL but with postgreSQL, MySQL and Oracle.

Good information about the format to use with DSN can be found in the
URL - (PEAR-DB DSN) that I give you at the final of this e-mail.

Squirrelmail uses PEAR's Database Abstraction Layer (PEAR-DB) so it
should work with ODBC. PEAR-DB supports MSSQL too so you should be able
to talk directly with your database insteed than via ODBC.

You need of course a PHP installation that supports what you try to use
via PEAR-DB.=20


PEAR-DB:=20
http://pear.php.net/package/DB

PEAR-DB DSN:=20
http://pear.php.net/manual/en/package.database.db.intro-dsn.php

PHP MSSQL:
http://www.php.net/manual/en/ref.mssql.php


--=20
 Rafael Martinez, <r.m...@us...>
 Center for Information Technology Services
 University of Oslo, Norway