Data Connection

[odmonk]

Tia,

OK, guys. Im ready to make the switch to VB.NET. I go to BestBuy and buy myself a copy of VB.NET (standard). I read the book, I install the software, Im following the walkthrough for connecting to SQL Server, I am making the connection to DQL Server, I test the connection (it succeeds), I click OK, and I get a nastygram that says "It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access Databases with this version of Visual Studio"

If this is truly the case, why did I spend the money?

 

[Derek Stone]

Thats just one of the limitations of the Standard Edition. Youll need to purchase the Professional Edition or Architect Edition.

 

[odmonk]

Can I get an upgrade or did I just waste $100?

 

[Thinker]

Good question. I suggest you look it up on the MS web site. If
the standard edition can be upgraded, it will tell you there. But
if you find that it can, try searching the web for a dealer that sells
the upgrade because the prices quoted on the MS site are usually
higher than a dealer sells them for.

 

[anthony]

Was the database you tried connecting to on your computer
or on a remote computer? Perhaps you could first try setting
up the connection in code.
All I know is the server explorer on the standard edition
has data connection nodes but doesnt have server nodes.
I can connect locally but as far as a remote server im
going to give it another shot ,trying to write the connection code
first and see what happens.
Best of luck

 

[odmonk]

I was trying to connect locally to the SQL Server 7.0 installed on my computer.

 

[anthony]

Its probably just a little problem you should be able to work
out(beceause,as I say ,I connected locally) and without
any IIS or anything on my computer.
Im just worried about remote connections.
Anyway Im sure youll have it running soon!
SEE YAS.