Solved

Front Page Error: error 'ASP 0115'

Posted on 1998-10-26
9
159 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
This article discusses how to create an extensible mechanism for linked drop downs.
In this tutorial viewers will learn how to position overlapping items using z-index in CSS. They will also learn the restrictions on the z-index property.  Create a new HTML document with an internal stylesheet.: Create a div in CSS and name it Red.…
In this tutorial viewers will learn how to embed videos in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <video> tag to insert a video. Define the src as the URL of your video; this is similar to …

770 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