Skip to Content.
Sympa Menu

freetds - RE: mssqlserver connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Anders Johansson" <anders.johansson AT infogate.se>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: mssqlserver connection
  • Date: Thu, 8 Nov 2001 14:31:02 +0100


Hmm..tried to do that but no progress.
downloaded both versions(Version 0.53pre1 , freetds-current.tgz )
the freetds-current.tgz didn't compile

and the other one I did the following with.
setenv TDSDUMP /tmp/freetds.log
./configure --with-tdsver=7.0
make;
make check;

My configuration looks like this.


********************************
PWD file.
UID=anders
PWD=I2KQJuV6
SRV=dynamasterdb
DB=tempdb
********************************
freetds.conf file
# any value here may be overridden in the dataserver specific section
[global]
tds version = 7.0
initial block size = 512
swap broken dates = no
swap broken money = no
# if both server and domain logins are enabled freetds will try domain
login
# first if a domain is specified, and then fallback to server logins.
try server login = yes
try domain login = no
# the default domain can be overridden by using the DOMAIN\username
format.
; nt domain = WORKGROUP
# if the server responds with different domain try that one?
dump file = /tmp/freetds.log
debug level = 10
timeout = 10;
connect timeout = 10;


# a typical MS SQL 7.0 configuration
[dynamasterdb]
host = 192.168.110.64
port = 1433
tds version = 7.0
*****************************
output from make check.
make check-TESTS
make[4]: Entering directory
`/root/sql-relay/freetds-0.53/src/tds/unittests'
t0001.c: Testing login, logout
FAIL: t0001
t0002.c: Test basic submit query, results
FAIL: t0002
t0003.c: Testing DB change -- 'use tempdb'
FAIL: t0003
t0004.c: Test large (>512 bytes) queries
FAIL: t0004
t0005.c: Test large (>512 bytes) replies
FAIL: t0005
t0006.c: Test SYBREAL, SYBFLT8 values
FAIL: t0006
===================
6 of 6 tests failed
***********************************

Unfortunatelly, the log file is always empty. So there is nothing to work on
there.


I am trying connect to a Microsoft SQLServer 2000 on a windows 2000
machine.

there is a user with the correkt password on the sqlserver, AND a windows
user with the same login/passwd. The authentification of user is based on
both windows login and sql server login..had to change the default
settings wich were set to windows login.

the machine answers on telnet to port 1433

tds version is 7.0




Thanx in advance
./anders











-----Original Message-----
From: bounce-freetds-138178 AT franklin.oit.unc.edu
[mailto:bounce-freetds-138178 AT franklin.oit.unc.edu]On Behalf Of Brian
Bruns
Sent: Thursday, November 08, 2001 1:27 PM
To: TDS Development Group
Subject: [freetds] RE: mssqlserver connection


Hi,

can you set the TDSDUMP environment variable, like:

export TDSDUMP=/tmp/freetds.log

and then post the log file. *Note:* the log will contain the password you
used to connect so some hand editing to remove prior to posting it would
be a good idea. (I should make password blanking an option eh?)

Brian

On Thu, 8 Nov 2001, Anders Johansson wrote:

> Hi everyone!
> Where can I get the latest freeTDS source?
> I have tried to make an connection from redhat linux to a windonws 2000
> machine runnin Microsoft Sql Server 2000 but failed.
> I am using Version 0.53pre1.
> Would be really nice with some assistence from you guys!
> Thanks in advance
> ./anders
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>


---
You are currently subscribed to freetds as: [anders.johansson AT infogate.se]
To unsubscribe, forward this message to
$subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page