FreeTDS Development Group

[James Leigh <james AT clickmedia.ca>]

cool,  I had the adm create a new username/password for mssql.  I can
not connect to it through sqsh and isql.  Great, now does anyone have
experience with gnome-db and odbc?

thanks for the help,
james

On Mon, 2002-07-15 at 14:43, Brian Bruns wrote:
    sqsh -U"James Leigh" -S<servername> -P<password>
    
    where servername is as it appears in your freetds.conf file.  If it
    doesn't work set the TDSDUMP environment variable like,
    
    export TDSDUMP=/tmp/freetds.log
    
    and look there for what is going on.
    
    Brian
    
    > --=-s46wa/UWJqXL43CklUlC
    > Content-Type: text/plain
    > Content-Transfer-Encoding: quoted-printable
    > 
    > I don't know how to use sqsh, but it seems to do that same thing
    > everytime.  How should it be used?  The docs say I should get a chance
    > to type something before it kicks me out like this.
    > 
    > 
    > 
    > $ export SYBASE=3D/usr
    > $ sqsh
    > sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
    > This is free software with ABSOLUTELY NO WARRANTY
    > For more information type '\warranty'
    > Password:=20
    > Server SYBASE not found!
    > 
    > 
    > On Mon, 2002-07-15 at 14:30, Brian Bruns wrote:
    >     Start by getting sqsh working, it's a whole lot simpler and go from 
the=
    > re.
    >      If the servers are using domain logins, we may have a problem 
since we
    >     have been as yet unable to make that work.  *However* seeing as you 
hav=
    > e a
    >     working ethereal configuration, if you'd care to put some elbow 
grease =
    > in,
    >     we may be able to make a go of it.  Otherwise, if the servers are 
in mi=
    > xed
    >     mode, then there shouldn't be any problem.
    >    =20
    >     Brian
    >    =20
    >     > 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 ma=
    > chine
    >     > 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/sqs=
    > h or
    >     > anything that can connect.
    >     >   It uses a NT domin login, my domain user name also has a space 
if t=
    > hat
    >     > 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 he=
    > lp.
    >     >=20
    >     > /home/.james/.freetds.conf:
    >     > [global]
    >     >         # TDS protocol version
    >     >     tds version =3D 4.2
    >     >     initial block size =3D 512
    >     >     swap broken dates =3D no
    >     >     swap broken money =3D no
    >     >     try server login =3D yes
    >     >     try domain login =3D no
    >     >     cross domain login =3D no
    >     > [JDBC]
    >     >     host =3D 192.138.151.39
    >     >     port =3D 4444
    >     >     tds version =3D 5.0
    >     > [dbserver]
    >     >     host =3D 192.168.1.1
    >     >     port =3D 1433
    >     >     tds version =3D 7.0
    >     >     try domain logins =3D yes
    >     >     try server logins =3D no
    >     >     nt domain =3D MY_DOMAIN
    >     > /etc/odbcinst.ini:
    >     > [TDS]
    >     > Driver              =3D /usr/lib/odbc/libtdsodbc.so
    >     > Setup               =3D /usr/lib/odbc/libtdsS.so
    >     > FileUsage   =3D 2
    >     > /home/james/.odbc.ini:
    >     > [dbserver]
    >     > Driver              =3D TDS
    >     > Description =3D internal database server
    >     > Trace               =3D No
    >     > Servername  =3D 192.168.1.1
    >     > Database    =3D db_name
    >     > UID         =3D James Leigh
    >     > $ isql -v cmserver03 "James Leigh" my_password
    >     > [unixODBC]tds_connect failed
    >     > [ISQL]ERROR: Could not SQLConnect
    >    =20
    >     ---
    >     You are currently subscribed to freetds as: [james AT clickmedia.ca]
    >     To unsubscribe, forward this message to 
leave-freetds-144898E@franklin.=
    > oit.unc.edu
    >    =20
    > --=20
    > 
    > 
    >    James Leigh
    >    Developer
    > 
    >    Click Media Inc.
    >    clickmedia.ca
    >    (905) 833-3994   ext.#118
    > 
    > --=-s46wa/UWJqXL43CklUlC
    > Content-Type: application/pgp-signature; name=signature.asc
    > Content-Description: This is a digitally signed message part
    > 
    > -----BEGIN PGP SIGNATURE-----
    > Version: GnuPG v1.0.6 (GNU/Linux)
    > Comment: For info see http://www.gnupg.org
    > 
    > iEYEABECAAYFAj0zFXgACgkQNW7L7+EGFkKpEQCgthdJdigGmmYOb0mtOvh9SUO5
    > sYkAmwfpM9Twc86s0G2ODp5b3hoOkftQ
    > =nvL6
    > -----END PGP SIGNATURE-----
    > 
    > --=-s46wa/UWJqXL43CklUlC--
    
    ---
    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
    
-- 


   James Leigh
   Developer

   Click Media Inc.
   clickmedia.ca
   (905) 833-3994   ext.#118

Attachment: signature.asc
Description: This is a digitally signed message part