pws & asp

[Yt2K]

Armed only with PWS running on a Win98 machine, i can serve up asp pages,
but not ones containing database connections. Can someone please tell me
what i need to get in order to get this going ...
The error i get is :

Provider error '80040154'

Class not registered

/myweb/global.asa, line 40

and i'm trying to connect to an Access97 database ...

Thanks in advance,
yt

[Gordon Rankin]

Settings/Control Panel/ODBC Data Sources

Then click System DSN tab, then Add, MS Access Driver, then name and
physical location.

If permissions are correct and the DSN name in your ASP matches, it should
work.

"Yt2K" <gra...@reply.to.group> wrote in message
news:NdMx4.7074$K5.1...@news2.rdc1.on.home.com...

[Yt2K]

nope didn't work - and it's not a DSN connection i'm making, so i tried the
DSN thing, but it didn't work either. There must be a .dll i'm missing or
something ....
yt

Gordon Rankin wrote in message ...

[Michal Boleslav Mechura]

I don't have a problem with this, and I use the same evironment as yourself:
W98 + PWS + Access 97. What I do is:

1. Create the database first, of course
2. Create a System DSN in Control Panel > ODBC datasources
3. Use the name of the DSN to open connections to the database from within
my ASP code.

A no-brainer. If it doesn't work on your machine than someting must be
broken somewhere.

Michal

--
Michal Boleslav Mechura
m...@indigo.ie

[hop...@my-deja.com]

I have the same problem, only with PWS and SQL Server 7.0, and I can't
even create a database yet because I can't log on to the server. I am
trying to create a database on (local), but when I try to log on to the
server with password "sa", I get "Unable to Connect to Server
\\oemcomputer" and "General Network Error". I just installed PWS from
the Windows 98 Upgrade CD, and installed SQL Evaluation Edition,
Desktop. Oemcomputer is the name PWS gave my computer automatically. I
have also changed the default Client Net Library to TCP/IP as advised in
the SQL Books Online.

I have also noted that all of the Web Page help files of PWS are 404.
Is this something wrong with the Win98 Upgrade CD or what? I have found
nothing to help on the Microsoft Web Site.

In article <zNXx4.317$jn4...@news.indigo.ie>,

"Michal Boleslav Mechura" <m...@indigo.ie> wrote:
> I don't have a problem with this, and I use the same evironment as
yourself:
> W98 + PWS + Access 97. What I do is:
>
> 1. Create the database first, of course
> 2. Create a System DSN in Control Panel > ODBC datasources
> 3. Use the name of the DSN to open connections to the database from
within
> my ASP code.
>
> A no-brainer. If it doesn't work on your machine than someting must be
> broken somewhere.
>

Sent via Deja.com http://www.deja.com/
Before you buy.

[Yt2K]

well ... i can help you with the help files....

when installing PWS, you have to check off all the documentation checkboxes,
particularly those referring to ASP. When on the Custom Install screen for
PWS, dig into the subsections and make sure the ASP Help files are checked
off (There's about 64Megs of them). I had that problem and this alleviated
it.

as for the not connecting to your database problem, i downloaded and
installed the file 'mdac_typ.exe' from MS which contained the Database
Registry setting requirements for ADODB connections. This file inserts
values into your registry for correct processing (linking the correct dlls)
when asp processing occurs. That may help.

yt

hop...@my-deja.com wrote in message <8aglk3$9kq$1...@nnrp1.deja.com>...