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, Lithuania 40 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 -~----------~----~----~----~------~----~------~--~---
