connecting to remote server using sql server with vb 6.0

[baaba]

how can i connect an instance of sql server with remote server using visual basic 6.0.
example conecting to instance of sql server using one computer is :
inializing the connection
con.provider="sqloledb"
provstr="server myserver; Database = mydatabse trusted_connection=yes"

with one pc i connect using the Above code but remote server con't how i ???
ali ibrahim

[Phil Weber]

Take a look at the examples here: http://www.connectionstrings.com . If you're using ADO, you want the OLE DB examples.