>>>>What is the proper syntax for prgrammically
>>>>setting up a DSN for FoxPro tables.
>
>>the full syntax is:
>>DECLARE INTEGER SQLConfigDataSource IN odbccp32.dll INTEGER, INTEGER,
>STRING, STRING
>>DO CASE
>>CASE LOWER( tcMode) = 'vfp'
>>lcType = 'Microsoft Visual FoxPro Driver'
>>lcODBC = 'DSN=' + tcDSN + CHR(0) + ;
>>'SourceDB=' + tcPath + tcDatabase + CHR(0) + ;
>>'SourceType=DBC' + CHR(0) + ;
>>'BackGroundFetch=No' + CHR(0) + ;
>>'Exclusive=No' + CHR(0) + ;
>>'SetNoCountOn=No' + CHR(0) + ;
>>'Description=' + tcDSN
>
>Ian,
>What is the variable "tcDSN" ... table description in DSN setup?
>
>Actually, just like an Access table, I am using this on the fly
>(will attempt to use it ) from a web Active Server Page page.
>Supposedly you don't have to setup a DSN using a adoDB.Connection
>in ASP.
Gene,
Its just the name of the data source as it appears in the ODBC control panel.
regards
Ian