Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Unanswered: Help!!!Sql server 2000 adding problem?

    HELP

    I'm trying to add the new record to the database, but got the error from IE.

    HTTP 500 - Internal server error
    Internet Explorer

    How can I add my info to my company SQL Sever 2000???
    Following is my code:

    <%
    Dim sql

    Dim objConn
    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=c:\InetPub\wwwroot\daly\fpdb\market.mdb"

    sql="INSERT INTO Attendees (AttendeeFirstName,AttendeeLastName)"
    sql=sql & " VALUES "
    sql=sql & "('Saleng', 'Teng')"

    objConn.Execute sql
    objConn.close
    %>

    Thanks for your help.

    scn@daly.com
    Last edited by saleng; 08-13-04 at 11:30.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Are you sure you want to be posting to the SQL Forum? The connection string listed below shows that you are connecting to an Access DB...

    Regards,

    hmscott

    Quote Originally Posted by saleng
    HELP

    I'm trying to add the new record to the database, but got the error from IE.

    HTTP 500 - Internal server error
    Internet Explorer

    How can I add my info to my company SQL Sever 2000???
    Following is my code:

    <%
    Dim sql

    Dim objConn
    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=c:\InetPub\wwwroot\daly\fpdb\market.mdb"

    sql="INSERT INTO Attendees (AttendeeFirstName,AttendeeLastName)"
    sql=sql & " VALUES "
    sql=sql & "('Saleng', 'Teng')"

    objConn.Execute sql
    objConn.close
    %>

    Thanks for your help.

    scn@daly.com
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •