[thelist] Connecting to remote daabase?

[Casey]

I'm doing some sub-contracting for a new client, and he gave me the following information on the database to which I need to connect:

      Database Name:            
     abc123
     
      SQL Login:
     abc456
     
      SQL Password:
     xxxxxx
     
      TCP/IP Server Name:
     fubar.url.com
     
      SQL Server Port:
     1433
     
      DSN on Web Server:
     abc789
     


I have no idea how to build a connection string to a remote database.... is this even possible?  any point in the right direction would be great.

Thanks!