SqlINI ?

[peraudun]

Hi
I want to place sql.ini at users APPDATA directory.
Set sGAppData = VisDosGetEnvString( 'APPDATA' )
Set SqlINI = sGAppData || '\\sql.ini'

This is done before connection.
But I got error message : SQL.INI File Error
WIN32CLIENT :
WIN32CLIENT : No configuration file.

[Jeff Luther]

I suggest you leave SQL.INI right where it got installed when you installed TD. Users don't need to know about SQL.INI -- they won't be changing settings, that's your job and the admin's job when you set up your client/server application + DB. That file is 'internal' to TD and SQLBase and router settings for that only.

If you need your users to have an INI file that you and they can use and modify, create your own and use the SalGet/SetProfileXXX functions for managing it, getting values out of it, writing to it from your TD app, etc. See TD help for more details on those functions, like SalGetProfileString().

[peraudun]

That wont help us, because we need to update SQL.INI between releases.
I will try with keeping sql.ini where it is installed and set ie

Set SqlINI = sGAppData || '\\localsql.ini'

And see if that helps.

Regards
Per Audun