|
|
Choosing A Webhost: |
Failing to connect from Redhat Linux to MS SQL Server: msg#00192db.tds.freetds
Greetings I am developing a Windows application, which reads from a Linux database. Having failed to connect to the Linux server I realized I had to install ODBC which I did. I installed unixodbc2.2.1 and the postgresql driver. On trying to test the installation I was having SQL_INVALID_HANDLE errors which I suspected came from wrong input handles. The connection tests were failing as well. On the window application I started to get an error message like the one on the attached document If I try to create a data source using ODBC32 in the Control Panel the SQLState for the first message is HY000 As a result I had to investigate on TDS . Apparently the message translated to the TDS not compliant so I had to install FreeTDSv.61 ./configure --with-tdsver=4.2 --with-unixodbc=/usr/local/unixodbc-2.2.6 --wi th-prefix=/usr/local/freetds --enable-msdlib --enable-threadsafe --enable-ex tra-checks make make install However I cannot find the setup file for Freetds in /usr/local/freetds/ for me to configure the TDS driver with odbcinst tool. If I run make check the first seven tests are failing due to connection failure. With the driver TDS I cannot connect but with the driver PstgreSQL I can create data sources. Was it necessary that I install Freetds? What could be the problem? Am I missing something somewhere? If any one knows the right procedure please help? Thanks in advance My configuration: > RedHat 7.3 > unixODBC 2.2.6 > PostgreSQL- 7.3 > FreeTDS- 0.61 > MS SQL Server-client-3.70..06.23 for Windows98 Regards, Susan _______________________________________________ FreeTDS mailing list FreeTDS@xxxxxxxxxxxxxxxxx http://lists.ibiblio.org/mailman/listinfo/freetds
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: tsql fails on HP, James K. Lowden |
|---|---|
| Next by Date: | RE: Failing to connect from Redhat Linux to MS SQL Server, Phil Taylor |
| Previous by Thread: | Newbie Install Questions, Duncan Boan |
| Next by Thread: | RE: Failing to connect from Redhat Linux to MS SQL Server, Phil Taylor |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |