Skip to Content.
Sympa Menu

freetds - Re: [freetds] Freetds + MS SQL Server 2000 on unix

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Dan Zemke <jdzemke AT yahoo.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Freetds + MS SQL Server 2000 on unix
  • Date: Wed, 8 Feb 2006 12:37:18 -0800 (PST)

Hello - Have you tried the port 1433?

On a separate issue. Does anyone have a fix for the
error below. I am selecting a column (column is 10
characters long) from a table in a SQL Server 2000
database through an Oracle database link using freetds
(v0.63 with protocol v7.0) and unixodbc. I don't get
this error when using the unixodbc isql utility.


ORA-28500: connection from ORACLE to a non-Oracle
system returned this message:
[Generic Connectivity Using ODBC][H00C] Attempt to
access a column debit_invoice_accessory_counter with
unsupported name length (greater than 30 characters).
ORA-02063: preceding 2 lines from



--- age85 AT gmx.de wrote:

> Hello NG,
>
> i try to access an MS SQL Server 2000 database with
> the latest stable
> freetds release. I've configured and installed
> freetds with the following
> commandline parameters --with-unixodbc=/usr/local
> and --with-tdsver=8.0
> everything ends fine. Then I've configured the SQL
> Server to use the SQL
> Server and Windows Authentication. But if I try:
>
> tsql -H 192.168.100.166 -p 1272 -U Administrator
>
> im getting the password prompt, after entering the
> password im getting:
>
> Msg 20020, Level 9, State 0, Server OpenClient, Line
> 0
> Unknown marker
> Msg 20014, Level 9, State 0, Server OpenClient, Line
> 0
> Login incorrect.
> There was a problem connecting to the server
>
> I also tried:
> tsql -S myserver -U Administrator
>
> with the following in freetds.conf:
>
> [myserver]
> host = 192.168.100.166
> port = 1272
> tds version = 8.0
>
> But getting the same error message (after password
> entering). What could be
> wrong? Any help would be greatly appreciated.
>
> Thx René
>
> --
> DSL-Aktion wegen großer Nachfrage bis 28.2.2006
> verlängert:
> GMX DSL-Flatrate 1 Jahr kostenlos*
> http://www.gmx.net/de/go/dsl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com




Archive powered by MHonArc 2.6.24.

Top of Page