hey guyz am currently using VB6 client program with SQL Server backend database. I have SQL Server on the computer am using and not a network, at the moment the program is running fine.. am worried that i might need to specify the path to the server where SQL Server is when i get to deploy the programme which will need to run from a node in a network.

Another Question is how do i register a new server under SQL Server Group because everytime i try to register it gives me an error that the MELCDS01 - SQL Server doesn't or access denied.(ConnectionOpen(Connect())

Please guyz help especially with the second question..

LION OF JUDDAH!

__________________
LION OF JUDDAH!

You don't need to specify a path, you do need to specify the server name. In your case localhost should work fine.

Post your connection string and tell us whether you are using integrated security or mixed. You might also want to check out:
http://www.able-consulting.com/ADO_Conn.htm

regards
David Cameron