[sqlalchemy] Re: ODBC connection URI
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 -~--~~~~--~~--~--~---
[sqlalchemy] Re: ODBC connection URI
Marc - is it the case that mxODBC only accepts DSNs and not TCP hosts as an argument, but PyODBC accepts both ? On May 27, 2008, at 9:10 AM, M.-A. Lemburg wrote: On 2008-04-23 15:04, Michael Bayer wrote: On Apr 23, 2008, at 8:07 AM, M.-A. Lemburg wrote: The DSN style setup fits in nicely with the URI scheme... just use the host part of the URI as data source name - after all, the ODBC manager will connect to the data source and not the database itself. Setting up an ODBC driver via the existing GUI tools is a lot easier and less error prone than trying to figure out all the different options and trying to put them into your connection string. The direct approach should really only be the last resort for very special cases. Hi Marc - for those of us without access to ODBC toolsets, can you illustrate an example of how this URL would look ? Using DSN within the host section seems fine to me, as long as it can be disambiguated from other non-DSN tokens that might be present there (i.e., when using pyodbc or mxODBC, is a DSN the *only* kind of host identifier you'd ever use?) Yes. A typical ODBC connection string looks like this: DSN=data source name;UID=user name;PWD=password The DSN is then mapped to the configuration of the data source by the ODBC manager. The configuration includes all the other bits of information that may be needed to access a local or remote database. The URI would look like this: mssql://username:[EMAIL PROTECTED]/ PS: The Reply-To setting on this list is a bit confusing... -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, May 27 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/ 2008-07-07: EuroPython 2008, Vilnius, Lithuania40 days to go 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 -~--~~~~--~~--~--~---