VB Forum / Database Access / November 2006

I have a new installation of SQL Server 2005 Express. It's set up with
a couple of small databases that are maintained and used by some
custom-written VB6 programs.

From the computer where the VB programs have been developed,
everything seems to work ok - the programs can access the databases
and extract and update data as needed.

But, when I compile the programs and install them on another computer,
they can't access the databases. When the program tries to connect, it
generates the error "SQL Server does not exist or access is denied".

I have verified that version 2.8 of MSADO is being used (I downloaded,
installed and used a verification tool from MS).

Things still work just fine from the development computer.

Anyone have any ideas as to what I need to look for here?

Thanks.