2 DSN's using port 1433

[herrld]

I have two software applications. Both use ODBC datasources to connect to the SQLServer databases. Both are TRYING to use the default PORT 1433. Is it possible for this to work correctly, or do they have to have different ports!
Software vendors are NO help!

Thanks,


Linda

 

[mtscomasp]

That should work just fine. I suspect (but don't know for sure) that port 1433 is merely a listener port. When a client app connects, it goes to port 1433 which responds with "meet me on port XXXX". Since XXXX is different each time, many apps can all access the data source at the same time.

Mike

 

[herrld]

Thanks Mike.
That's good to know! I appreciate the help.


Linda