David,

I tried

SQLSETPROP( this.nConnHandle,"ConnectString", 'test')

but got error

Property value is out of bounds.

VFP help says that ConnectString is read-only.


>Andrus,
>
>I'm not at a place where I can try this, but after the connection is established can you wipe out the connection string via a SQLSETPROP without losing the connection?
>
>

>gnHandle = SQLStringConnect( ... )
>? SQLSetProp( gnHandle,"ConnectString", "can't look here now" )
>

>
>I'm not sure if a #define is going to work if you are letting them play in the report designer.
>
>>I'm connection to a Postgres 8 SQL server using ODBC drivers from Postgres distribution. This ODBC driver does not have Trusted_Connection parameter.
>>How to use trusted connection with Postgres ?
>>
>>I'm thinking about replacing SQLGETPROP or connectstring string literal inside vfp dlls with some other unquessable string . Will VFP work in this case?