Solved

Front Page Error: error 'ASP 0115'

Posted on 1998-10-26
9
155 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
Comment Utility
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
Comment Utility
 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
Comment Utility
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
 
LVL 1

Expert Comment

by:Jedi
Comment Utility
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:erot
Comment Utility
 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
Comment Utility
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
Comment Utility
OK, Thanks
0
 

Author Comment

by:erot
Comment Utility
 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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
In this tutorial viewers will learn how to style a corner ribbon overlay for an image using CSS Create a new class by typing ".Ribbon":  Define the class' "display:" as "inline-block": Define its "position:" as "relative": Define its "overflow:" as …
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now