SQLServer Projects

  • Thread starter Thread starter Jeff Block
  • Start date Start date
J

Jeff Block

I am running VB.Net Standard Edition - can't create a solution or project
(or anything else for that matter) that uses SQLServer, except for the
Desktop Edition. I get an error message stating as such (or Access).. can't
locate any easy to read charts on MSDN that would point me to the right
version to obtain.
 
* "Jeff Block said:
I am running VB.Net Standard Edition - can't create a solution or project
(or anything else for that matter) that uses SQLServer, except for the
Desktop Edition. I get an error message stating as such (or Access).. can't
locate any easy to read charts on MSDN that would point me to the right
version to obtain.
Click to expand...

You will need VS.NET Professional or better.

<http://msdn.microsoft.com/vstudio/howtobuy/choosing.aspx>
 
Hi Jeff,

I am always confused by this question.
And still I am not complete sure what I am writting below is true, so if I
make an error let someone corrects me?

However as far as my knowledge from the standard edition goes now.
- When you want to use the "designer" for making database things, you
need the Professional or more extended versions (most of the more
expirienced with VB.net never use that designer or only a very small parts
of it, to draw some extra things and than cut it out to paste it on another
place)

- If you want Access you have to use OleDB and for that you need Net 1.1
and for that VB.net 2003

I hope this makes it more clear.

Cor
 
Jeff:

Like Cor mentions, this is true Only if you want to use the visual tools.
Declare a Connection Dim cn as New
SqlConnection("YourconnectionStringhere"), call cn.Open and you'll be fine.
You can do whatever you want, you just can't use the visual tools (which can
be a bummer b/c the DataAdapter Configuration wizard is a real help.
Another thing....you can declare a connection, then select dynamic
properties and let it build the .config file for you (if it's all the same,
just use the key it suggests). once you fill in the connection string
value, you can reference this connection from everywhere within your project
which may make things easier.

HTH,

Bill
 
Back
Top