Solved

vb pro 2005 and sql server 2005 Express edition

Posted on 2006-11-02
9
206 Views
Last Modified: 2010-04-24
Are these compatible? I know that there is vb 2005 express edition, however I would like to find out of potential issues.
Would there be any problem if your database is a sql server express edition and your development tool is the vb pro 2005 (not vb 2005 express edtion)?
0
Comment
Question by:zachvaldez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17859922
they are compatible.
0
 

Author Comment

by:zachvaldez
ID: 17860095
what are the limitations as far as programming ? ADO.net,AsP.net-there would not be any issues I assume?
How about connecting issues?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17861523
you will have the limits of the SQL Express edition, but as far as development is concerned, you should not hit those limits, at least you should know them all.
there is no limit in ado.net or asp.net to connect to the full blown or the limited edition of sql server 2005
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:zachvaldez
ID: 17862830
that's what I want to know.
Can you create stored procedure and triggers with the express edition of sql?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17864340
>can you create stored procedure and triggers with the express edition of sql?
yes.
0
 

Author Comment

by:zachvaldez
ID: 17866431
After installing the SQl Server express edition , are there any tool that need to be installed to the machine?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17866480
>After installing the SQl Server express edition , are there any tool that need to be installed to the machine?
well, anything YOU need/want to.
0
 

Author Comment

by:zachvaldez
ID: 17866535
I heard about something like sql management.. that need to be installed--not sure?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 17866739
the sql management tools come usually with sql express edition.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question