Skip to Content.
Sympa Menu

freetds - Re: mssql connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Leigh <james AT clickmedia.ca>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: mssql connection
  • Date: 15 Jul 2002 15:19:20 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page