MSDE 2000 & MySql - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

MSDE (2000)

MSDE 2000 & MySql

Author

Topic

adsc
Starting Member

3 Posts

Posted - 2002-09-24 : 07:27:07

Dear All,

Did anyone tryied to use MSDE 2000 or MySql database with VB.Net development, the objective is VB.Net as a front end and the MSDE 2000 or MySql as back end database.

And where can I find explenations about using/dealing with MSDE2000 since there is no (UI) for it, how to create database/tables etc...

I would like to know also which database of the above is more advisable to use.

Thank you for any openion.

ADSC

REMEMBER,,,,KNOWLEDGE IS POWER

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2002-09-24 : 17:39:12

[url]http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp[/url]

you can interface with an MSDE db through OSQL.exe

I would suggest MSDE as opposed to MySQL but then again I'm biased towards actual RDBMS'.

m2c,
Justin

Have you hugged your SQL Server today?

adsc
Starting Member

3 Posts

Posted - 2002-09-25 : 06:30:27

Justin, Thank you very much for your reply.

I visited that link on microsoft site before, but I need to know the command which allow me to comunicate with MSDE 2000, where the database file will be stored, I need technical/programming info & command.

ADSC

quote:

[url]http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp[/url]

you can interface with an MSDE db through OSQL.exe

I would suggest MSDE as opposed to MySQL but then again I'm biased towards actual RDBMS'.

m2c,
Justin

Have you hugged your SQL Server today?

REMEMBER,,,,KNOWLEDGE IS POWER

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-09-25 : 07:47:20

quote:
I visited that link on microsoft site before, but I need to know the command which allow me to comunicate with MSDE 2000, where the database file will be stored, I need technical/programming info & command.

You seem to be missing some key information about SQL Server. Your front-end will interface with MSDE in the same way it would interface with any other version of SQL Server. I would suggest you get some books with examples of SQL Server data access.

Jay White
{0}

Edited by - Page47 on 09/25/2002 07:47:39

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources