Skip to Content.
Sympa Menu

freetds - Re: [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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Fwd: Re: Help connecting with tds to MSSQL 2008 - problem found
  • Date: Tue, 21 Sep 2010 15:30:47 +0200

We don't use raw sockets, only ip ones (udp/tcp).

freddy77

2010/9/21 Gal Rubinstein <galrub AT gmail.com>

> 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><
> 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/><
> 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<Panos%2520Stavroulis%2520%253cpstavroulis 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<Gal%2520Rubinstein%2520%253cgalrub 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 <Cc%3Afreetds 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 <Cc%3Afreetds 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 <To%3Afreetds 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
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page