473,847 Members | 1,743 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL server 2005 Express - Vista - Invalid object name '#spdbdesc'

I'm running Vista Business edition on 2005 Virtual PC.
Installed SQL Server 2005 Express latest download, with instance of
MSSQLSERVER and service accounts running under "NT AUTHORITY\SYSTE M".
Mixed mode authentication specified and sa password specified.
Used server manager to create user login with sysadmin role.
Login using windows authentication.

Run my application and database is created and populated with default
records.

However, my application executes the stored procedure "sp_helpdb"
which fails with "Invalid object name '#spdbdesc'" error.

If I run a query in server manager to execute same procedure logged
in
as the same person it runs ok and returns a table of information.

All this was working ok on XP with MSDE2000A previously.

I'm programming in .NET C# CLR2.0, any body know what's going wrong?

Apr 2 '07 #1
3 7423
This question was also posted and answered in
microsoft.publi c.sqlserver.pro gramming. If you need to post the same
question to multiple groups, post the message once to all groups in order to
avoid duplication of effort.

However, my application executes the stored procedure "sp_helpdb"
which fails with "Invalid object name '#spdbdesc'" error.
Perhaps the application is retrieving result set meta-data with SET FMTONLY
ON. This will result in an error since the #spdbdesc temp table does not
exist when the proc is executed with SET FMTONLY ON.
I'm programming in .NET C# CLR2.0, any body know what's going wrong?
It's difficult to say without seeing your code. The snippet below works for
me with SQL Server Developer Edition under Vista. I would expect it to work
under SQL Express too.
DataTable dt = new DataTable();
SqlConnection connection =
new SqlConnection(" Data Source=(local); Integrated Security=SSPI") ;
SqlCommand command =
new SqlCommand("sp_ helpdb", connection);
command.Command Type = CommandType.Sto redProcedure;
SqlDataAdapter da = new SqlDataAdapter( command);
connection.Open ();
da.Fill(dt);
connection.Clos e();

--
Hope this helps.

Dan Guzman
SQL Server MVP

<ia************ @hotmail.co.ukw rote in message
news:11******** **************@ b75g2000hsg.goo glegroups.com.. .
I'm running Vista Business edition on 2005 Virtual PC.
Installed SQL Server 2005 Express latest download, with instance of
MSSQLSERVER and service accounts running under "NT AUTHORITY\SYSTE M".
Mixed mode authentication specified and sa password specified.
Used server manager to create user login with sysadmin role.
Login using windows authentication.

Run my application and database is created and populated with default
records.

However, my application executes the stored procedure "sp_helpdb"
which fails with "Invalid object name '#spdbdesc'" error.

If I run a query in server manager to execute same procedure logged
in
as the same person it runs ok and returns a table of information.

All this was working ok on XP with MSDE2000A previously.

I'm programming in .NET C# CLR2.0, any body know what's going wrong?
Apr 2 '07 #2
On 2 Apr, 13:39, "Dan Guzman" <guzma...@nospa m-online.sbcgloba l.net>
wrote:
This question was also posted and answered in
microsoft.publi c.sqlserver.pro gramming. If you need to post the same
question to multiple groups, post the message once to all groups in order to
avoid duplication of effort.
Snip
>
Dan Guzman
SQL Server MVP
Snip

Sorry for that, it's the first time I've posted in many years...

If I don't specify SET FMTONLY ON/OFF in my code is there a default
state that I can rely on?
Is it the same for all SQL implementations ?
If not, should I set it when opening the connection?

Many thanks

Ian
Apr 2 '07 #3
(ia************ @hotmail.co.uk) writes:
If I don't specify SET FMTONLY ON/OFF in my code is there a default
state that I can rely on?
SET FMTONLY ON is usually submitted behind the scenes. ADO Classic
is notorious for doing this without being asked. ADO .Net is far more
well-behaved. But if you use CommandBehaviou r.MetaDataOnly, there is a
SET FMTONLY sent to SQL Server.
Is it the same for all SQL implementations ?
It's the client API that gets the idea to issue SET FMTONLY ON, so the
version of SQL Server should not matter.

It could certainly help if you could post your code.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 2 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
17767
by: Amanda | last post by:
From a guy in Microsoft newsgroups: | In *comp.databases.ibm-db2* there are always IBM guys | from the Toronto labs on line.Post with the | -for the love of god please help- | line and I'm sure you'll get their attention. | Their usually very good:) So here's my transplanted post ==========================================
3
3169
by: Arpan | last post by:
I recently installed SQL Server 2005 (Management Studio Express) along with SQL Server 2005 Express (Configuration Manager) in my Win2K Pro m/c & use IIS 5.0 to run ASPX projects. I could add my database, named "MyDB", successfully. I am using the Windows Authentication mode to login to SQL Server. My server name is "AD\SQLEXPRESS" where "AD" is the name of my m/c. I could even establish a connection to the server & the database from...
2
6980
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of attending interviews. If you own a company best way to judge if the candidate is worth of it. http://www.questpond.com/InterviewRatingSheet.zip
2
2110
by: kress1963nov22 | last post by:
I recently purchased a good MS book ("Build a Web Site Now") by Jim Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on CD and also MS SQL Server 2005 Express Edition on the CD. A couple of questions for this newbie: Can MS SQL Server 2005 Express Edition be used in place of the older MSDE product for backend database work? I also have Visual Studio .NET (VB) 2003 (Standard Edition). How compatible are all these products...
3
7973
by: sgottenyc | last post by:
Hello, Has anyone had any success running SQL Server Express on Vista with Apache via PHP? My PHP works fine, Apache works fine, and SQL Server Express works fine in Management Studio, but I cannot connect via this call: $myServer = "servername"; $myUser = "username"; $myPass = "password"; $myDB = "myDB";
3
6450
by: Steve | last post by:
Hi All I downloaded Sql server 2005 express SP2 and attempted to modify the Bootstrapper package files as I did with SP1 When i try to install SQL server as part of my VS 2005 deployment app I get an error at the end of the SQL server install phase 'Invalid endpoint'. (Note SQL server express gets installed OK) If I run SQL server express SP2 setup directly it I don't get the error
4
2356
by: Preben Zacho | last post by:
Hi there The scenario I got is this: I have created a Windows application in VS and I want to deploy it to another machine running Windows Vista. Since I have no control over this other machine, I've set it up to run SQL Authentication and I have added a new user called "MyUser" and applied a password. This user/password is used in my connection string whick looks like this: Server=.\SQLEXPRESS;Database=MyDB;User...
2
2393
by: egress | last post by:
I've created an SQL Server Express database with one table that I use in my test envionement (Windows Vista). I'm developing an ASP.NET web app with VS 2005 and try to connect to the express server to retrieve some simple data (no not Membership data). My connection string is: <connectionStrings> <add name="MyTestDb" connectionString="Data Source=. \SQLExpress;Integrated DataDirectory|MyData.mdf;User Instance=true;"...
0
9886
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10983
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10706
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9482
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7882
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5719
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5911
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4528
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3164
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.