dotnet academic: Complete Newbie to VB.NE

Successfully completed the "Hello World" walK though

Now trying the WalkThrough_MasterDetail walk through

Drag and droped an OldDbDataAdapter or SqlDataAdapter

Wizard fires. Click Next

Click New Connection. Nothing happens

What do I have to do to get these Data Adapters to work

Thanks
Barry G. Sumpte

Barry,

Have you installed MSDE? It is needed for VS .NET (and VB .NET) and it is
not automatically installed by VS .NET.

bill burrows

[quoted text, click to view]

No I have SQL Sever 2000 installed and running fine.

Do I still need MSDE?

I'm thinking the providers may be missing from .NET Academic?


Thanks,
baz


--------------
[quoted text, click to view]

[quoted text, click to view]
The providers are available in Visual Studio .NET, Academic Edition, if
everything installed correctly. The Academic Edition is the full
Professional Edition minus remote debugging, plus the academic add-ins.
What do you see in Server Explorer? Is your instance of SQL Server shown? Do
you have any databases built? Are you able to retrieve data from tables
using Server Explorer?
What happens if you try to add a SqlConnection object, then select <new
connection> from the properties window? Still no Data Link Properties
dialog?

--
Peter [MVP Academic]

Hi Peter,

Thanks for the response.


I've fixed it.

-------
To answer your questions first.

No I could not get to the database thru the Server Explorer at all.

The server explorer did show SQL Server on my machine.
Then my machine name with and x on the icon.
But that is all.

No matter how I tried to expand the node its just wouldn't expand.

As stated, I did have SQL Server 2000 up and running.

Clicking the New Connection did nothing.

-------------

What I did.

Removed/uninstalled everything. IIS, .net, SQL Server, etc.

Installed SQL Server 2000.
Installed VB6 - and VB6 SP5. - (Both new for this Win2000 Platform).

Having problems with connecting to SQL Server. (Provider not found.)
Installed MDAC 2.8.
No more problems with SQL Server.

Installed VS.NET 2003 Academic - absolutely everything - previously only
vb.net.
Afterwards vs.net installed asked to install MSDE sp3 for .NET 2003
- I did this time but not on the previous install. Thought since I
already had SQL Server 2000 it would be OK.


All working properly now. Including the dialog from the New Connection...


Could have been MDAC 2.8, Installing absolutely everything from VS.NET, or
the MSDE sp3.

Man! What a huge waste of time. = (
3 days of muckin around.

Whoooh!

I sure I'll be back soon....


Thanks all,
baz








[quoted text, click to view]