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

[Greg Brunet]

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};...'

-- 
Greg