Help : Using ADO on MTS without IIS and ASP 
Author Message
 Help : Using ADO on MTS without IIS and ASP

[This followup was posted to comp.lang.basic.visual.database and a copy
was sent to the cited author.]


Quote:
> I am trying to install a component into MTS.   I wrote this component in
> Visual Basic, it attaches to an Oracle Database (8.0) through ADO .
[deleted stuff]
> However, when I put the component on our
> "real" MTS, which does not have IIS and ASP installed on it, I get an
> ADO.connection Error (3706 - Provider not found).

> To the best of my knowledge, ADO IS installed on this machine.  

How about the Oracle SQL*Net stuff (don't use the 8.0 version, use the
downlevel support), and the MTS Oracle support (for which you'll need
Oracle patches - see the Microsoft newsgroups for more info).

Chris Wuestefeld
Software House Enterprise Solutions



Fri, 29 Sep 2000 03:00:00 GMT  
 Help : Using ADO on MTS without IIS and ASP

Quote:
>ADO.connection Error (3706 - Provider not found).

A provider is like a ODBC driver for the database.  If you are getting this
error, the most likely cause is that the Provider for Oracle was not
installed during the Option Pack installation.  Goto www.microsoft.com/data
for more information about OLE DB Providers.  They also have a list of
vendors who have created Providers. I believe Microsoft has created a
provider for Oracle.  I also believe you can install the Provider for Oracle
during the Option Pack setup.  Try running the install program again and
make sure you look at all the options.

Dave



Tue, 03 Oct 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Help : Using ADO on MTS without IIS and ASP

2. Simulate asp - run asp without iis

3. Problem using MTS and IIS together

4. Problems using MTS and IIS together

5. newbie - COM with MTS Vs COM without MTS

6. ASP/ADO and IIS/PWS...

7. SQL Server - IIS - ADO - ASP

8. IIS and NT password change using ASP.

9. Quering an interface from another using MTS and ASP

10. vbscript from asp using iis on win2k platform with no success

11. execute an exe file using asp with iis 4

12. IIS shuts down periodically when using ASP, RDS and COM

 

 
Powered by phpBB® Forum Software