I've read a few posts here and I've got an issue I've seen reported previously where I believe you are unable to use a string which is greater than 254 characters in length with the command

lnHandle = SQLStringconnect(lcStringOver254Characters)

The issue I have right now is that users are able to configure their own DSN files in our software, by either using file DSN file or Machine DSN files. We store the information in a table to be used later; the SQL select (they can select only some of the fields from the data source, and also filter it) and also the connection string in a DBF.

I read about how the SQLExec can be split into nice chunks to allow that to work and got that working great, and also fixed numerous problems with embedded quotes, spaces in alias names etc, however if the connection string is over 254 characters (which it commonly can be if people use longer filenames and locations), I get the 'string too long to fit' error.

Am I able to use the TEXTMERGE workaround in this example? All I need is the handle of the connection and I'm away. I'm not sure on the options available to me. The design of the application is pretty much set in stone being a legacy system as this is an enhancement only. At the moment I'm having to warn that the DSN file information is too long, which looks pretty naff.

Any help, would be greatly appreciated, however small.