>>Are you able to create a file DSN manually?
>
>Haven't tried that. I did create both a user DSN and a system DSN and both worked fine. I'm sure it's someting I'm leaving out or putting in incorrectly in the connection string.
Just a couple of SWAGs:
- what if you leave out the UID parameter altogether? If you leave it in, you might have to use something to show its value of "", maybe another CHR(0)
- I haven't used that call, are you sure CHR(0) is the delimiter? - it looks unusual to me.
- do you see any difference if you expand the variables into literals for your connection string variable assignment?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up