On Wednesday 01 November 2006 08:20, Paul McNett wrote: > 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.
Why did you reject object-craft solution? Was it because it was not finished or some other reason? BTW I did not know about object-craft. My idea was to use the isql interfaces on both platforms. But for some reason the window side just fails. But the hacking on the Linux side is not a good solution either IMO. So I wrote an email to the guy who did the sybase interface for perl. I'm hoping he might provide some insights. I took a look at the psycopg (for postgres) 'c' code and it is very small. So the thinking is why not at least see what could be done with a 'c' interface. Granted it's been many years since I used 'c' but I have a son that programs in 'c' daily. John _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
