Re: Using SQL on Development Machine

It's not as simple as that. As I discuss in my book, SQL Server is a host database engine. It would require that the ISP permit you to install your database into their instance of SQL Server. Would it be the same version as you're using? Maybe, but only maybe. Would it support the functionality you're using? Maybe. SQL Express has features not exposed on other upscale versions and the upscale versions support features not exposed on the Express version. Would you connect to the host instance in the same way as you connect to your local SQL Server instance? Probably not.

So, how do you solve this problem? Well, you start with getting to know more about your ISP and the engine(s) they support and installing the target engine on your development system (or another local system). You'll also need to devise a connect strategy that permits your application to accommodate the security scheme installed on the ISP host.

Another approach is to choose a DBMS platform that does not require the host to do anything to support it--like SQL Server Compact Edition (see my EBook for details). This engine can be imbedded in the application deployment file and accessed like other DLLs.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message news:%23A4TIVq2HHA.5424@xxxxxxxxxxxxxxxxxxxxxxx
William,

Okay, so VS does not include an SQL server then?
Yes, it does. All Editions have SQL Express.

In another thread, you suggested I download MySQL from somewhere. Perhaps because I had mentioned it.

If my host supports both MySQL and SQL Server, is there any reason not to just use SQL Express that comes with VS2005 instead of downloading MySQL? At this stage, I have no idea which one is best, so I am certainly not looking to use one over the other. I'm just trying to make this as simple as absolutely possible.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com


.

Relevant Pages

  • Re: 4 Queries about DB clustering
    ... All drives will need to be visible to all hosts for failover. ... I support the Professional Association for SQL Server ... > I have a similar situation where I plan to install/configure multi-instance> cluster. ... SQL binaries will live on>> the local disks of each cluster host. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... but live on a single host node at a time. ... instance is an independent installation of SQL server. ... www.sqlpass.org "Kamal Hassan" wrote in message ... or do have any recommendation for the above setup before> setting up clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access denied when .ldb is present (only for XP-SP2)
    ... with Win XP are either SQL Server, ... > 4) not mapped drives - i connect to host pc, ... >> 3) multiple domains? ...
    (microsoft.public.access.security)
  • Re: Re:Connection
    ... I know you host a web site on your ISP. ... You want to know you'd better host the SQL server on ...
    (microsoft.public.windows.server.sbs)
  • Re: Active/Active configuration queries
    ... Geoff N. Hiten ... I support the Professional Association for SQL Server ... It is "shared nothing" in that only a single host actually ... of their storage systems to their connected hosts. ...
    (microsoft.public.sqlserver.clustering)
Loading