freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Sebastien FLAESCH <sf AT 4js.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] SQL Server 2005 / 2008 support
- Date: Thu, 13 Dec 2007 18:34:51 +0100
Note I did the same process with 0.64 (stable release) without problems.
I am using --with-odbc-nodm because I don't want to use a driver manager.
Adding "/include" to the path does not help with 0.65 dev version.
Seb
Sebastien FLAESCH wrote:
Downloaded "current" version from this link:
ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/current/freetds-current.tgz
Then I ran:
./configure --prefix=/opt3/dbs/tds/0.65 --with-odbc-nodm=/opt3/dbs/uxo/3.0
(using ODBC headers from unixODBC).
But could not manage to compile the ODBC driver:
if gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -D_FREETDS_LIBRARY_SOURCE -DTDS_NO_DM -D_REENTRANT -D_THREAD_SAFE -DDEBUG=1 -Wall -Wstrict-prototypes -Wmissing-prototypes -Wno-long-long -pthread -g -O2 -Wdeclaration-after-statement -MT bsqlodbc.o -MD -MP -MF ".deps/bsqlodbc.Tpo" -c -o bsqlodbc.o bsqlodbc.c; \
then mv -f ".deps/bsqlodbc.Tpo" ".deps/bsqlodbc.Po"; else rm -f
".deps/bsqlodbc.Tpo"; exit 1; fi
bsqlodbc.c:49:17: sql.h: No such file or directory
Seb
Sebastien FLAESCH wrote:
Hi James and thank you for your comments/advices.
I understand this is a open source project, no problem.
I will try to get the latest dev version from the CVS repository.
As a side note I would suggest that someone adds from time to time a news
on the web site, last news is from April 2005. By the way the text of the
new shows 0.63, but the link to the ANNOUNCE has 0.64 in the text.
Best regards.
Seb
James K. Lowden wrote:
Sebastien FLAESCH wrote:_______________________________________________
My name is Sebastien FLAESCHGood morning, Sebastien. Pleased to make your acquaintance. Welcome to
the project.Understand we do not just write a light driver to let 4gl programmers doFreeTDS is used extensively in many production environments, be assured.
a few SELECT / INSERT / UPDATE / DELETE statements;
- Version is still alpha/beta (0.64) - when you compile FreeTDS you getThere is no plan. When and as we have time, we fix things and add things.
a debug version by default. - No scrollable cursors??? (this is very old
stuff - now?)
PLEASE: What are the plans?
You're welcome to join us. It's a volunteer project, and the best
contributions come from people who want the software to do something it
doesn't already do.- There is no official support for SQL Server 2005 / 2008 (only TDS 8.0)And guess what? There's no official support, full stop. Everything we
know about TDS 7.0 and up is inferred by reverse engineering the TDS
packets. (The only support we get from Microsoft is anti-support. We've
talked to them. They won't provide even documentation. The next time you
read about Microsoft's latest open source marketing blather initiative, do
please bear that simple fact in mind.)
To be clear, we're pretty current. TDS 8.0 *is* for 2005, and 2008 is
still in beta, please. Is there some protocol feature of SQL Server 2005
that you noticed is missing?You guys probably know about SQL Server's Native Client that ships withCf. http://blogs.msdn.com/dataaccess/archive/2005/04/26/412161.aspx
SQL Server 9 (2005). This one is supposed to replace the old ODBC driver
one day, from my understanding. Are they still using TDS with this
Native Client? => Is TDS going to die?
Every few years, Microsoft plops a New and Improved API out there for
everyone to ooh and ahh at. That lets them and their groupies declare
they've once again made the world safe for programming.
But TDS itself is a franchise. It's 20 years old. It works with probably
millions of clients and servers. It's very efficient, possibly the best
remote database protocol on the planet. (Yes, it has warts. Show me
software without warts and I'll show you a textbook.) How in the world --
and why? -- would Microsoft damage its advantage? It's one thing to say,
"Use .NET and be cool", and something else to say that old clients can't
connect to new servers or vice versa. Especially because *TDS* isn't a
feature most people even know about, and would be devilishly hard to
improve on.
As Acey J. Bunch says above,
"It is new in that this data access library did not exist prior to SQL
Server 2005, but rest assured that it is not some radical new design for
accessing data!"
I think we can say TDS is safe for another day.
Regarding the issues you raised. As you can tell from Frediano's response
(and I hope from the email archives) we take bug reports seriously. But
please remember we'll work with you, not for you. The more you do to
correct/isolate a problem, the sooner it will be fixed. Suggestions,
ordered by decreasing helpfulness:
1. Use the latest snapshot. That's where any fixes/additions will be
made. 2. Send a patch. 3. Add a unit test illustrating the problem. 4. Describe the problem in terms of the source code. "Function X on
lines Y-Z overwrites foo without adjusting the length in bar" can be a
good place to start. 5. Include a TDSDUMP trace. That shows us the packet sequence and
calling sequence.
Sebastien, I think this is the beginning of a beautiful friendship.
Regards,
--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-
[freetds] SQL Server 2005 / 2008 support,
Sebastien FLAESCH, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
ZIGLIO, Frediano, VF-IT, 12/13/2007
- [freetds] ODBC scrollable cursors in 0.65, Sebastien FLAESCH, 12/17/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
James K. Lowden, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
Sebastien FLAESCH, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
Sebastien FLAESCH, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
Sebastien FLAESCH, 12/13/2007
- Re: [freetds] SQL Server 2005 / 2008 support, Frediano Ziglio, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
Sebastien FLAESCH, 12/13/2007
- Re: [freetds] SQL Server 2005 / 2008 support, James K. Lowden, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
Sebastien FLAESCH, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
Reid, Roger L., 12/13/2007
- Re: [freetds] SQL Server 2005 / 2008 support, James K. Lowden, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
Sebastien FLAESCH, 12/13/2007
-
Re: [freetds] SQL Server 2005 / 2008 support,
ZIGLIO, Frediano, VF-IT, 12/13/2007
Archive powered by MHonArc 2.6.24.