Solved

Front Page Error: error 'ASP 0115'

Posted on 1998-10-26
9
161 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
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
alert(innerHTML); 8 32
Web experts ! HTML ! Javascript project for medical MRI sharing 24 49
Make Session back to empty 9 30
Need HTML output in powershell line by line 3 30
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
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.
In this tutorial viewers will learn how add a scalable full-width header using CSS3. Create a new HTML document with an internal stylesheet. Set a tiled background.:  Create a new div and name it Header. Position it with position:absolute at the top…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

831 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