FreeTDS Development Group

[Gal Rubinstein <galrub AT gmail.com>]

 On 9/20/2010 7:24 PM, Andrew H. Wakefield wrote:
> G
> al, it sounds like you are having trouble getting the basic 
> connectivity going. Panos is right: the first step is to test using 
> tsql, which should be included as one of the utility apps. This will 
> let you check to see that you have your parameters correct. You can 
> connect directly to a given IP address and port, or you can connect 
> using a server described in the freetds.conf file.
>
> Grace & peace,
>
> Andy Wakefield
>
> /Andrew H. Wakefield/
> /Dean and Professor of New Testament and Greek/
> /Lewis Edward and Martha Barnes Tyner Professor of Bible/
> /Campbell University Divinity School/
> /P. O. Drawer 4050/
> /Buies Creek, NC 27506/
> /910-893-1830/
> /wakefield AT campbell.edu <mailto:wakefield AT campbell.edu>/
>
> Please consider the environment before printing this email.
>
> -----Original Message-----
> *From*: Panos Stavroulis <pstavroulis AT yahoo.co.uk 
> <mailto:Panos%20Stavroulis%20%3cpstavroulis AT yahoo.co.uk%3e>>
> *Reply-to*: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> *To*: Gal Rubinstein <galrub AT gmail.com 
> <mailto:Gal%20Rubinstein%20%3cgalrub AT gmail.com%3e>>
> *Cc*: freetds AT lists.ibiblio.org <mailto:freetds AT lists.ibiblio.org>
> *Subject*: Re: [freetds] Help connecting with tds to MSSQL 2008
> *Date*: Mon, 20 Sep 2010 14:19:28 +0000 (GMT)
>
> I haven't started using freetds yet but I think you can use the tsql utility 
> to see if you can actually connect to SQL Server. Also check your 
> configuration file freetds.conf if your sql server has correct name etc. I am 
> far from being called an expert in freetds, so maybe someone else knows 
> better...
>
> Panos.
>
> --- On Mon, 20/9/10, Gal Rubinstein<galrub AT gmail.com  
> <mailto:galrub AT gmail.com>>  wrote:
>
> >  From: Gal Rubinstein<galrub AT gmail.com  <mailto:galrub AT gmail.com>>
> >  Subject: Re: [freetds] Help connecting with tds to MSSQL 2008
> >  To: "Panos Yahoo"<pstavroulis AT yahoo.co.uk  
> <mailto:pstavroulis AT yahoo.co.uk>>
> >  Cc:freetds AT lists.ibiblio.org  <mailto:freetds AT lists.ibiblio.org>
> >  Date: Monday, 20 September, 2010, 14:49
> >     On 9/20/2010 3:41 PM, Panos
> >  Yahoo wrote:
> >  >  Your boss should be more open minded sorry! You can
> >  use c++ within .net that's your best chance for a easy and
> >  reliable application plus productive developers.
> >  >
> >  >
> >  >  Panos
> >  >  --------------------
> >  >  sent from my mobile
> >  >
> >  >  -----Original Message-----
> >  >  From: Gal Rubinstein<galrub AT gmail.com  <mailto:galrub AT gmail.com>>
> >  >  Sent: 20 September 2010 13:21
> >  >  To: Panos Stavroulis<pstavroulis AT yahoo.co.uk  
> <mailto:pstavroulis AT yahoo.co.uk>>
> >  >  Cc:freetds AT lists.ibiblio.org  <mailto:freetds AT lists.ibiblio.org>
> >  >  Subject: Re: [freetds] Help connecting with tds to
> >  MSSQL 2008
> >  >
> >  >     On 9/20/2010 1:35 PM, Panos Stavroulis
> >  wrote:
> >  >>  Hi,
> >  >>
> >  >>  Can I ask you why you need freeTDS if you your
> >  client is a windows server? Why are you not using .NET ADO
> >  native drivers? Just use the standard microsoft .net
> >  connectivity which should be faster as well, at least in
> >  theory. Then use the .NET language of your choice, I would
> >  go with C#.
> >  >>
> >  >>  Panos.
> >  >>
> >  >>  --- On Mon, 20/9/10, Gal Rubinstein<galrub AT gmail.com  
> <mailto:galrub AT gmail.com>>    wrote:
> >  >>
> >  >>>  From: Gal Rubinstein<galrub AT gmail.com  <mailto:galrub AT gmail.com>>
> >  >>>  Subject: [freetds] Help connecting with tds to
> >  MSSQL 2008
> >  >>>  To:freetds AT lists.ibiblio.org  <mailto:freetds AT lists.ibiblio.org>
> >  >>>  Date: Monday, 20 September, 2010, 11:44
> >  >>>     Hello all.
> >  >>>
> >  >>>  I have a an SQL server 2008 installed with
> >  default values
> >  >>>  on local machine (my pc).
> >  >>>
> >  >>>  I'm trying to connect using libTDS.lib but I
> >  cannot seem to
> >  >>>  get the parameters right.
> >  >>>
> >  >>>  the debugger shows that  I reach the
> >  ling
> >  >>>  "tdsdump_log(TDS_DBG_ERROR, "Server %s not
> >  found..."
> >  >>>  meaning that the server was not found. (yes,
> >  daaa!).
> >  >>>
> >  >>>  I'm very new to  Sql Servers, so, please,
> >  help me
> >  >>>  out.
> >  >>>
> >  >>>  Thanks,
> >  >>>  Gal
> >  >>>
> >  _______________________________________________
> >  >>>  FreeTDS mailing list
> >  >>>  FreeTDS AT lists.ibiblio.org  <mailto:FreeTDS AT lists.ibiblio.org>
> >  >>>  http://lists.ibiblio.org/mailman/listinfo/freetds
> >  >  thank you for the replay,
> >  >
> >  >  The reason is that that my boss says no to .NET, and,
> >  the client is
> >  >  already written in native c++.
> >  >
> >  >  can you help me with this?
> >  >
> >  >  Thank you,
> >  >  Gal
> >  >
> >  I understand that, but, for the time being, can anyone
> >  help?
> >  I'm not trying to change my Boss, I'm trying
> >  to finish this so I can get payed (like all of use,
> >  right?),
> >  so, can anyone help me with this?
> >
> >  in any case, we wrote this project in standard c++, nothing
> >  specially
> >  for MS. because the might like to migrate to Linux, and
> >  then,
> >  the whole .NET thing is out of the question... right?
> >
>
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org  <mailto:FreeTDS AT lists.ibiblio.org>
> http://lists.ibiblio.org/mailman/listinfo/freetd  
> <http://lists.ibiblio.org/mailman/listinfo/freetds>
as afar as I can tell, from debugging, libTDS fails to open a socket.:
net.c,
at the line: if (TDS_IS_SOCKET_INVALID(tds->s = socket(AF_INET, 
SOCK_STREAM, 0))) {.....

as for tsql, do you know of a windows version?

ps: here is the dump:
log.c:190:Starting log file for FreeTDS 0.65
    on 2010-09-20 22:05:11 with debug flags 0x4fff.
config.c:172:Getting connection information for [GAL-PC:1433].
config.c:176:Parsed servername, now GAL-PC on 1433.
config.c:181:Attempting to read conf files.
config.c:310:... $FREETDSCONF not set.  Trying $FREETDS/etc.
config.c:323:... $FREETDS not set.  Trying $HOME.
config.c:253:Found conf file 'c:\freetds.conf' (default).
config.c:398:Looking for section global.
config.c:455:    Found section global.
config.c:458:Got a match.
config.c:479:    tds version = '4.2'
config.c:479:    dump file = 'c:\temp\freetds.log'
config.c:479:    timeout = '10'
config.c:479:    connect timeout = '10'
config.c:479:    text size = '64512'
config.c:455:    Found section gal-pc.
config.c:469:    Reached EOF
config.c:398:Looking for section GAL-PC.
config.c:455:    Found section global.
config.c:455:    Found section gal-pc.
config.c:458:Got a match.
config.c:479:    host = '127.0.0.1'
config.c:508:Found host entry 127.0.0.1.
config.c:512:IP addr is 127.0.0.1.
config.c:479:    port = '1433'
config.c:479:    tds version = '7.0'
config.c:469:    Reached EOF
config.c:257:Success: [GAL-PC] defined in c:\freetds.conf.
config.c:558:tds_config_login: client_charset is ISO-8859-1.
config.c:195:Final connection parameters:
config.c:196:             server_name = GAL-PC
config.c:197:                    port = 1433
config.c:198:           major_version = 7
config.c:199:           minor_version = 0
config.c:200:              block_size = 0
config.c:201:                language = us_english
config.c:202:          server_charset =
config.c:203:         connect_timeout = 10
config.c:204:        client_host_name =
config.c:205:                app_name = my_app
config.c:206:               user_name = test
config.c:209:                 library = TDS-Library
config.c:210:               bulk_copy = 0
config.c:211:       suppress_language = 0
config.c:212:           encrypt level = 0
config.c:213:           query_timeout = 10
config.c:216:          client_charset = ISO-8859-1
config.c:217:                 ip_addr = 127.0.0.1
config.c:218:           instance_name =
config.c:219:                database =
config.c:220:               dump_file = c:\temp\freetds.log
config.c:221:             debug_flags = 0
config.c:222:               text_size = 64512
config.c:223:            broken_dates = 0
config.c:224:            broken_money = 0
config.c:225:      emul_little_endian = 0