Re: What's My Password?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Rob MacDonald.

Don't assume the ISP has any DBMS. Some support MySQL or other (perfectly
good) DBMS engines.
Yes, like with any new skill it all seems very intimidating at first (been
there). I wrote my book for developers just like you--overwhelmed with the
choices and just trying to get stuff working. I'm sure it will help. It was
written to answer almost every question asked on these newsgroups and in my
sessions for the last 15 years. It's interesting how the same questions keep
getting asked... ;)

Good luck.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
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:%23AWNkN5MHHA.4992@xxxxxxxxxxxxxxxxxxxxxxx
William,

--> There are two parts to the problem. First, the DBMS engine as
configured on your system must be reproduced (reconfigured in the same
way) on the target server. Next, the database managed by SQL Server must
be transported and attached to the target DBMS engine when you're ready
to deploy. That's the nature of SQL Server and most DBMS platforms like
it.

Yes, and I'm deeply concerned about that.

Anyway, I'll try to get it working so I can at least develop and run it,
knowing that I'll probably need to do some reading before I'll ever be
able to get things working on my site.

---> No, not really. The 2.0 Framework does not include a DBMS engine of
any kind. It does include ADO.NET which is simply a set of classes used
to access any selected DBMS engine that has a .NET Provider of some kind.
You're going to have the ISP install SQL Server (of some kind) on the
target IIS server or on a server local (or at least visible) to that
site. This is not always that easy.

None of this is easy unless you already know it. I guess that's a
distinction I had not yet made. I would still tend to assume some sort of
database management system is available on my hosting server. I may need
to ask them to find out for sure.

---> "localhost" resolves to the machinename in most cases, but I've not
had a lot of success with it in ConnectionStrings. The "\\" might be part
of the issue. Remember that when you run an ASP application, it's IIS
that opens the connection for you--not the local browser user. It uses a
special account that Rob discusses in his book. So do I, but not to as
great an extent.

I'm sorry, I'm a bit overloaded. Who was Rob again and which was his book?
I may need to buy a few more books before this is over.

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




.

Relevant Pages

  • Re: Whats My Password?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... the database on my computer. ... and attached to the target DBMS engine when you're ready to deploy. ... developers as it discusses issues that all architectures are likely to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Single Quote In A Text Field
    ... since an UPDATE or INSERT could be perverted, that would include any DBMS engine that accepts commands--SQL or not. ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... Do you really think that SQL injection is impossible without multioperation execution? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How can I update a an entire table in a dataset?
    ... I would still export the data to SQL Server via SqlBulkCopy and then do the global or other operations there. ... is no DBMS engine involved in the application... ... "William Vaughn" wrote: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Number of left joins allowed in query
    ... > Dear Rob: ... > and use a SQL Server query. ... You may need to buy the SQL Server Developer Edition ... >>> exploratory work. ...
    (microsoft.public.access.queries)
  • Re: Cant create Primary Key???
    ... Columnist, SQL Server Professional ... > SQL Server MVP ... > "Rob" wrote in message ... > the primary key I get the error below. ...
    (microsoft.public.sqlserver.server)