Ed Leafe wrote:
On Nov 1, 2006, at 10:38 AM, johnf wrote:
From Linux I can get isql to work. I install unixODBC, FreeTDS and I
sort of
can hack sql statements and get it to work. But I can't get it to
work under
windows and I have no idea about what to do for the MAC.
Windows will require a separate implementation, probably using ADO
or the .Net provider. You will probably have to talk with someone with
more Python/MSSQL/Windows experience for details.
Whatever works on Linux should work on the Mac, since their both
POSIX systems.
Have we looked at, and rejected:
http://www.object-craft.com.au/projects/mssql/
So I'm wondering has anyone looked at using SWIG to build a wrapper for
FreeTDS code. Or does someone else have any thoughts on how to do this?
I don't think that that's the way to go. It looks like there will
have to be something like this:
if self.Application.Platform == "Win":
[connect using some Windows-specific solution]
else:
[connect using FreeTDS]
If the *nix solution involves unixODBC and the FreeTDS driver, it seems
that the Windows solution would involve Microsoft ODBC and the official
Microsoft SQL Server ODBC driver. No?
I believe if I can get this done it will increase dabo's user base.
Most of
my programming friends have never heard of Postgres or sqlite. But
they know
MsSQL and have heard of MySQL. So if I can add MsSQL as a supported DB
engine it might help dabo up the food chain.
This would be a huge advantage, IMO. Our biggest potential target
audience is the people who are doing Microsoft desktop app development
today, and most of those people have most of their experience with
Microsoft SQL Server.
Yep, it would be huge.
--
pkm ~ http://paulmcnett.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev