On 2008-05-27 17:28, Michael Bayer wrote: > > On May 27, 2008, at 11:19 AM, Rick Morrison wrote: > >>> To be honest I thought this was how we were doing it, but >>> (incredulously) looking at the source I see theres a "dsn" keyword >>> argument in there ?!? > ... > What's the argument for "DSN" as the official keeper of the "host" > part as opposed to an actual "host" ? Would it be because in ODBC, > "DSN" is *supposed* to be the primary identifier for how to get to a > host ? That's a fairly strong argument for me.
Yes. DSNs refer to logical database connections in the ODBC manager configuration. They don't necessarily map to hosts on the network - indeed, it's well possible that the database runs on the same machine and you connect to it via shared memory or pipes. OTOH, it's also possible to have to connection setups for the same host, e.g. one setup as read-only connection and the other as read-write connection. > With the ADO module, there isnt a TCP host option, is my > recollection. The source seems to be sending <host> along to be > interpreted as "Data Source", so this appears to be consistent with > the "host=DSN" idea (and I believe this is the MS module I actually > played with on the occasion that I actually tried out the MS-SQL > dialect). > > We are at the 0.5 stage and I haven't yet put out an alpha, so we'd > make this switch right there, if we decide upon it. I don't see any > way to make this a graceful switch, except that we provide the > "server" keyword attribute in 0.4 so that people can migrate their > URLs to a forwards-compatible keyword-based format. -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Jul 23 2008) >>> Python/Zope Consulting and Support ... http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ :::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! :::: eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---