Problems with unixodbc on RedHat 9
| From: | Spirovski Bozhidar | Date: | Wed, 06 Aug 2003 13:30:09 +0000 |
| Subject: | Problems with unixodbc on RedHat 9 | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-11396@lists.php.net to get a copy of this message | ||
have installed freetds and unixODBC on a RedHat 9 box.
The problem is that i persistently cannot connect to a SQL server. What
seems to be the error???
This is the actual configuration and the tests i performed
# /usr/local/freetds/bin/tsql -S MyServer70 -U sa
locale is "en_US.UTF-8"
charset is "UTF-8"
Password:
Msg 5703, Level 0, State 1, Server ACSSQL, Line 0
Changed language setting to us_english.
# isql -v MyServer70 sa password
[unixODBC]Client unable to establish connection
[ISQL]ERROR: Could not SQLConnect
[root@skopjanka etc]# cat /etc/odbcinst.ini
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
[TDS]
Description = v0.52 with protocol v4.2
Driver = /usr/local/freetds/lib/libtdsodbc.so
FileUsage = 1
cat /etc/odbc.ini
[MyServer70]
Driver = TDS
Description = Northwind sample database
Trace = No
Servername = 195.26.152.120
Database = Northwind
UID = sa
Spirovski Bozhidar
System Engineer, MCP, MCSA
MTnet
Orce Nikolov b.b. 1000 Skopje
Macedonia
Phone: +389 2 3296091
Fax: +389 2 3213480
E-mail: bozidar@mt.net.mk