Hi Kurt,
usually, when connecting DBs via ODBC you use a configured connect. As we are using Informix IDS there is always a spezial connect to the related DB. However, as the driver uses tcpip there are special entries withing c:\windows\system32\drivers\etc\services. Informix uses ports 1525/tcp and 1526/tcp. SQL Server will use 1433 tcp/udp and 1434 tcp/udp. Your firewall should accept the usage of those in case of DBs must be connected.
>Hi all,
>
>I have the next problem : i make a sql connection via the SQLSTRINGCONNECT() and that works fine. Now i have 2 xp home servicepack 3 machines where that doesn't work. Tested with odbc connection and found out that the only way to get a connection is to specify my port (1433) .
>
>is it possible to send with the SQLSTRINGCONNECT() command the port to use or is there any other way to solve this prob ?
>
>thnx
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