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
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
9  1153 
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" <th**********@smithcentral.net> wrote in message
news:_X*****************@newssvr16.news.prodigy.co m... 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
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Are there any disadvantages to this? Are we going to take a hit on speed
or lack functionality? Can we use Transactions still?
Aaron
CJ Taylor wrote: 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" <th**********@smithcentral.net> wrote in message
news:_X*****************@newssvr16.news.prodigy.co m...
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
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks. 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
CJ Taylor wrote:
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" <th**********@smithcentral.net> wrote in message
news:_X*****************@newssvr16.news.prodigy.co m...
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
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Ok. Thank you for the information.
CJ Taylor wrote: 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
CJ Taylor wrote:
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" <th**********@smithcentral.net> wrote in message
news:_X*****************@newssvr16.news.prodigy .com...
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
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
I don't believe mysql supports stored procedures.
Aaron Smith wrote: Are there any disadvantages to this? Are we going to take a hit on
speed or lack functionality? Can we use Transactions still?
Aaron
CJ Taylor wrote:
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" <th**********@smithcentral.net> wrote in message
news:_X*****************@newssvr16.news.prodigy.co m...
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
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
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 wrote: I don't believe mysql supports stored procedures.
Aaron Smith wrote:
Are there any disadvantages to this? Are we going to take a hit on
speed or lack functionality? Can we use Transactions still?
Aaron
CJ Taylor wrote:
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" <th**********@smithcentral.net> wrote in message
news:_X*****************@newssvr16.news.prodigy .com...
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
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
Here are 2 links I just found http://sql-info.de/mysql/gotchas.html http://databasejournal.com/features/...le.php/3087841
Aaron Smith wrote: 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 wrote: I don't believe mysql supports stored procedures.
Aaron Smith wrote:
Are there any disadvantages to this? Are we going to take a hit on
speed or lack functionality? Can we use Transactions still?
Aaron
CJ Taylor wrote:
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" <th**********@smithcentral.net> wrote in message
news:_X*****************@newssvr16.news.prodigy.co m...
> 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
>
> --
> ---
> Aaron Smith
> Remove -1- to E-Mail me. Spam Sucks.
You are awesome. Thank you!
Eric Sabine wrote: Here are 2 links I just found
http://sql-info.de/mysql/gotchas.html
http://databasejournal.com/features/...le.php/3087841
Aaron Smith wrote:
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 wrote:
I don't believe mysql supports stored procedures.
Aaron Smith wrote:
Are there any disadvantages to this? Are we going to take a hit on
speed or lack functionality? Can we use Transactions still?
Aaron
CJ Taylor wrote:
>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" <th**********@smithcentral.net> wrote in message
>news:_X*****************@newssvr16.news.prodi gy.com...
>
>
>
>>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
>>
>>--
>>---
>>Aaron Smith
>>Remove -1- to E-Mail me. Spam Sucks.
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
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.
"Eric Sabine" <mopar41@mail_after_hot_not_before.com> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl... I don't believe mysql supports stored procedures.
Aaron Smith wrote: Are there any disadvantages to this? Are we going to take a hit on
speed or lack functionality? Can we use Transactions still?
Aaron
CJ Taylor wrote:
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" <th**********@smithcentral.net> wrote in message
news:_X*****************@newssvr16.news.prodigy.co m...
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
--
---
Aaron Smith
Remove -1- to E-Mail me. Spam Sucks.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: nt9 |
last post by:
I am very new with php so excuse me please if the question seems really
easy.I have a page(form) which displays a list of the titles of some
books(retreived from a database) and each title has a...
|
by: Mica Cooper |
last post by:
Hi,
I have a series of Select menus on a page. I am trying to allow the user to
click on the Select title and have it popup a help window. This works fine
with the following code except that all...
|
by: apngss |
last post by:
When an application needs to get information from another machine over
the network, how many distributed computing choices out there?
Here are the choices I know of, classifying by different...
|
by: John Baker |
last post by:
Suppose I am exploring an unknown form programatically through VBA, and
I have run across a control I have determined is a combo box.
Is there a way to tell if the combo choices are restricted to...
|
by: InDeSkize |
last post by:
I'm in the middle of building a database in access 2002 for a client
of mine. I just wanted to know what my choices were to make this
database accessable from multiple clients at once.
His...
|
by: Sarah Smith via AccessMonster.com |
last post by:
I am creating a database of documents that need to be worked on, are int eh proress of being worked on, and have been completed. Sometimes the same document (an updated version) comes back for more...
|
by: Rhino |
last post by:
How hard (and desireable) would it be to give the user certain choices when
it comes to printing web pages?
The pages on my site use colours and pictures and contain an imbedded menu,
among...
|
by: wideasleep |
last post by:
Hello everyone,
I am looking for a way to remove choices from cascading combo boxes as each selection is made.
Here's how this is laid out.
The initial combo box is STAGE and it will have...
|
by: vajra1987 |
last post by:
Hello everybody
I am working on a Website built on JSP and Servlets . one of the features of the site is to give user the chance to subscribe to different newsletters under different categories.
...
|
by: jej1216 |
last post by:
Background:
I have an PHP form that inserts data into a MySQL DB, and it works. Severity of Incident:
<select name="severity" size="1">
<option value="">Select a Severity Option</option>...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
