469,090 Members | 1,252 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

New db cant be found

We have a brand new sql 2k server. Its all up to date on service packs
(both win2k and SQL).

I went in to enterprise manager and added a new db. I can run sprocs
and raw sql against the new db just fine from Query Analyzer.

When I try to make a dts package that refers to my new db I get the
following error:

Error desription: deferred prepare could not be completed.
Could not locate entry in sysdatabases for database 'mydbname'. No
entry found with that name. Make sure that the name is entered
correctly.

OK, so I look in sysdatabases and see 'mydbname'. Just in case im an
idiot... I actually copied the db name from that table and paste it in
my dts window.

My dts package is using an "execute SQL task" to call a stored proc.

To be ecxact:
USE mydbname
GO
EXEC MyProc

When I click on the parse button, is when I get that error message.

I have deleted the db, restarted the server, and recreated the db with
a slightly different name. I can replace mydbname with pubs or
northwind and all is ok. It just doesnt like new db's.

Any help would be greatly appreciated.

Thanks,
Dave
Jul 20 '05 #1
1 2660
Hi

I am not sure why you need the USE statement if the associated connection is
already setting this as the database.

John

"Dave" <fu*****@yahoo.com> wrote in message
news:f5************************@posting.google.com ...
We have a brand new sql 2k server. Its all up to date on service packs
(both win2k and SQL).

I went in to enterprise manager and added a new db. I can run sprocs
and raw sql against the new db just fine from Query Analyzer.

When I try to make a dts package that refers to my new db I get the
following error:

Error desription: deferred prepare could not be completed.
Could not locate entry in sysdatabases for database 'mydbname'. No
entry found with that name. Make sure that the name is entered
correctly.

OK, so I look in sysdatabases and see 'mydbname'. Just in case im an
idiot... I actually copied the db name from that table and paste it in
my dts window.

My dts package is using an "execute SQL task" to call a stored proc.

To be ecxact:
USE mydbname
GO
EXEC MyProc

When I click on the parse button, is when I get that error message.

I have deleted the db, restarted the server, and recreated the db with
a slightly different name. I can replace mydbname with pubs or
northwind and all is ok. It just doesnt like new db's.

Any help would be greatly appreciated.

Thanks,
Dave

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Karl Hungus | last post: by
3 posts views Thread by arun.hallan | last post: by
2 posts views Thread by moondaddy | last post: by
4 posts views Thread by rez151 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.