>Hi thanks for your response. Can you explain a little more about how ODBC connects and about this custom port. you can also direct me to the source of information if you prefer.
>
>Thanks a lot.

Different drivers require different ports. I believe that SQL Server's default is 1433.

Check the SQL Server books online for details about how to set up TCP/IP access.