Re: ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC
| From: | Nabil | Date: | Mon, 28 Jul 2003 11:46:12 +0000 |
| Subject: | Re: ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29512@lists.php.net to get a copy of this message | ||
these are not working because i need to connect ro Micro$oft SQL server 7
NOT to mysql nor postgresql
"Jason Wong" <php-db@gremlins.biz> wrote in message
news:200307281916.30950.php-db@gremlins.biz...
> 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.
> */
>