I have created ODBC connection successfully.but i am unable to retrieve data from EDB server
i get an error like this.i used excel 2003/2007/2010.Non of it retrieved the data.all gave the same error msg as below.

ElevateDB Error #700 An error was found in the statement at line 1 and column 15 [ElevateDB Error #401 The table or view SQLTables does not exist in the schema information]

i hav created the DSN after adding the DAC.
and when creating, it collects the name of DB in the server correctly
Can u please help me to retrieve the data using ODBC in Excel ?
is there a fix or is this a bug ?

I also hav used the tool u hav provided .the SQL utility also gives the same error msg

shahjaufar

<< I have created ODBC connection successfully.but i am unable to retrieve
data from EDB server
i get an error like this.i used excel 2003/2007/2010.Non of it retrieved
the data.all gave the same error msg as below.

ElevateDB Error #700 An error was found in the statement at line 1 and
column 15 [ElevateDB Error #401 The table or view SQLTables does not exist
in the schema information]  >>

Please don't post a message here *and* send us support email about the same
issue.  Just one or the other will suffice.  Email has a quicker response
than newsgroups normally, but not by much.

Per email:

What version of the EDB Server are you using, and was it
recompiled/customized at all ?

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

This is our customer working both ends for support.  I've instructed them to
contact us in the future as they are our customer, not yours.

> What version of the EDB Server are you using, and was it
> recompiled/customized at all ?

The server engine should be a non-modified copy of EDB 2.03b23 or 2.03b23
recompiled with no other changes other than the restructure patch that you
sent me.   The ODBC driver should be an unmodified copy of 2.03b23.  All are
the Unicode versions.

I don't have Excel here, but I've confirmed this same issue with the 2.04b4
Unicode ODBC driver using the SQLConnect test utility that I have from back
when I used Crystal Reports against a unmodified 2.04b4 server.  It fails
the SQLTables call as well, but there is definitely connectivity being
established as I CAN run SQL queries against the data and retrieve
information from the tables.  It's only the SQLTables and SQLProcedures ODBC
calls that seem to be failing.

One more piece of information.  The SQLTables call does return the table
listing using a local connection to the data so it appears to be something
specific to client/server connections.

---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Atrex Electronic Support Options:
Atrex Knowledgebase: http://support.atrex.com/KB/root.aspx
Email: support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------  

Terry,

<< The server engine should be a non-modified copy of EDB 2.03b23 or 2.03b23
recompiled with no other changes other than the restructure patch that you
sent me.   The ODBC driver should be an unmodified copy of 2.03b23.  All are
the Unicode versions. >>

Ahh, that's the problem - I forgot to tell you that the EDB Server has to be
recompiled with these directives:

EDB_ODBC
EDB_UNICODE

The first one is the one that you're missing, so the server isn't exposing
any of the ODBC schema information tables.

My apologies - I completely forgot to mention that when I sent you the fix.
It's something that is automated on our end, so I never really think about
it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> My apologies - I completely forgot to mention that when I sent you the
> fix. It's something that is automated on our end, so I never really think
> about
it.

Not a problem.   Just glad that it's something simple.

--
---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.atrex.com
---------------------------------------