[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
Good to hear that adodbapi is going to get some loving. Here's a brain dump on Unix + ODBC: There are a lot of commercial UNIX ODBC interfaces of varying quality out there; I'm not familiar with any of them. As usual with open source, there's not one but two options for free ODBC software, unixodbc (http://unixodbc.org) and iodbc (http://iodbc.org). I've used both, they both seem to work. For access to MS-SQL, they both depend on FreeTDS ( http://freetds.org) for basic TDS communcation needs (TDS=Tabular data stream: taken from Sybase). pyodbc uses an ODBC provider, both the free options above and most if not all of the commercial options should work. Here's the current options for MS-SQL access from SqlAlchemy: adodbi is Windows only, uses COM objects to communicate with MS's ADO access. pymssql is Windows/Unix (not sure about BSD/Mac), uses a very old TDS layer known as DB-lib, which you've heard me complaining about many times. I was using DB-lib to access MS-SQL from C programs back in the day. Rumour has it you've done the same, so you know DB-lib. pyodbc is Windows/Unix (again not sure about BSD/Mac), talks to an ODBC provider as outlined above. Right now, this is most likely the best supported way to access ODBC from Python. There is also the mxPython ODBC interface, does basically what pyodbc does, commercial with support. This is from the guy who wrote mxDate, which was *the* way to do dates before Python 2.3 introduced the datetime module. AFAIK, this would also depend on some ODBC provider on Unix like unixodbc/iodbc/some commercial stack. Rick On 5/1/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > > On May 1, 2007, at 4:17 PM, Rick Morrison wrote: > > > The 0.3.7 bug is my fault, I checked in the changes without testing > > on pyodbc. Didn't know that Mike would cut 0.3.7 the very next day! > > Guess I'll get to use that buildslave for something after all... > > > > Paul, I wasn't aware of scope_identity() not working on pyodbc, I > > checked it in because it was your patch and I know you work on > > pyodbc. It worked OK here with pymssql, so I let it go. Can you > > detail what the problem is with pyodbc? > > > > In the meantime, I'll make the @@IDENTITY version the default again > > until it's straightened out. > > > > Rick > > > > > > on a related note I was contacted by Vernon Cole who says he is > taking over maintenance of adodbapi, which is a good sign to have > direct access to a DBAPI maintainer. > > whats the current option to talk to MS-SQL via unix ? pymssql, or > pyodbc with a commercial ODBC library ? (are there free unix odbc > libraries ?) > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
On May 1, 2007, at 4:17 PM, Rick Morrison wrote: > The 0.3.7 bug is my fault, I checked in the changes without testing > on pyodbc. Didn't know that Mike would cut 0.3.7 the very next day! > Guess I'll get to use that buildslave for something after all... > > Paul, I wasn't aware of scope_identity() not working on pyodbc, I > checked it in because it was your patch and I know you work on > pyodbc. It worked OK here with pymssql, so I let it go. Can you > detail what the problem is with pyodbc? > > In the meantime, I'll make the @@IDENTITY version the default again > until it's straightened out. > > Rick > > on a related note I was contacted by Vernon Cole who says he is taking over maintenance of adodbapi, which is a good sign to have direct access to a DBAPI maintainer. whats the current option to talk to MS-SQL via unix ? pymssql, or pyodbc with a commercial ODBC library ? (are there free unix odbc libraries ?) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
The 0.3.7 bug is my fault, I checked in the changes without testing on pyodbc. Didn't know that Mike would cut 0.3.7 the very next day! Guess I'll get to use that buildslave for something after all... Paul, I wasn't aware of scope_identity() not working on pyodbc, I checked it in because it was your patch and I know you work on pyodbc. It worked OK here with pymssql, so I let it go. Can you detail what the problem is with pyodbc? In the meantime, I'll make the @@IDENTITY version the default again until it's straightened out. Rick On 5/1/07, Paul Johnston <[EMAIL PROTECTED]> wrote: > > > Hi, > > I've found SA/MSSQL is mostly stable now. I do have a few bugs > outstanding, and I'm sure I'll need to dive into the source code again > in the future, but it's comparably stable to the rest of SA. > > The unit test failures are right down, at least on Windows. I haven't > tested PyODBC on other platforms; we should do that ASAP (at least as a > one off exercise). I'm definitely in favor of a buildbot although I > can't easily offer hardware. > > Anyway, I'm sure you're dying to hear the outstanding problems! Well, in > my usual form of totally undecipherable notes for self, here they are: > > #538 - identity insert problems > label subqueries in from clause - unit test proposed in #513 triggers this > new unit test - len(unistr) == db.func.length(unistr) > date formatting - pass as datetime objects not strings > make MSNVarchar derive from Unicode > #537 - scope_identity(). This always returns NULL on PyODBC ticket open > on PyODBC tracker > > BTW, I'm a bit worried that 0.3.7 has a bug that means fetch IDs doesn't > work (except with PyMSSQL), but I haven't checked this. Hopefully we'll > get these little issues fixed, then from 0.3.8 SA will always ship with > all unit tests passing for MSSQL. Woo! :-) > > Paul > > > Rick Morrison wrote: > > > .3.6 was stable (at least for me). > > > > One of the issues to address is going to be the multi-DBAPI support. > > Keeping all three stable at the same time can be tough. So starting > > .3.7, making pyodbc the only supported configuration is OK with me, > > although I'll keep pymssql up and running for the next couple of > > releases, as we're using it here internally. Adodbapi is starting to > > look like a lost cause: emails are going unanswered and there's been > > no updates for quite some time. > > > > Speaking of testing, Paul has done a great job at bringing MSSQL up to > > speed on a lot of the tests, and I believe there's only like four > > tests that don't pass now, and I would wager those are because of > > database feature issues, not overt bugs. Maybe it's time to start > > putting MSSQL on the regular test rotation. > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
Hi, I've found SA/MSSQL is mostly stable now. I do have a few bugs outstanding, and I'm sure I'll need to dive into the source code again in the future, but it's comparably stable to the rest of SA. The unit test failures are right down, at least on Windows. I haven't tested PyODBC on other platforms; we should do that ASAP (at least as a one off exercise). I'm definitely in favor of a buildbot although I can't easily offer hardware. Anyway, I'm sure you're dying to hear the outstanding problems! Well, in my usual form of totally undecipherable notes for self, here they are: #538 - identity insert problems label subqueries in from clause - unit test proposed in #513 triggers this new unit test - len(unistr) == db.func.length(unistr) date formatting - pass as datetime objects not strings make MSNVarchar derive from Unicode #537 - scope_identity(). This always returns NULL on PyODBC ticket open on PyODBC tracker BTW, I'm a bit worried that 0.3.7 has a bug that means fetch IDs doesn't work (except with PyMSSQL), but I haven't checked this. Hopefully we'll get these little issues fixed, then from 0.3.8 SA will always ship with all unit tests passing for MSSQL. Woo! :-) Paul Rick Morrison wrote: > .3.6 was stable (at least for me). > > One of the issues to address is going to be the multi-DBAPI support. > Keeping all three stable at the same time can be tough. So starting > .3.7, making pyodbc the only supported configuration is OK with me, > although I'll keep pymssql up and running for the next couple of > releases, as we're using it here internally. Adodbapi is starting to > look like a lost cause: emails are going unanswered and there's been > no updates for quite some time. > > Speaking of testing, Paul has done a great job at bringing MSSQL up to > speed on a lot of the tests, and I believe there's only like four > tests that don't pass now, and I would wager those are because of > database feature issues, not overt bugs. Maybe it's time to start > putting MSSQL on the regular test rotation. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
I'd be happy to host a buildslave here on a VM. AFAIK, the buildslaves connect outbound to the master, which would work for me. As far as hosting the master, I dunno -- we're out here in the hinterlands of Connecticut in dynamic IP address land for now. On 4/27/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > > On Apr 26, 2007, at 6:31 PM, Rick Morrison wrote: > > > Sounds like a great idea -- is there an existing buildbot master to > > tie into, or will the whole thing be new? > > > > well my limited understanding of buildbots says that we would need to > make one that responds to SQLAlchemy version changes, since the > "main" one at pybots.org responds only to Python builds ? also it > requires a persistent running service that is always connected to the > master (which i feel is overkill), but we'd have to determine hosting > for the whole thing. > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
On Apr 26, 2007, at 6:31 PM, Rick Morrison wrote: > Sounds like a great idea -- is there an existing buildbot master to > tie into, or will the whole thing be new? > well my limited understanding of buildbots says that we would need to make one that responds to SQLAlchemy version changes, since the "main" one at pybots.org responds only to Python builds ? also it requires a persistent running service that is always connected to the master (which i feel is overkill), but we'd have to determine hosting for the whole thing. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
It may not be as horrible as you think. All of the various database dialects in SA inherit from a common ancestor which performs most of the heavy lifting to support most ANSI SQL features. Assuming that your SQL layer is simple (and a layer over an ISAM architecture is likely to have simple SQL), the ANSI subset may already provide most of what you need. Take the ODBC connect code from the MSSQL module, a basic do-nothing ANSI wrapper, and you may be substantially there already On 4/27/07, Durumdara <[EMAIL PROTECTED]> wrote: > > Hi! > > 2007/4/26, Paul Johnston <[EMAIL PROTECTED]>: > > > > > > Hi, > > > > I'm not familiar with DBISAM, I take it this is another database engine? > > (i.e. a "sister" to MySQL, PostgreSQL, etc.) > > > DBISAM is completely another db engine, but it have ODBC driver to use it > in out-of-Delphi applications. > > As it stands, SQLAlchemy needs to have support specifically coded for > > each database. The MS-SQL support does use PyODBC, but as Rick pointed > > out, that doesn't help with other databases. > > > Grr > :-( > > So now I need to choose: > > 1.) I use DBAPI2 as before... > 2.) I write a SQLObject class... > 3.) I write a SQLAlch class... > > :-((( > > dd > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
Hi! 2007/4/26, Paul Johnston <[EMAIL PROTECTED]>: > > > Hi, > > I'm not familiar with DBISAM, I take it this is another database engine? > (i.e. a "sister" to MySQL, PostgreSQL, etc.) DBISAM is completely another db engine, but it have ODBC driver to use it in out-of-Delphi applications. As it stands, SQLAlchemy needs to have support specifically coded for > each database. The MS-SQL support does use PyODBC, but as Rick pointed > out, that doesn't help with other databases. Grr :-( So now I need to choose: 1.) I use DBAPI2 as before... 2.) I write a SQLObject class... 3.) I write a SQLAlch class... :-((( dd --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
Sounds like a great idea -- is there an existing buildbot master to tie into, or will the whole thing be new? On 4/26/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > > On Apr 26, 2007, at 6:15 PM, Rick Morrison wrote: > > > .3.6 was stable (at least for me). > > > > One of the issues to address is going to be the multi-DBAPI > > support. Keeping all three stable at the same time can be tough. So > > starting .3.7, making pyodbc the only supported configuration is OK > > with me, although I'll keep pymssql up and running for the next > > couple of releases, as we're using it here internally. Adodbapi is > > starting to look like a lost cause: emails are going unanswered and > > there's been no updates for quite some time. > > > > Speaking of testing, Paul has done a great job at bringing MSSQL up > > to speed on a lot of the tests, and I believe there's only like > > four tests that don't pass now, and I would wager those are because > > of database feature issues, not overt bugs. Maybe it's time to > > start putting MSSQL on the regular test rotation. > > OK...do we want to create a buildbot of some kind ? we should > probably get something going for oracle as well. > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
On Apr 26, 2007, at 6:15 PM, Rick Morrison wrote: > .3.6 was stable (at least for me). > > One of the issues to address is going to be the multi-DBAPI > support. Keeping all three stable at the same time can be tough. So > starting .3.7, making pyodbc the only supported configuration is OK > with me, although I'll keep pymssql up and running for the next > couple of releases, as we're using it here internally. Adodbapi is > starting to look like a lost cause: emails are going unanswered and > there's been no updates for quite some time. > > Speaking of testing, Paul has done a great job at bringing MSSQL up > to speed on a lot of the tests, and I believe there's only like > four tests that don't pass now, and I would wager those are because > of database feature issues, not overt bugs. Maybe it's time to > start putting MSSQL on the regular test rotation. OK...do we want to create a buildbot of some kind ? we should probably get something going for oracle as well. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
.3.6 was stable (at least for me). One of the issues to address is going to be the multi-DBAPI support. Keeping all three stable at the same time can be tough. So starting .3.7, making pyodbc the only supported configuration is OK with me, although I'll keep pymssql up and running for the next couple of releases, as we're using it here internally. Adodbapi is starting to look like a lost cause: emails are going unanswered and there's been no updates for quite some time. Speaking of testing, Paul has done a great job at bringing MSSQL up to speed on a lot of the tests, and I believe there's only like four tests that don't pass now, and I would wager those are because of database feature issues, not overt bugs. Maybe it's time to start putting MSSQL on the regular test rotation. On 4/26/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > On Apr 26, 2007, at 5:53 PM, Rick Morrison wrote: > > > Hey Mike, I think it may also be time to lift the "experimental" > > label from the MS-SQL module, waddyasay?. > > yeah thats no prob, seems like only the current trunk has a stable > version tho ? > > > > > It may not be a 100% first-class SA citizen yet, but I think it's > > damn close. If it will help with support, I'll donate a configured > > VM with an installed version of MSSQL 2005 along with a real live > > holographic whiz-bang M$ license and everything. > > of all the DB's it definitely gets the most external support. I do > have MSSQL 2005 running on a windows box here its just not in my > normal course of testing procedures (largely because you guys are > doing all the work testing anyway). > > > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
On Apr 26, 2007, at 5:53 PM, Rick Morrison wrote: > Hey Mike, I think it may also be time to lift the "experimental" > label from the MS-SQL module, waddyasay?. yeah thats no prob, seems like only the current trunk has a stable version tho ? > > It may not be a 100% first-class SA citizen yet, but I think it's > damn close. If it will help with support, I'll donate a configured > VM with an installed version of MSSQL 2005 along with a real live > holographic whiz-bang M$ license and everything. of all the DB's it definitely gets the most external support. I do have MSSQL 2005 running on a windows box here its just not in my normal course of testing procedures (largely because you guys are doing all the work testing anyway). --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
Hey Mike, I think it may also be time to lift the "experimental" label from
the MS-SQL module, waddyasay?.
It may not be a 100% first-class SA citizen yet, but I think it's damn
close. If it will help with support, I'll donate a configured VM with an
installed version of MSSQL 2005 along with a real live holographic whiz-bang
M$ license and everything.
Rick
On 4/26/07, Rick Morrison <[EMAIL PROTECTED]> wrote:
>
> I'm not sure this is going to work: Just because you can access a database
> via ODBC doesn't mean it's magically going to speak a particular dialect of
> SQL.
>
> ODBC abstracts database connection mechanisms, preparing and executing
> statements, binding parameters and other "middleware"-oriented tasks, but it
> does not provide an SQL esperanto.
> (SA itself is one of the few tools that does a credible job of that)
>
> What SA's
> pyodbc+MS-SQL module does is allow one to use *MS-SQL* via ODBC, not any
> database capable of communicating over ODBC. Were
> there such a thing, a sufficiently MS-SQL like database would work, but all
> the MS-SQL'isms that the SA MSSQL module provides are for the benefit of
> MS-SQL, not ODBC.
>
>
>
> On 4/26/07, Michael Bayer < [EMAIL PROTECTED]> wrote:
> >
> >
> > On Apr 26, 2007, at 9:35 AM, Durumdara wrote:
> >
> > Hi!
> >
> > 2007/4/26, Michael Bayer < [EMAIL PROTECTED]>:
> > >
> > >
> > > mssql:// supports pyodbc.
> >
> >
> > And how to I open the engine? (XXX is the name of the ODBC DataSource
> > what I want to open. It is DBISAM database).
> >
> > from sqlalchemy import *
> > import pyodbc
> > db = create_engine('mssql://zeusweb', module=pyodbc)
> >
> > The result is:
> >
> >
> > use the trunk first of all since MS-SQL support is largely experimental,
> > the "import" is already included in there so it should use pyodbc
> > automatically (you can add the argument 'module_name="pyodbc"` to
> > create_engine() to force it), and I dont know anything about pyodbc so the
> > function that breaks the URL into odbc, given a URL of the form:
> >
> > mssql://user:[EMAIL PROTECTED]/database
> >
> > is:
> >
> > def make_connect_string(self, keys):
> > connectors = ["Driver={SQL Server}"]
> > connectors.append("Server=%s" % keys.get("host"))
> > connectors.append("Database=%s" % keys.get("database"))
> > user = keys.get("user")
> > if user:
> > connectors.append("UID=%s" % user)
> > connectors.append("PWD=%s" % keys.get("password", ""))
> > else:
> > connectors.append ("TrustedConnection=Yes")
> >
> >
> >
> > > >
> >
>
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
Hi, I'm not familiar with DBISAM, I take it this is another database engine? (i.e. a "sister" to MySQL, PostgreSQL, etc.) As it stands, SQLAlchemy needs to have support specifically coded for each database. The MS-SQL support does use PyODBC, but as Rick pointed out, that doesn't help with other databases. In terms of coding up database support, making the basic functions work may be relatively easy, depending on how ANSI compliant DBISAM is. Still, I'm sure getting solid support will be a big job - I've put in loads of work making the MSSQL unit tests pass, and there are still issues. Regards, Paul durumdara wrote: >Hi! > >I want to subst. my modpy webframework to Pylons. >I want use ORM in DB handling. > >But we used DBISAM in our projects, and now we access tables via ODBC >and pyodbc. > >I don't see any odbc database engine in SQLAlch.'s webpage. > >So I want to ask that there is no way to use ODBC connection? >It is hard to code a new SQLA. db class? > >Thanks for your help: >dd > > >> > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
I'm not sure this is going to work: Just because you can access a database
via ODBC doesn't mean it's magically going to speak a particular dialect of
SQL.
ODBC abstracts database connection mechanisms, preparing and executing
statements, binding parameters and other "middleware"-oriented tasks,
but it does not provide an SQL esperanto.
(SA itself is one of the few tools that does a credible job of that)
What SA's
pyodbc+MS-SQL module does is allow one to use *MS-SQL* via ODBC, not
any database capable of communicating over ODBC. Were
there such a thing, a sufficiently MS-SQL like database would work, but all
the MS-SQL'isms that the SA MSSQL module provides are for the benefit of
MS-SQL, not ODBC.
On 4/26/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
> On Apr 26, 2007, at 9:35 AM, Durumdara wrote:
>
> Hi!
>
> 2007/4/26, Michael Bayer <[EMAIL PROTECTED]>:
> >
> >
> > mssql:// supports pyodbc.
>
>
> And how to I open the engine? (XXX is the name of the ODBC DataSource what
> I want to open. It is DBISAM database).
>
> from sqlalchemy import *
> import pyodbc
> db = create_engine('mssql://zeusweb', module=pyodbc)
>
> The result is:
>
>
> use the trunk first of all since MS-SQL support is largely experimental,
> the "import" is already included in there so it should use pyodbc
> automatically (you can add the argument 'module_name="pyodbc"` to
> create_engine() to force it), and I dont know anything about pyodbc so the
> function that breaks the URL into odbc, given a URL of the form:
>
> mssql://user:[EMAIL PROTECTED]/database
>
> is:
>
> def make_connect_string(self, keys):
> connectors = ["Driver={SQL Server}"]
> connectors.append("Server=%s" % keys.get("host"))
> connectors.append("Database=%s" % keys.get("database"))
> user = keys.get("user")
> if user:
> connectors.append("UID=%s" % user)
> connectors.append("PWD=%s" % keys.get("password", ""))
> else:
> connectors.append ("TrustedConnection=Yes")
>
>
>
> >
>
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
On Apr 26, 2007, at 9:35 AM, Durumdara wrote:
> Hi!
>
> 2007/4/26, Michael Bayer <[EMAIL PROTECTED]>:
>
> mssql:// supports pyodbc.
>
> And how to I open the engine? (XXX is the name of the ODBC
> DataSource what I want to open. It is DBISAM database).
>
> from sqlalchemy import *
> import pyodbc
> db = create_engine('mssql://zeusweb', module=pyodbc)
>
> The result is:
>
use the trunk first of all since MS-SQL support is largely
experimental, the "import" is already included in there so it should
use pyodbc automatically (you can add the argument
'module_name="pyodbc"` to create_engine() to force it), and I dont
know anything about pyodbc so the function that breaks the URL into
odbc, given a URL of the form:
mssql://user:[EMAIL PROTECTED]/database
is:
def make_connect_string(self, keys):
connectors = ["Driver={SQL Server}"]
connectors.append("Server=%s" % keys.get("host"))
connectors.append("Database=%s" % keys.get("database"))
user = keys.get("user")
if user:
connectors.append("UID=%s" % user)
connectors.append("PWD=%s" % keys.get("password", ""))
else:
connectors.append ("TrustedConnection=Yes")
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
Hi!
2007/4/26, Michael Bayer <[EMAIL PROTECTED]>:
>
>
> mssql:// supports pyodbc.
And how to I open the engine? (XXX is the name of the ODBC DataSource what I
want to open. It is DBISAM database).
from sqlalchemy import *
import pyodbc
db = create_engine('mssql://zeusweb', module=pyodbc)
The result is:
---
Error
---
AttributeError: 'MSSQLDialect' object has no attribute 'make_connect_string'
---
OK
---
Thanks for help!
dd
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(
mssql:// supports pyodbc. On Apr 26, 2007, at 5:35 AM, durumdara wrote: > > Hi! > > I want to subst. my modpy webframework to Pylons. > I want use ORM in DB handling. > > But we used DBISAM in our projects, and now we access tables via ODBC > and pyodbc. > > I don't see any odbc database engine in SQLAlch.'s webpage. > > So I want to ask that there is no way to use ODBC connection? > It is hard to code a new SQLA. db class? > > Thanks for your help: > dd > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
