ASP-MySQL insert into db problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ariskot
    New Member
    • Sep 2006
    • 1

    ASP-MySQL insert into db problem

    Hi.

    I'm having a problem with a site that worked fine up to now, but they just upgraded to the new SUN Chilisoft ASP version. It used to work fine and I can still read data, but I can't write through my asp registration page. This is the error I'm getting:

    HTTP 500.100 - Internal Server Error - ASP error
    Apache/1.3.33 (Unix) Sun-ONE-ASP/4.0.0 ApacheJServ/1.1.2 PHP/4.3.10 FrontPage/5.0.2.2635 Rewrit/1.1a

    Technical Information (for support personnel)

    Error Type:
    Sun ONE ASP VBScript runtime (0x800A01A8)
    Object required: 'MyConn'
    /site/scripts/register.asp, line 82


    And this is my asp script that regards the object 'MyConn' :

    Dim MyConn

    Set MyConn=Server.C reateObject("AD ODB.Connection" )
    MyConn.Open "Driver={My SQL ODBC 3.51 Driver}; Server=domain; Database=dbname ; UID=user; PWD=password; Option=3"


    I can read but can't write to the db. Can anyone figure out why?

    Thanks
Working...