application error - cant open web application

Posted on 2012-08-20
Last Modified: 2013-01-11
hi everyone,

i have an issue with a web application.. im not a vb developer and im completly lost with it

our web host went out of business and we've been given a week to move the web application to a new host.

the original developer died a year a go and we cant get anyone to assist.

the new web host doesnt support coding :(

issue is when we connect to the application on the new host:

the web host has said there is a problem with the following line of code :  

Dim MM_proplink_String = set rsEvents = Server.CreateObject("ADODB.Recordset")

The contains this code:

' FileName="Connection_ado_conn_string.htm"
' Type="ADO" 
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_proplink_String = set rsEvents = Server.CreateObject("ADODB.Recordset")
rsEvents.ActiveConnection = "Driver={MySQL ODBC 5.1 Driver}; DATABASE=web213-plni;USER=$$$$$$$$$; PASSWORD=$$$$$$$$$$; Server=IP-ADDRESS"

Open in new window

anyone any ideas?  

thanks for looking :)
Question by:BSRIT
    LVL 49

    Accepted Solution

    Firstly this looks like a classic ASP app not ASP.Net.

    Having said that the server is not giving very informative errors - could be anything.

    1. It is trying to connect to a MySQL database
       - Does your new host have the MysQL ODBC driver installed
       - Has the database been setup correctly with the correct name => web213-plni

    If the problem is with this

    Dim MM_proplink_String = set rsEvents = Server.CreateObject("ADODB.Recordset")

    Then you have a real problem - but I don't think that is the issue - more like a database connection error.

    Is it possible to ask your ISP to turn on ASP error reporting for this app so we can see the error?

    That will give us a good idea of where the problem is

    Author Comment

    Hi Julian,

    Thank you for the reply!

    I have been in contact with the web host and i'll post an update when they get back.

    Again, thanks :)

    LVL 26

    Expert Comment

    by:Alan Warren
    Hi BSRIT,

    the new web host doesnt support coding

    Could you provide some details about your new hosting package please?
    Could you also please confirm the suspicion of julianH
    this looks like a classic ASP app not ASP.Net.

    As far as I can tell, your new host does not support asp scripting or .net.

    It may be a good time to upgrade your app, possibly to .net and secure a reliable asp .net host provider that actually allows coding and SQL database hosting too.

    I'd highly recommend, hosting and SQL Db package will set you back about 150/year, their support service is second to none.

    What is the size of your app, approximately how many pages?


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 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

    20 Experts available now in Live!

    Get 1:1 Help Now