Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: catastrophic failure using my sql oledb provider in ASP

    Hi,

    I installed mysql oledb provider in my system.

    But Iam unable to connect to my sql using ADODB Object in ASP, its giving me following error
    ---------------------------------------------------------------------------------------------------
    Error Type:
    Provider (0x8000FFFF)
    Catastrophic failure
    /test/sampleconnection.asp, line 16

    ---------------------------------------------------------------------------------------------------

    I wrote following code in ASP;
    -------------------------------------------------------------
    dim conn
    connString="Provider=MySQLProv;server=192.168.1.7; port=3306;database=grades;uid=test;pwd=test"
    set conn=server.CreateObject("ADODB.connection")
    conn.Open()
    ---------------------------------------------------------------------------------

    Please suggest me as soon as posssible.

    Regard's
    Krishna Prakash.K

  2. #2
    Join Date
    Sep 2003
    Posts
    69
    Error Type says provider, you sure that the connection string is correct?

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    Originally posted by trieder
    Error Type says provider, you sure that the connection string is correct?
    connection string exactly correct, because thats alreadt working with ODBC. I want it to shift OLEDB provider

    please suggest

Posting Permissions

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