>>The windows firewalls are disabled on the both computers and on the other 2 (those that can connect) the firewall is enabled... so i don't think there is a firewall problem. We have writen the program so it makes a connection via SQLSTRINGCONNECT(). the connection string is in a init file so thats for every pc the same.
>>
>>I just did the test with the odbc connection to see where the prob could be. when i make a connection with dynamic ip via tcp/ip for those 2 pcs i can't make a connection on the other 2 it works fine. when i chose to make a conneciton via tcp/ip and specify the port (1433) i get an instand connection so i guess the problem with the SQLSTRINGCONNECT() must be the same as the problem with the odbc connection.
>>
>>So if possible i want to put the tcp port in my SQLSTRINGCONNECT() but i don't know if that is possible
>
>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.