473,372 Members | 871 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

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 2758
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: JohnnySparkles | last post by:
Hi All, I'm working on an application which uses a dll for some of its classes. I build the application and the dll and it runs fine on any machine with Visual Studio .NET installed on it....
4
by: gregsands | last post by:
Hi I have read all (ok most) of the posts relating to "Call to undefined function mysql_connect()", read the manual on PHP.net and done eveything thats ive been asked to do but cant get PHP to...
0
by: Aaron | last post by:
Hi Guys, I have a dbase installed on a network where the clints have linked tables to the database on the server. I found that i had to make some minor changes to the tables on the server...
3
by: Karl Hungus | last post by:
A cs file I compiled into an assembly dll is in my bin directory. In the cs file I have a using statement for System.Xml I compiled it using this command: csc /out:XmlContent.dll /t:library...
5
by: Ouwet5775 | last post by:
Hello peeps. Well i have tried runing the folwoing program several times, and i cant figure out what i am doing wrong. The goal of this is to input values for an array, find the maximum and the...
3
by: arun.hallan | last post by:
Hi, I'm having problems with authentication. I have a set of users that are allowed to use a webpage. They are in domain A. My goal is to get the username of these users and then check them...
1
by: foocc | last post by:
Hi, im trying to convert data reports (.dsr) in vb6 to crystal reports in vb.net. However, I cant seems to find it in my Microsoft Visual Studio 2005 Tools for Office. I've tried going to...
2
by: moondaddy | last post by:
I had to repost this because I had to update and change my msdn alias. I will re-ask the question and clarify a few things that were not clear before. This code is all executed on my dev...
2
by: Sticksboy | last post by:
I keep getting this error message - Item cant be found in the collection corresponding to the requested name or ordinal I dont understand what it means to be honest. I am trying to get the code...
4
by: rez151 | last post by:
trying to create a tree of hash nodes, with each node having a max of 5 objects, and a maximum of 5 child nodes...we insert 6 sucesfully and "explode" to create 3 child nodes, but when it gets to 7...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.