>>>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 <g>) from a web Active Server Page page.
Supposedly you don't have to setup a DSN using a adoDB.Connection
in ASP.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only