|
Home > Archive > Red Hat Topics > December 2005 > unixODBC -- can't make it work
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
unixODBC -- can't make it work
|
|
| mlpomeroy@earthlink.net 2005-12-11, 2:46 am |
| Help please.
I'm trying to use php on a REDHAT linux Enterprise 4 machine to access
MS SQL Server on a Windows Server 2003 machine through an ODBC
connection.
I've read the manuals and searched the Internet and tried everything I
can think of, but I know I'm missing something. Other people seem to
be doing it with no problem.
When I try to reinstall unixODBC using Red Hat's own rpm version I get
the message that it is already installed.
But I don't seem to know how to use it to make my ODBC connection.
ODBCConf doesn't see any other ODBC specific drivers (Only sees the
driver for Postgres), and php commands without the unixODBC Connection
fail.
Got it working fine on Windows XP using correct drivers, but I need it
to work from my linux server!
Advice and assistance will be very much appreciated .....
Mike
| |
| Markku Kolkka 2005-12-11, 7:45 am |
| mlpomeroy@earthlink.net wrote:
> I'm trying to use php on a REDHAT linux Enterprise 4 machine to access
> MS SQL Server on a Windows Server 2003 machine through an ODBC
> connection.
>
> I've read the manuals and searched the Internet and tried everything I
> can think of, but I know I'm missing something.
You are missing the ODBC driver for MS SQL Server. I don't know if such
a thing even exists for RHEL4.
UnixODBC is just the ODBC driver manager, you need to install a separate
database-specific driver for each DB server type.
> ODBCConf doesn't see any other ODBC specific drivers (Only sees the
> driver for Postgres)
Do you _have_ any other drivers installed?
--
Markku Kolkka
markku.kolkka@iki.fi
| |
| Lenard 2005-12-11, 5:47 pm |
| mlpomeroy@earthlink.net wrote:
> Help please.
>
> I'm trying to use php on a REDHAT linux Enterprise 4 machine to access
> MS SQL Server on a Windows Server 2003 machine through an ODBC
> connection.
Maybe; http://dag.wieers.com/packages/shellsql/
--
"A personal computer is called a personal computer because it's yours,
Anything that runs on that computer, you should have control over."
Andrew Moss, Microsoft's senior director of technical policy, 2005
|
|
|
|
|