>>>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.