Good afternoon every one,


I have created a MSDE database using MS
Access 2000. When prompted for the SQL Server that
I wished to use, I selected (local). I named my

database
and gave it a username only "sa".

I then created my visual basic application
using the following command to connect to my database:

OpenConnection.Open "Driver={SQL Server};" & _
"Server=(local);" & _
"Database=mydatabase;" & _
"Uid=sa;" & _
"Pwd="

I can connect without any problems to my
database through my VB 6.0 application (I have Windows

2000).
Now that my development is done, I am trying to package

my
software for release.

I am using InstallMaker version 8.14. In
the database settings I have checked to install MSDE
and MDAC 2.6. However, once the installation is done
on another machine (either Windows XP professional or
Windows 98) my application is unable to connect to the
database and I get the following error message:

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL

Server does not exist or access denied. - -2147467259

Would any one be able to tell me what is

missing
for my installation to be complete and successful? I
am thinking it is some thing I have not included in my
installation but I could be wrong. Any help would be
greatly appreciated.

Best Regards,
Mary