[egenix-users] ZmxODBC and DBFs

[M.-A. Lemburg]

Erik Myllymaki wrote:
> Any tips on how to make a connection with an ODBC conneciton to DBF files?

On Windows, you'd simply create a data source for the .dbf file.
The MS MDAC package comes with ODBC drivers for .dbf files which
can be used for this. The package is usually installed as part
of MS Office, but also available separately from MS. I think that
Win XP ships with the package preinstalled.

It is also possible to create an ad-hoc connection using the
FILEDSN connection string attribute...

Connection parameters (DSNs):

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

     (scroll down to the comments section).

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

Example of a DSN-less connection string:

     "DRIVER={SQL Server};SERVER=hrserver;UID=Smith;PWD=Sesame"

Example of a File DSN strings:

     "FILEDSN=HR_FDSN;UID=Smith;PWD=Sesame"

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jan 06 2005)
 >>> 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,FreeBSD for free ! ::::