SQL Choices...

[Aaron Smith]

I have a question. (Keep in mind, I am a BIG TIME newbie with VB.Net, we
don't even have our subscription CDs yet.) We are doing some pre-design
thinking about the application we are going to be developing. If we
develop the app for SQL Server, and then someone wants to run, say
MySQL, will that work just by changing the DSN? Will I have to have
seperate code for data access if we wanted to support SQL server or MySQL?

Thanks,
Aaron

 

[CJ Taylor]

You can use an OLEDB Provider instead of the Specific SQL DAta Provider and
use a DSN that way with little/no problems...

 

[Aaron Smith]

Are there any disadvantages to this? Are we going to take a hit on speed
or lack functionality? Can we use Transactions still?

Aaron

You can use an OLEDB Provider instead of the Specific SQL DAta Provider and
use a DSN that way with little/no problems...

 

[CJ Taylor]

Are there any disadvantages to this? Are we going to take a hit on speed
or lack functionality? Can we use Transactions still?

You may take a hit on speed because you have another layer of abstraction.
The ability to run transactons is dependent on the SQL server as well as the
lack of functionality. The Adapter itself doesn't determine what SQL can
run, the server itself determines that.

Aaron

 

[Aaron Smith]

Ok. Thank you for the information.

Are there any disadvantages to this? Are we going to take a hit on speed
or lack functionality? Can we use Transactions still?

You may take a hit on speed because you have another layer of abstraction.
The ability to run transactons is dependent on the SQL server as well as the
lack of functionality. The Adapter itself doesn't determine what SQL can
run, the server itself determines that.

 

[Eric Sabine]

I don't believe mysql supports stored procedures.

 

[Aaron Smith]

Yea, I'm not sure if it does. I tried out MySQL last night and found out
that it will not work right with the OleDBAdapter for some reason. I
keep getting an error message when trying to connect. I'm so new at it,
that I don't know if it's me or if it doesn't work. I need to do more
research on it, I guess. If we have to limit ourselves to certain
functionality for the sake of being compatible with both using the same
code, then I don't have a problem with that. But if it has to have
seperate code for both, I have a problem with that and will ditch the
MySQL effort. Gotta run with what works and is highly supported.

Aaron

 

[Eric Sabine]

Here are 2 links I just found

http://sql-info.de/mysql/gotchas.html
http://databasejournal.com/features/mssql/article.php/3087841

 

[Aaron Smith]

You are awesome. Thank you!

Here are 2 links I just found

http://sql-info.de/mysql/gotchas.html
http://databasejournal.com/features/mssql/article.php/3087841

 

[CJ Taylor]

Apparently the 4.0 version supported SP's... I don't use MySQL though.
There are drivers for that and PostGres though...

Personally, I prefer MSDE if I'm doing a desktop installation.