Support both MSSQL & MSDE

11 Aug 2005 11:04 PM

rob

I want to create an application that can be used both for a
server-client model as well as a standalong application. The idea is to
write a general server-client application. The standalong then just has
both components on the same system. For the server client approach MS
SQL will be used. Obviously for the standalon version I don't want the
user having to buy MS SQL. So the idea is to use MSDE instead. The
question now is how much code change this will require. Are they
compatible enough that I can basically use the same code and just have
to change a few parts? Are there other things that I would have to
consider putting both the server and client on one computer (running
Win 2k/XP).

Rob

11 Aug 2005 11:18 PM

ML

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp

ML

12 Aug 2005 9:42 PM

Thomas Albertsson

Hi Rob,
You will not need to change the code at all.
In the msde version you got some limitations that you dont have in sql
server, you can read about this on msdn.microsoft.com
Note:
You will not have the query analyser tool , so you need to develop a user
interface to run the script against the database or to use oSql to execute
your script

//Thomas

Show quote

"rob" <rmdiv2***@yahoo.com> skrev i meddelandet
news:1123801479.364782.131990@z14g2000cwz.googlegroups.com...
>I want to create an application that can be used both for a
> server-client model as well as a standalong application. The idea is to
> write a general server-client application. The standalong then just has
> both components on the same system. For the server client approach MS
> SQL will be used. Obviously for the standalon version I don't want the
> user having to buy MS SQL. So the idea is to use MSDE instead. The
> question now is how much code change this will require. Are they
> compatible enough that I can basically use the same code and just have
> to change a few parts? Are there other things that I would have to
> consider putting both the server and client on one computer (running
> Win 2k/XP).
>
> Rob
>