.NET & Foxpro OLEDB

Discussion in '.NET' started by ninel, Mar 6, 2008.

  1. ninel

    ninel

    Joined:
    Aug 7, 2007
    Messages:
    2
    I have a .net web application that needs to insert data into a free dbf table on a remote server. I have downloaded and installed the FOXPRO OLEDB Provider onto that remote server.

    Here is my code:
    Code:
            Dim objFoxProConn As OleDbConnection
            Dim FoxProConnString As String
            Dim sVfp As String
    
            FoxProConnString = "Provider=vfpoledb.1;Data Source=\\ITITPAFS02.ititpa.itic\pds\voicenet\system\;Collating Sequence=general;Exclusive=No;"
            objFoxProConn = New OleDb.OleDbConnection(FoxProConnString)
            objFoxProConn.Open()
    
            sVfp = "INSERT INTO agentusr(agentid, login, last, first, socsec, phone, address, city, state, zip,notes,otherid,disabled,verifier) "
            sVfp = sVfp & " VALUES(66200,'TEST','TEST','TEST','034554354','813-882-3023','123 Main street','Tampa','FL','34638','', '',.F.,.F.)"
    
            Dim oCmdTAMPA As New OleDbCommand(sVfp, objFoxProConn)
            oCmdTAMPA.ExecuteNonQuery()
    
    This works on other remote servers I have tried, but on this server I am getting the following errors:

    No error information available: REGDB_E_CLASSNOTREG(0x80040154).
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154).

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:


    [OleDbException (0x80040154): No error information available: REGDB_E_CLASSNOTREG(0x80040154).]

    [InvalidOperationException: The 'vfpoledb.1' provider is not registered on the local machine.]
    System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) +83
    System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) +107
    System.Data.OleDb.OleDbConnection.Open() +203
    RepClock.AddAgent.cmdSubmit_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\RepClock\TimeTrackerDEV\AddAgent.aspx.vb:53
    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
    System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +58
    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
    System.Web.UI.Page.ProcessRequestMain() +1292


    Can someone please help me out?
    Thanks,
    Ninel
     
    ninel, Mar 6, 2008
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jan Smazinka

    Visual FoxPro OleDB Driver in ASP.NET

    Jan Smazinka, Nov 28, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    2,043
    Jan Smazinka
    Nov 28, 2003
  2. Jan Smazinka

    FoxPro OleDb Problem on Windows 2003

    Jan Smazinka, Nov 28, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    515
    Jan Smazinka
    Nov 28, 2003
  3. Amedee Van Gasse
    Replies:
    2
    Views:
    2,864
    Buddy Ackerman
    Jun 16, 2005
  4. thomson

    Foxpro window Migration .net

    thomson, Oct 19, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    472
    thomson
    Oct 19, 2005
  5. ninel
    Replies:
    0
    Views:
    1,275
    ninel
    Mar 5, 2008
Loading...

Share This Page