Here's the code:
CREATE CONNECTION GenClientVFP;CONNSTRING "DSN=Visual FoxPro Database;UID=;PWD=;SourceDB=C:\TestData\myDBC.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
SQLSTRINGCONNECT("DSN=Visual FoxPro Database;UID=;PWD=;SourceDB=C:\TestData\myDBC.dbc") works beautifully, it's only when we run GenDBC that it fails during the remote views.
Right when it gets to Create Remote View.... I get an error 1526 - Connection Error. However, right before it executes that code we suspend and issue a Modify Connection from the command window and interactively "Verify" the connection and save it the remote view is created without a single problem.
I understand that we need to verify the connection before using it and we are indeed connecting thru SQLSTRINGCONNECT() (and it connects just fine). We don't understand why we need to interactively verify the connect in order to create remote views in the database. Let's just say this is something that absolutely needs to be done - is there a way to perform the interactive "Verify" programmatically?