Yes DDL statements work. However I hope I haven't miss led you. I have NOT
used isql or osql from dabo (at least not yet). But I do think they could
work. I'd check this out immediately but I am in the process of converting
all my servers to run under VMware. BTW that is working - it's cool. I have
SUSE 10.1 running VMWare with window2003 server as a guest host and XP too.
Sound works, internet works, FoxPro 7,8 and 9 work, Video is 1600x1200 for
all the systems. Lots I haven't attempted yet. Also I lost my SQL 2000
install disks and have to wait for them to show up. So I have not tried isql
or osql from python yet. I will be accessing MsSQL 2000 via the web first.
I got CherryPy to work and will be checking out Plone soon. I also was able
to get the Mod-python (cgi) module to work using Apache of course. Since my
project is simple I might just stay with Mod-python.
John
On Wednesday 13 September 2006 23:35, Glenn Davy wrote:
> wow - seems quite doable and exciting - I always got the vibe it was to
> flakey to bother with - If it works with odbc, it can work without it
> too.
> Do you know if you're able to use DDL statements to create tables,
> views, functions etc?
> More importantly have you ever found a way to 'reverse engineer' the
> table/definitions etc - If you're using sqldmo (which is one of the most
> exasperating and infurating object models ive had to work with) you can
> execute a 'generateScript' method on any given object - for dabo
> purposes generating biz objects this would be needed. its possible to
> query the sysobjects (irc) table as 1 possiblity. Are there any others,
> intrinsic to freeDTS? Does an odbc layer provide anything to simplify
> this process?
>
> glenn
>
> On Wed, 2006-09-13 at 23:22 -0700, johnf wrote:
> > On Wednesday 13 September 2006 21:52, Glenn Davy wrote:
> > > does anyone know off hand, or from personal experience what the
> > > limitations of a FreeDTS solution are in terms of dealing with
> > > mssql2000 and/or 2005? (this seems to be FreeDTS based) I seem to
> > > remember Ed mentioned he started down this track, but had to abort due
> > > to time constraints.
> > >
> > > on native windows you can lever sqldmo and oledb,adodb and all that
> > > other msdac stuff inside python, but till they release it natively for
> > > *ix (insert refs to pigs flying, hell freezing over etc) - I think the
> > > legacy of its sybase origins (using FreeDTS) is all there is - so that
> > > sets a ceiling on what can be done - anyone know what that ceiling is?
> > >
> > > glenn
> >
> > I have setup access to MsSQL using SUSE 10.0, unixODBC, freeTDS. I have
> > used very complex select statements without issue using python. But make
> > sure you are using the latest version for everything. I read an old post
> > where there was some issue with a older version. I haven't tried
> > accessing or writing a text/blob field yet.
> >
> > Currently I have used cherrypy web server to pass the data - see example
> > code below.
> >
> > I have been thinking it might be possible to use isql (Linux) and osql
> > (windows) to pass statements. On the surface it looks possible to have
> > one base of code to access MsSQL from Linux and windows. I have no idea
> > about MAC's.
> >
> > import cherrypy
> > import mx.ODBC.unixODBC
> >
> >
> > # Note: only recent versions of CherryPy take "thread_index". For older
> > versions,
> > # you might have to do:
> > # def connect():
> > def connect(thread_index):
> > # Create a connection and store it in the current thread
> > cherrypy.thread_data.db =
> > mx.ODBC.unixODBC.DriverConnect('DSN=mssql;UID=vamlogin;PWD=go')
> >
> > # Tell CherryPy to call "connect" for each thread, when it starts up
> > cherrypy.server.on_start_thread_list.append(connect)
> >
> >
> > class Root:
> > def doLogin(self, username=None, password=None):
> > # check the username & password
> > cur = cherrypy.thread_data.db.cursor()
> > cur.execute('select ccustno from arcust where ccustno =
> > ?',(username,))
> > row = cur.fetchone()
> > cur.close
> >
> > John
> >
> > _______________________________________________
> > Post Messages to: [email protected]
> > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
>
> _______________________________________________
> Post Messages to: [email protected]
> Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
