Skip to Content.
Sympa Menu

freetds - Re: mssql connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Eric Deutsch" <edeutsch AT systemsbiology.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: mssql connection
  • Date: Mon, 15 Jul 2002 11:17:24 -0700



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





Archive powered by MHonArc 2.6.24.

Top of Page