472,348 Members | 1,236 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Visual Studio 2003 And SQL Server Express

1. I am using sql server express and visual studio 2003. I have been able
to create the connection to the database in server explorer but cannot update
table definitions. It gives an error that I may need a patch or changes
would not be saved. So I have to do the table changes in SQL Express
Management studio.

2. When I modify a stored procedure in the management studio of sql
express, it does not update but rather saves it the changes in a querry file.
But when I do it from visual studio 2003 server explorer and refreshes it
works.

3. I want to also use sql native client for my odbc configuration, no
problems?

The bottomline, I need help!!!!!!!
Nov 17 '05 #1
2 1926
Belee,

I think that by default, SQL Express only uses shared memory for
communications. I think that you have to go and enable the named pipes
option for the server in order for VS.NET 2003 to work.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Belee" <Be***@discussions.microsoft.com> wrote in message
news:4F**********************************@microsof t.com...
1. I am using sql server express and visual studio 2003. I have been
able
to create the connection to the database in server explorer but cannot
update
table definitions. It gives an error that I may need a patch or changes
would not be saved. So I have to do the table changes in SQL Express
Management studio.

2. When I modify a stored procedure in the management studio of sql
express, it does not update but rather saves it the changes in a querry
file.
But when I do it from visual studio 2003 server explorer and refreshes it
works.

3. I want to also use sql native client for my odbc configuration, no
problems?

The bottomline, I need help!!!!!!!

Nov 17 '05 #2
Hi Nicholas!
At the configuration option, both named pipes and tcpip is selected. The
following is the error message:

You have connected to a version of SQL Server later than SQL Server 2000.
The version of Visual Studio or Access that you are using was released before
the version of SQL Server to which you are connected. For this reason, you
might encounter problems.

Please check with Microsoft to see if there is a service pack that you
should apply to Visual Studio or Office in order to get support for the
version of SQL Server to which you are connected.

You can continue but any new object types might not be enumerated, and it
will not be possible to save any objects or database diagrams that you create
using the Visual Database Tools.

"Nicholas Paldino [.NET/C# MVP]" wrote:
Belee,

I think that by default, SQL Express only uses shared memory for
communications. I think that you have to go and enable the named pipes
option for the server in order for VS.NET 2003 to work.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Belee" <Be***@discussions.microsoft.com> wrote in message
news:4F**********************************@microsof t.com...
1. I am using sql server express and visual studio 2003. I have been
able
to create the connection to the database in server explorer but cannot
update
table definitions. It gives an error that I may need a patch or changes
would not be saved. So I have to do the table changes in SQL Express
Management studio.

2. When I modify a stored procedure in the management studio of sql
express, it does not update but rather saves it the changes in a querry
file.
But when I do it from visual studio 2003 server explorer and refreshes it
works.

3. I want to also use sql native client for my odbc configuration, no
problems?

The bottomline, I need help!!!!!!!


Nov 17 '05 #3

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

Similar topics

26
by: Bruno Jouhier [MVP] | last post by:
I'm currently experiencing a strange phenomenon: At my Office, Visual Studio takes a very long time to compile our solution (more than 1 minute...
5
by: Patrick Olurotimi Ige | last post by:
Hi, I have VStudio.Net 2003 installed but can i install Visual Web Developer also on the same PC. My current .Net Frameork version is 1.1. Will...
3
by: Thom Little | last post by:
I have ASP.NET websites deployed on a number of servers. Thee were developed with Visual Studio 2003. Is it true that Visual Studio 2005 only...
6
by: JonSteng | last post by:
..Net Visual Studio Professional 2003 Version 7.1.3088 ..Net Framework 1.1 SP1 Version 1.1.4322 IIS 5.1 Windows XP Professional SP2 Micron T3000...
2
by: Progman | last post by:
I have Visual Studio 2005 Standard edition. Is ti the same thing as the Express edition or Standard is more?
1
by: seacoff | last post by:
Hi I just installed Visual Studio 2005 90 day trial which comes with the sql server express database I want to run the sample application 2-2--5...
2
by: Hunk Gym | last post by:
VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition Good Day! Would be appreciate if there is solution for the following...
1
by: hunkgym | last post by:
Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and...
2
by: Santana | last post by:
Hello, when i try create ASP .NET project in Visual Studio .NET 2003 i can't create this project in locl hard drive(C), because when i select...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

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.