Solved

Front Page Error: error 'ASP 0115'

Posted on 1998-10-26
9
162 Views
Last Modified: 2010-04-09
 I have used FrontPage98 for some months now..toghether
  with access and PersonalWebServer and ASP pages.
 
  I get the following error when starting an ASP page
  from an HTML-form.

  error 'ASP 0115'
  unexpected error
  /AspWeb/ASP/login.asp
  a trappable error occured in an external object. The
  script cannot continue running.

  the error is described in article ID: q173741
  (Microsoft.com)

  The error occured after I tried to install a BETA 3 of
  the Microsoft SQL Server 7.0.

  I have now deinstalled SQL-Server, deinstalled FrontPage98
  and reinstalled FrontPage98.

  Belive it or not I still get the same error message, and
  are not able to run my ASP-Pages that tries to get records
  from an access DB.
   
  the line in my ASP-page that actually triggers the error
  looks like this:
 
  rs.Open strSql, conn, 3, 3

  I have contacted Microsoft..They can't help me and
  tells me that I have to wait for a Patch for FrontPage98.

  But....is there really not a work around for this problem?
  Any suggestions?

  Yes.. I have done whats possible when it comes to the
  follow up the suggestions in the mentioned article from
  microsoft.
 
0
Comment
Question by:erot
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 1

Expert Comment

by:Jedi
ID: 1839058
When you have installed your SQL server 7.0 beta,

You are using ADO 2.0 ?, Yes

The OLE DB provider for ADO is probably set to the use the SQL Severs own OLE DB Provider.

Try forcing it to use the ODBC provider(universial, default with ADO 1.5) to access the DB.

It's done in the Open connection, and I belive it's done by specifying a PROVIDER= in the connection string.

Hope it helps

0
 

Author Comment

by:erot
ID: 1839059
 Thank you for your response...
  But can you please give me an example of how the syntax
  look like when you use the PROVIDER keyword.
  I can't find any examples....
  I will gladly increase to 150 Points if you can.

  here is my existing code:
    set conn = Server.CreateObject("ADODB.Connection")
    conn.open "DSN=images","",""
    set rs = Server.CreateObject("ADODB.Recordset")
    strSql = "Select * from customer"
    rs.Open strSql, conn, 3, 3

  Erot.
0
 
LVL 1

Expert Comment

by:Jedi
ID: 1839060
I haven't got the environment to test myself for the moment, but try something like:

"DSN=MyDatasource;UID=sa;PWD=secret;PROVIDER=MSDASQL;

//Jedi
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Expert Comment

by:Jedi
ID: 1839061
I Just read something about this:

Cut and paste here it comes:

Use the Provider property to set or return the name of the provider for a connection. This property can also be set by the contents of ConnectionString property or the ConnectionString argument of the Open method; however, specifying a provider in more than one place while calling the Open method can have unpredictable results. If no provider is specified, the property will default to MSDASQL (Microsoft ODBC Provider for OLE DB).

:End cut and paste

You should as i understand it set the provider property on the
connection object direcly if you use the connectin several times.

//Jedi
0
 

Author Comment

by:erot
ID: 1839062
 I can't make i work.
  Anyway, your last Cut&Paste indicates that the
  Provider property initially will be set to "MSDASQL"
  ...and that's what we want.. but it still does not work!!!

  Erot.
0
 

Author Comment

by:erot
ID: 1839063
What you suggested did'nt work....
  But I found an article on Microsoft.com Article-ID: Q193310
  describing the problem and how to fix.

  I'm to get the URL to this fix from Microsoft.
  I'm not closing this now because I want to give you the
  information as well when I get it.

  It might take a day or two.

  Erot.
0
 
LVL 1

Expert Comment

by:Jedi
ID: 1839064
OK, Thanks
0
 

Author Comment

by:erot
ID: 1839065
 Got the feedback from Microsoft after a lot of fuzz.
  The zip file with the fix is called <<3002.23.zip>>.
  After installing the provided dll's and registering them
  everything was working well.

  Microsoft did not give me the URL where to find the file...
  but if you don't find it please send me an E-mail to
                    krudtaa@yahoo.com  
  Then i will send the zip-file to you for eventual future use.

  Please apply a dummy-answer so I can close it and give you
  the points.
  Thank you for trying...

  Erot  /Norway.
 
0
 
LVL 1

Accepted Solution

by:
Jedi earned 100 total points
ID: 1839066
Thank you ,I'll go get that file just in case, My environment looks a lot like yours, so I might need it myself soon.

Jedi /Sverige
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Building a website can seem like a daunting task to the uninitiated but it really only requires knowledge of two basic languages: HTML and CSS.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In this tutorial viewers will learn how to embed an audio file in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: : The declaration should display (CODE) HTML5 is supported by the most recent versions of all major browsers…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question