>I need to be able to access some dBase IV files in VFP6 without user interaction. I need to programmatically make a connection. I tried sglstringconnect(), but that always brings up the dialog box. Does anyone know how I can programmatically make this happen.
You can use SQLCONNECT() or SQLSTRINGCONNECT(); in both cases, failing to specify the necessary details (like in the case of SQLSTRINGCONNECT, the connection string) the dialog box pops.
If you've already defined a DSN, SQLCONNECT() will allow you to specify the DSN name along with a userid and password if it's required. There have bene a number of discussions on creating a DSN programmatically in the past couple of months on UT, and you might want to check the FQ for examples.