>>>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?
>>
>>I thought you were useing SQL Server. Sorry.
>>
>>I do not know Postgress so I cannot answe directly. All I could find for them is for .NET
>>http://www.carlprothman.net/Default.aspx?tabid=86#PostgreSQLDirectNETDataProvider
>>
>>For standard ODBC you are pretty much stuck that way. What you can do is not to keep the connection information in your program but externally in an XML or INI file, or even a DBF in encrypted form.
>>
>>You could decrypt the string at runtime just prior to use for connection.
>
>Alex, how I can use .NET data provider in VFP 7 ?
>Are you sure that it hides connection password ?As I said, I'm not familiar with Postgress. According to your message (and the connection sample provided in the link above), they don't offer Trusted Connections (i.e. Windows Autentication). So you cannot avoid including the password in the connection that I can see. Sorry.