Solved

vb pro 2005 and sql server 2005 Express edition

Posted on 2006-11-02
9
200 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
  • 5
  • 4
9 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
they are compatible.
0
 

Author Comment

by:zachvaldez
Comment Utility
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 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
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
 

Author Comment

by:zachvaldez
Comment Utility
that's what I want to know.
Can you create stored procedure and triggers with the express edition of sql?
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 142

Expert Comment

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

Author Comment

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

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
>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
Comment Utility
I heard about something like sql management.. that need to be installed--not sure?
0
 
LVL 142

Accepted Solution

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

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

728 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now