[egenix-users] ZmxODBC and DBFs

[Erik Myllymaki]

Figured it out; because the ODBC manager on WinXP doesn't allow you to 
type in a UNC path for the DBF directory, I had to set it up with a 
mapped drive letter, and then use regedit to change the mapped drive 
letter to UNC.

Works fine now.



Erik Myllymaki wrote:
> 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"
>>
> 
> 
> _______________________________________________________________________
> eGenix.com User Mailing List                     http://www.egenix.com/
> http://lists.egenix.com/mailman/listinfo/egenix-users