MSDE ? Anyone able to use this?

[MichaelRed]

Cross posted in MS Access - General Forum

I have Ms. Access 2K and need to move toward SQL Server. Ma. A, includes a "sample" of Northwind using MSDE, which I would like to at least be able to Start and run to assure that the MSDE connection can be made.

Oh ShhhhhhhhHHHHHHHHHHHHHHhhhhhhhhh ... oot

MDSE "Indtall" appears to work, and I have the SMSQL server Icon in the tray. Further - it comes up as stopped" when the system is re-booted, and changes to "Run" when I load the Northwinds project. BUTTTTTTTTTTTttttttttttt!

The db exercises the "whine and complain" option during start up. with the following info:



? ConnectStr
CurrentProject.OpenConnection
Provider=SQLOLEDB;Data Source=BRIAN;User ID=sa;Password=;Persist Security Info=TRUE;Initial Catalog=master

? srv.Name
(local)
? srv.Netname
BRIAN
? CStr(Err.Number) + " : " + Err.Description
-2147467259 : Automation error


"Brian" is the Machine name where MSDE is installed and it is the "(local)" machine where I am (attempting) to look into this.

If I follow the 'prompts', the process would like me to specify a (db) server - but the drop down list of available servers is empty. Beyond this, I'm not sure where to start.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[jjgraf]

If the drop down list is empty just type in the computer name. It is not uncommon for that list to appear empty. once you type in the name you should be able to connect if the SQL server is running.

I use MSDE as a test bed for my applcations with no problems to speak of