Solved

vb pro 2005 and sql server 2005 Express edition

Posted on 2006-11-02
9
202 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]
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 142

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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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 142

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 142

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 142

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 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