FreeTDS Development Group

["Eric Deutsch" <edeutsch AT systemsbiology.org>]

I am not 100% certain, but I do not think that domain logins are fully
implemented yet.  Only standard SQL Server account logins work at this
time.


> -----Original Message-----
> From: James Leigh [mailto:james AT clickmedia.ca]
> Sent: Monday, July 15, 2002 11:12 AM
> To: TDS Development Group
> Subject: [freetds] Re: mssql connection
> 
> $ isql -v dbserver "James Leigh" my_password
> [unixODBC]tds_connect failed
> [ISQL]ERROR: Could not SQLConnect
> 
> 
> using ethereal: there is no activity to the dbserver host.  It must be
> some configuration problem.
> 
> james
> 
> On Mon, 2002-07-15 at 14:07, Peter Harvey wrote:
>     What does isql show when you use -v option?
> 
>     Peter
> 
>     James Leigh wrote:
> 
>     >I cannot get odbc to work at all.  I could really use detailed
>     >step-by-step example with field explination.  I am the only
debian
> machine
>     >is a feild of win32 computers.  I need to connect to an mssql
server.
> I
>     >want to use gnome-db/gasql.  but right now I will settle for
> isql/sqsh or
>     >anything that can connect.
>     >  It uses a NT domin login, my domain user name also has a space
if
> that
>     >means something.  This is waht I have so far.  I am very
confused.  I
>     >could never get odbc to work in win32 or liunux and could use
some
> help.
>     >
>     >/home/.james/.freetds.conf:
>     >[global]
>     >        # TDS protocol version
>     > tds version = 4.2
>     > initial block size = 512
>     > swap broken dates = no
>     > swap broken money = no
>     > try server login = yes
>     > try domain login = no
>     > cross domain login = no
>     >[JDBC]
>     > host = 192.138.151.39
>     > port = 4444
>     > tds version = 5.0
>     >[dbserver]
>     > host = 192.168.1.1
>     > port = 1433
>     > tds version = 7.0
>     > try domain logins = yes
>     > try server logins = no
>     > nt domain = MY_DOMAIN
>     >/etc/odbcinst.ini:
>     >[TDS]
>     >Driver           = /usr/lib/odbc/libtdsodbc.so
>     >Setup            = /usr/lib/odbc/libtdsS.so
>     >FileUsage        = 2
>     >/home/james/.odbc.ini:
>     >[dbserver]
>     >Driver           = TDS
>     >Description      = internal database server
>     >Trace            = No
>     >Servername       = 192.168.1.1
>     >Database = db_name
>     >UID              = James Leigh
>     >$ isql -v cmserver03 "James Leigh" my_password
>     >[unixODBC]tds_connect failed
>     >[ISQL]ERROR: Could not SQLConnect
>     >
>     >---
>     >You are currently subscribed to freetds as:
> [pharvey AT codebydesign.com]
>     >To unsubscribe, forward this message to leave-freetds-
> 144898E AT franklin.oit.unc.edu
>     >
>     >
> 
> 
> 
> 
>     ---
>     You are currently subscribed to freetds as: [james AT clickmedia.ca]
>     To unsubscribe, forward this message to leave-freetds-
> 144898E AT franklin.oit.unc.edu