Re: Here's a rather broad question...



- XP x64
- SQL Server 2005 x64
- IIS
- Classic ASP

What are the general steps I have to go through in order to be in a
position where I can start querying the database in classic ASP?

Personally I would not XP 64-bit. Too many things not supported for my
liking.
Anyway, it is your funeral.

You dont mention what database technology you wish to use but I assume it is
classic ADO (on-topic here) and not ADO.NET (off-topic here, all .NET stuff
should be discussed in the newsgroups that Microsoft setup for this
technology. They all have "dotnet" as part of the newsgroup name, somewhere.
There is a newsgroup specifically for using ADO.NET)

Whatever you do, dont make the mistake of installing MDAC 2.8 or MDAC 2.81.
They specifically say they are not endorsed for Windows 64-bit.
Instead use the MDAC 2.8 that comes with this version of XP.

After a few hours, whatever I do, I always seem to run into connection
string problems, authentication problems, permission problems,
whatever--so I wanna start over again with a clean slate and not make any
assumptions on current state.

Well you will have to say what you have done, give Connection strings,
version numbers, _EXACT_ error messages etc

Stephen Howe


.



Relevant Pages

  • Re: data access providers
    ... > i had mdac version 2.5. ... > followed all their instructions the error still appears. ... I've crossposted this reply to that group and set followups. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: data access providers
    ... > i had mdac version 2.5. ... > followed all their instructions the error still appears. ... I've crossposted this reply to that group and set followups. ... Please reply to the newsgroup. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: MDAC and SBS2003 SP1
    ... >please click Detail tab to show the detail information about the MDAC ... Programs that use DCOM do not work correctly after you install Microsoft ... Microsoft CSS Online Newsgroup Support ... >> Component Services tool and therefore I cannot change it's permissions. ...
    (microsoft.public.windows.server.sbs)
  • Re: MDAC and SBS2003 SP1
    ... >please click Detail tab to show the detail information about the MDAC ... Programs that use DCOM do not work correctly after you install Microsoft ... Microsoft CSS Online Newsgroup Support ... >> Component Services tool and therefore I cannot change it's permissions. ...
    (microsoft.public.windows.server.sbs)
  • Re: vb6 access to access DB does not work under xp sp2
    ... the type of connection. ... Post replies to the newsgroup. ... What version of ADO are you referencing in your VB project? ... What version of ADO (or MDAC) is installed on the WinXP box? ...
    (microsoft.public.vb.general.discussion)