Hi Dragan

<snip>
>>did you try the PORT-Parameter (This comes from foxite.com)
>>
>>SQLSTRINGCONNECT("Driver={PostgreSQL};Server=127.0.0.1;Port=5432;Database=zain;Uid=postgres;Pwd=Pubb@834f")
>
>I didn't know about this parameter, but I have a case where this works:
>
>...;server=192.168.1.202,1433;...
>
>For some reason, nothing else worked there (and I wasn't there to watch over the IT guy trying things out), but this did. My 0.02 of your currency of choice.

In case Foxite hadn't come up with the Port-option my first try would have been http-syntax, something like

...;server=192.168.1.202:1433;...

but never had I considered kommata. :-)

At this time, we still use System-DSNs configured via ODBC-Interface. However, after getting more and more trouble due to insufficent customer knowhow and steadily rising hardware and system complexity (CITRIX-TS, load balancing, seerver farms, a.s.o.), we are considering a change form SQLCONNECT to SQLSTRINGCONNECT just to make our supporters work and life a bit easier...