[DB-SIG] Re: DSNless connections (w/ mxODBC or others)

[M.-A. Lemburg]

Greg Brunet wrote:
> Found something that works - don't know how efficient it is!  This page:
> http://www.basic-ultradev.com/articles/dsnlesscoldfusion/index.asp gives
> examples for DSN-less connections to various data sources (in Cold
> Fusion - but it seems to work for me).  Anyway, this is what worked:
> 
> 
>>>>db = mx.ODBC.Windows.DriverConnect('Driver={SQL
> 
> Server};server=localhost;Database=VehSales;UID=myuser;PWD=mypwd;')
> 
> NOTE: there's a space in 'Driver={SQL Server};...'

Here's the official documentation for this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odch21dpr_3.asp

(scroll down to the comments section).

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source  (#1, Aug 18 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2003-08-12: Released eGenix mx Extensions for Python 2.3

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::