FreeTDS Development Group

[Dan Zemke <jdzemke AT yahoo.com>]

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