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

[M.-A. Lemburg]

M.-A. Lemburg wrote:
> 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).

... and this is a list of all the keywords you can use with
MS SQL Server in the connection string:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_d_4x4k.asp

-- 
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 ! ::::