Skip to Content.
Sympa Menu

freetds - Re: mssql connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Brian Bruns" <camber AT ais.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: mssql connection
  • Date: Mon, 15 Jul 2002 14:43:51 -0400


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--




Archive powered by MHonArc 2.6.24.

Top of Page