Anyone connecting Access to MSDE or SQL Server 2000?

[Rob]

I'm trying to use the NorthwindCS.adp. If I menu File!Connection..., I can
only sign on as (local) using NT credentials in order to see that
"Connection Succeeded." If I try to connect using the machine name
ROBERT-0AX0AGG0 the connection will fail. If I try to log in as sa, the
connection will fail. Access won't recognize that SQL Server exists. Bear
in mind please that this is all on one common machine, and the running
instance is right there in the tray.

None of my Stored Procedures as labelled within Access 2000 are able to
connect up with a SQL Server instance. If I try to create a <New> Stored
Procedure, I get this dialog:

---
_Microsoft Access_

[!]

Microsoft Access can't find the object 'Microsoft Access can't find the
object 'StoredProcedure1.'.'

* You misspelled the object name. Check for missing underscores (_) or
other punctuation, and make sure you didn't enter leading spaces.
* You tried to open a linked table, but the file containing the table isn't
on the path you specified. Use the Linked Table Manager to update the link
and point to the correct path.

<OK>
---


(It really is written verbatim just like that: "Microsoft Access can't find
the object 'Microsoft Access can't find the object 'StoredProcedure1.'.'")

If I launch Access at any time, and then open NorthwindCS.adp, I get:

---
_Install Database_

[?]

Connected to SQL Server on : (local)

Would you like to install the sample database?

This may take a few minutes.

<Yes> <No>
---


I go ahead and press <Yes>, and this is its reply:

---
_Microsoft Access_

Item cannot be found in the collection corresponding to the requested name
or ordinal.

<OK>
---


Well, I press <OK>, and then this appears onscreen:

---
_Microsoft Access_

The database NorthwindCS does not exist. Use sp_helpdb to show available
databases.

<OK>
---

If I go to the command line and enter

1> sp_helpdb
2> go

then a bunch of lines scroll rapidly down the screen at a velocity that
can't
be read, and the scrolling stops with about 4 lines that give basic status
information on the running instance of MSDE:

sa

Sep 29 2003
Status=ONLINE, Updateability=READ_WRITE,

[...etc.]

I'm using Access 2000, the latest release of MSDE, and Windows 2000.

Help. Thanks.

(Is anyone even reading this?)

 

[Daran Johnson]

Rob,

Try something simple: Create an ADP file and on the connection screen use
(local), use windows authentication, and check the list of databases. There
should be at least four: MSDB, Master, TEMPDB, and Model. In addition there
should be one or two more: Pubs and Northwind. Select Northwind. Press the
test button. If it exclaims success then you have successfully connected to
SQL Server. You should then be able to see all the tables, views, and
stored procedures for the Northwind database. From there you can play
around and get familiar with the different aspects of using an ADP with SQL
Server.

-Daran

I'm trying to use the NorthwindCS.adp. If I menu File!Connection..., I can
only sign on as (local) using NT credentials in order to see that
"Connection Succeeded." If I try to connect using the machine name
ROBERT-0AX0AGG0 the connection will fail. If I try to log in as sa, the
connection will fail. Access won't recognize that SQL Server exists. Bear
in mind please that this is all on one common machine, and the running
instance is right there in the tray.

None of my Stored Procedures as labelled within Access 2000 are able to
connect up with a SQL Server instance. If I try to create a <New> Stored
Procedure, I get this dialog:

---
_Microsoft Access_

[!]

Microsoft Access can't find the object 'Microsoft Access can't find the
object 'StoredProcedure1.'.'

* You misspelled the object name. Check for missing underscores (_) or
other punctuation, and make sure you didn't enter leading spaces.
* You tried to open a linked table, but the file containing the table isn't
on the path you specified. Use the Linked Table Manager to update the link
and point to the correct path.

<OK>
---


(It really is written verbatim just like that: "Microsoft Access can't find
the object 'Microsoft Access can't find the object 'StoredProcedure1.'.'")

If I launch Access at any time, and then open NorthwindCS.adp, I get:

---
_Install Database_

[?]

Connected to SQL Server on : (local)

Would you like to install the sample database?

This may take a few minutes.

<Yes> <No>
---


I go ahead and press <Yes>, and this is its reply:

---
_Microsoft Access_

Item cannot be found in the collection corresponding to the requested name
or ordinal.

<OK>
---


Well, I press <OK>, and then this appears onscreen:

---
_Microsoft Access_

The database NorthwindCS does not exist. Use sp_helpdb to show available
databases.

<OK>
---

If I go to the command line and enter

1> sp_helpdb
2> go

then a bunch of lines scroll rapidly down the screen at a velocity that
can't
be read, and the scrolling stops with about 4 lines that give basic status
information on the running instance of MSDE:

sa

Sep 29 2003
Status=ONLINE, Updateability=READ_WRITE,

[...etc.]

I'm using Access 2000, the latest release of MSDE, and Windows 2000.

Help. Thanks.

(Is anyone even reading this?)