Msde

hi


I need to do an application which can be link together. First of all, i upgraded the database from .mdb to .adp via 'upsizing wizard' in MS Access. And I already installed the MSSQLSERVER from the microsoft access CD-ROM.

On the VB.net side, i drag the sqlCommandDataAdapter, and i tried to use MSSQL data Engine instead of using JET data Engine. but connection didn't show the Server name and i cannot select the db1.adp file appropriately.

Can somebody tell me am i missing some important steps ?

Why the client couldn't connect to the host's sql server and with the error message "SQL server doesn't exist or Access denied"