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

chamoore · #1 (**permalink**) 12-11-04, 09:41

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?

hupy · #2 (**permalink**) 02-25-09, 23:42

i also meet this problem ,how can i do????????????

gvee · #3 (**permalink**) 02-26-09, 09:50

What happens if you

Code:

SELECT column, names
FROM   your_table

instead of using SELECT *
?

SimonMT · #4 (**permalink**) 02-26-09, 20:12

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

Internet Services

Web Development

Digital Marketing

Consumer Tech