FreeTDS Development Group

[Paul Thurston <pthurston AT netegrate.com>]

Gal:

Sometimes this problem is due to environment variable settings.
On the Windows Platform, SET FREETDSCONF=<full path to your freetds.conf file>

Also, in the freetds.conf file, make sure to use IP Addresses, and not host 
names.

Best,

Paul


From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Gal Rubinstein
Sent: Tuesday, September 21, 2010 9:25 AM
To: freetds AT lists.ibiblio.org
Subject: [freetds] Fwd: Re: Help connecting with tds to MSSQL 2008 - problem 
found


  Hello all,



the after looking into the socket problem it accrued to me that I forgot to 
mention an important fact, I'm using windows 7.

RAW sockets have been limited on this version of windows!



http://msdn.microsoft.com/en-us/library/ms740548(VS.85).aspx

<http://msdn.microsoft.com/en-us/library/ms740548%28VS.85%29.aspx>



on a different site

(http://cs.baylor.edu/~donahoo/practical/CSockets/practical/

<http://cs.baylor.edu/%7Edonahoo/practical/CSockets/practical/>) a different 
socket connection method is used, using connect().

the function called is :int connect(int socket, const struct sockaddr* addr, 
int addrlen)



since I'm quite a beginner in C++, can anyone add this alternative to the 
net.c source, maybe surround it with a #ifdef.



Thanks a lot...



PS: cant wait to move to linux with this project, only after we show a

WIN7 version can we move on... damn!



-------- Original Message --------

Subject:    Re: [freetds] Help connecting with tds to MSSQL 2008

Date:       Mon, 20 Sep 2010 22:20:30 +0200

From:       Gal Rubinstein <galrub AT gmail.com>

To:   Andrew H. Wakefield <wakefield AT campbell.edu>

CC:   freetds AT lists.ibiblio.org







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> 
> <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<mailto: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> 
> <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<mailto:galrub AT gmail.com%20%20%3cmailto: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<mailto:galrub AT gmail.com%20%20%3cmailto: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>  
> > <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>  
> <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



_______________________________________________

FreeTDS mailing list

FreeTDS AT lists.ibiblio.org<mailto:FreeTDS AT lists.ibiblio.org>

http://lists.ibiblio.org/mailman/listinfo/freetds