Data Connection

[Guest odmonk]

Tia,

 

OK, guys. I'm 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, I'm 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]

That's just one of the limitations of the Standard Edition. You'll need to purchase the Professional Edition or Architect Edition.

[Guest 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

[Guest 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.