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...
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011