Skip to Content.
Sympa Menu

freetds - [freetds] Fwd: Re: Help connecting with tds to MSSQL 2008 - problem found

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Gal Rubinstein <galrub AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Fwd: Re: Help connecting with tds to MSSQL 2008 - problem found
  • Date: Tue, 21 Sep 2010 15:25:09 +0200

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

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





Archive powered by MHonArc 2.6.24.

Top of Page