Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Location
    Istanbul
    Posts
    3

    Unanswered: 0x80040E37 - [Microsoft][ODBC Visual FoxPro Driver]Not a table

    Hi guys,
    I have a Foxpro 8.0 DB defined as System DSN
    my conn string in ASP is :

    Conn_Str = "dsn=MASTERDB;uid=;pwd="
    set cn=server.createobject("adodb.connection")
    cn.open Conn_Str

    When I execute command :
    set rs=cn.execute("select * from Products")

    following error occurs :

    Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
    [Microsoft][ODBC Visual FoxPro Driver]Not a table.

    Problem is "I have an autoincremet field in Products table ".
    I can execute SQL for tables without autoincrement fields.
    How can I fix it?

  2. #2
    Join Date
    Feb 2009
    Posts
    1
    i also meet this problem ,how can i do????????????

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What happens if you
    Code:
    SELECT column, names
    FROM   your_table
    instead of using SELECT *
    ?
    George
    Home | Blog

  4. #4
    Join Date
    Sep 2006
    Posts
    265
    I never use DNS and I would use code along the lines of:

    How to use ADO with ASP to display Visual FoxPro data but I would use the global.asa to declare:

    Code:
    Application("my_conn") = "Driver=Microsoft Visual Foxpro Driver; UID=;SourceType=DBC;SourceDB=C:Physical/Path/File.dbc"
    In ASP:

    Code:
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.ConnectionString = Application("my_conn")
    conn.open
    rsSql = "SELECT ... "
    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.CursorLocation = 3	'adUseClient
    rs.CursorType = 3		'adOpenStatic
    rs.ActiveConnection = conn
    rs.Open rsSql
    Simon

Posting Permissions

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