473,385 Members | 1,753 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,385 software developers and data experts.

2003 won't open stored procedures

We are converting our projects to VS 2003 Professional from VS 2003 and
found that we cannot open the Stored Procedures inside of the Projects.

We can see the SP and it shows the fields, but when you double-click it, it
doesn't open it so you can edit it.

Also, when you drag a SP (or table for that matter), it creates a new
SqlConnection object everytime - even when there is one or two on the page.
This forces us to delete the new one and manually edit the object. In 2002,
it would seemed to use the SqlConnection object at the bottom of the page,
if it could.

Thanks,

Tom
Jun 27 '06 #1
0 814

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

Similar topics

2
by: daniel d | last post by:
hi all, Im using VB 6.0 Pro, my DB is SQL server 2000 Eval edn. I am using stored procedures to get data from my DB. I am trying to open up a new recordset as a dynamic however it refuses to...
1
by: Matt Alanzo | last post by:
On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing...
8
by: lauren quantrell | last post by:
When I open an Access form I can have no recordset specified, then in the form's OnOpen event I can do something like: Me.paramaters = "@SomeColumn = 22)" Me.recordsource = "dbo.sproc123" But I...
0
by: JollyK | last post by:
Hello folks, Previously I have debugged stored procedures with VS.NET 2002 on Windows 2000 successfully. I know that in order to debug a stored procedure, I need to enable SQLServer debugging...
0
by: scott | last post by:
xp pro vs 2003 enterprise arch 2003 server with sql 2000 From xp pro and when using the to "step into stored procedure" option upon connection to a database in VS 2003 im getting the message: ...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
0
by: Marco | last post by:
Hello, I am trying to make a report with Crystal Reports that come with Visual Studio 2003 using a stored procedure, but i cannot get the stored procedures that are in my Sql Server or Oracle...
2
by: Andy | last post by:
Hi guys I having a problem creating a report in Access 2003 project talking to a SQL database through and ODBC connect. After hours of trying things from Access Help, MSDN and Google I still...
6
by: jsacrey | last post by:
Hello everybody, I've got a bit of a situation that I could use some guidance with if possible. I work for an auditing firm where my users audit electronic shipping data for customers to see if...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.