[egenix-users] ZmxODBC and DBFs

[Erik Myllymaki]

Thanks for this.

I made a file DSN entery in the ODBC manageer and it seems to work fine 
if my datasources are local (C: drive) but not if they are on a mapped 
drive.

Any ideas on that one?



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