calling stored procedure from Visual FoxPro database

Discussion in 'ASP .Net' started by JN, Nov 5, 2003.

  1. JN

    JN Guest

    Hello,

    I'm having problem calling stored procedures from Visual
    FoxPro database. I got the following exception error:

    "System.Data.OleDb.OleDbException: Unrecognized command
    verb"

    It seems like the stored procedures are not recognized
    by .Net.
    I'm using .Net framework 1.0 and VFP7.0.

    Here is my code snipet:

    Dim oConn As OleDbConnection = New OleDbConnection
    (AppSettings("connectionString"))
    Dim oCmd As OleDbCommand = New OleDbCommand()

    oCmd.Connection = oConn
    oCmd.CommandText = "generateID" 'calling stored procedure
    oCmd.CommandType = CommandType.StoredProcedure

    Try
    oCmd.Connection.Open()

    Dim oDR As OleDbDataReader
    oDR = oCmd.ExecuteQuery()
    ......................
    oDR.Close()

    .........

    Any help would be appreciated. Thanks in advance.
     
    JN, Nov 5, 2003
    #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,020
    Jan Smazinka
    Nov 28, 2003
  2. bredal Jensen

    Debugging stored procedure in visual studio?

    bredal Jensen, Jul 28, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    367
  3. Mike P
    Replies:
    0
    Views:
    3,328
    Mike P
    Jun 19, 2006
  4. HR Head

    Fresh Programmers Required Visual Foxpro

    HR Head, Sep 5, 2007, in forum: C Programming
    Replies:
    2
    Views:
    298
    Al Balmer
    Sep 5, 2007
  5. Ethan Furman

    dBase III files and Visual Foxpro 6 files

    Ethan Furman, Dec 8, 2008, in forum: Python
    Replies:
    4
    Views:
    892
    imageguy
    Dec 9, 2008
Loading...

Share This Page