dotnet odbc.net: Help!!!!
I have recently purchased a copy of Visual Basic.net with the intent
to use it in a databaseing application with SQL Server/MSDE.

I also purchased a book on how to do it and It reccomends you download
the evaluation version of SQL server (See link)

http://microsoft.com/sql/evaluation/trial/2000/download.asp

And to use it for database management.

SQL server is great, it has managed to overcome problems I have
experienced with Foxpro6 and Access 2000 (They don't like referring to
more than 2 relational tables at any 1 time - my application uses 6)

This has one a fatal flaw:
VB.net Standard edition only suports MSDE and not SQL Server

Question 1.
Does SQL server have an MSDE "emulation" mode that will allow VB.NET
to access these databases.

Question 2.
Is it possible to have Both SQL server and MSDE installed on a PC at
the same time? It is a complete pain to have to install/uninstall each
time you want to change server providers

Question 3. I have created a database using SQL server, How do I get
MSDE to make this database avaialable through VB.NET. Is there a
comprehensive user manual for MSDE, So far I have only been able to
find scraps of semi-useful information through MSDN.

Any information would be great,

Thanks,

Timbo..

Hi Tim,


[quoted text, click to view]
Where did you read this one?
MSDE is basically the Sql Server without client tools and some limitations.

[quoted text, click to view]

No need, see above.

[quoted text, click to view]

Only one is more than enough, isn't it?

[quoted text, click to view]

If you have Sql Server you might use its client tools to manage MSDE.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

[quoted text, click to view]

you can only use vb .net standard edition for msde and access and other non
server based databases

[quoted text, click to view]

it is possible.once you install office 2000 and sql server you can use msde
from access.only that the database engine will be upgraded to the sql server
version if its higher that office 2000

[quoted text, click to view]

use the data import and export function of msde to get your data from the
sql server

[quoted text, click to view]