Re: ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC
| From: | Jason Wong | Date: | Mon, 28 Jul 2003 11:16:30 +0000 |
| Subject: | Re: ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29509@lists.php.net to get a copy of this message | ||
On Monday 28 July 2003 18:13, Nabil wrote:
> Please Jason help me to do this .... The sql server is on 192.168.0.101 IP
> address.
>
> Please give me a sample of how can i config these files : "/etc/odbc.ini"
> & "/etc/odbcinst.ini"
As an example my /etc/odbc.ini contains:
[MySQL-test]
Description = MySQL database test
Driver = MySQL
Server = localhost
Database = test
Port = 3306
Socket =
Option =
Stmt =
and /etc/odbcinst.ini contains
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so.2
Setup = /usr/lib/libodbcpsqlS.so.1
FileUsage = 1
[MySQL]
Description = ODBC Driver for MySQL
Driver = /usr/lib/libmyodbc.so.2
Setup = /usr/lib/libodbcmyS.so.1
FileUsate = 1
CPTimeout =
CPReuse =
Best refer to the unixODBC docs for more info.
> Should i add any entry to freetds.conf ... and can you tell me what is the
> .so file that works with MS SQL7 that i should point to.
No idea, never used freetds before.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
Children are like cats, they can tell when you don't like them. That's
when they come over and violate your body space.
*/