Tim,

I have installed EDB DAC 2.02b7.  Using MDAC version 2.81.
I have set up a System DSN (lets say, Mamba Projects) with a Local Connection and I am
able to select the required DB.

I want to connect to this data source from Word 2003.  When I select the EDB Data Source
(Mamba Projects) from the list of ODBC data sources, I receive the message "Unable to
obtain a list of tables from the data source".

I've tried reading the manual.  Do you have any other suggestions?

Richard Harding

Hi Tim,

I just tried this with Word 2007 and get the same result.
It appears to be passing just the string "%" to the SQLTables function.

I have attached a trace log.

Chris Holland


Richard Harding wrote:
> Tim,
>
> I have installed EDB DAC 2.02b7.  Using MDAC version 2.81.
> I have set up a System DSN (lets say, Mamba Projects) with a Local Connection and I am
> able to select the required DB.
>
> I want to connect to this data source from Word 2003.  When I select the EDB Data Source
> (Mamba Projects) from the list of ODBC data sources, I receive the message "Unable to
> obtain a list of tables from the data source".
>
> I've tried reading the manual.  Do you have any other suggestions?
>
> Richard Harding
>

Richard,

<< I want to connect to this data source from Word 2003.  When I select the
EDB Data Source (Mamba Projects) from the list of ODBC data sources, I
receive the message "Unable to obtain a list of tables from the data
source". >>

This is a bug in 2.02 B7 and will be fixed in 2.02 B8 going out this
morning:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.02&type=f&incident=2925

There was also an issue with Excel, as noted in the incident report.

--
Tim Young
Elevate Software
www.elevatesoft.com

<< "Tim Young [Elevate Software]" wrote:

<< I want to connect to this data source from Word 2003.  When I select the
EDB Data Source (Mamba Projects) from the list of ODBC data sources, I
receive the message "Unable to obtain a list of tables from the data
source". >>

This is a bug in 2.02 B7 and will be fixed in 2.02 B8 going out this
morning:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.02&type=f&incident=2925

There was also an issue with Excel, as noted in the incident report.
>>

I tested it on 2.03 build 13 and it still does not work (Word 2007), but it works on OpenOffice

Marcin.

Marcin,

<< I tested it on 2.03 build 13 and it still does not work (Word 2007), but
it works on OpenOffice >>

Please email me the database catalog and table files that you're trying to
access from Word, along with the steps that you're trying to take.

--
Tim Young
Elevate Software
www.elevatesoft.com

Marcin,

<< I tested it on 2.03 build 13 and it still does not work (Word 2007), but
it works on OpenOffice >>

I just tested a mail merge with Word 2007 and it works fine.  Can you post
the steps that you're taking to do the mail merge ?  Also, if you could send
me the database catalog that you're using, that would help also.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I think I know what seems to be the problem. I enable "Large File Support" in my server. When this option is disabled everything is fine.

Marcin Banasik.

Marcin,

<< I think I know what seems to be the problem. I enable "Large File
Support" in my server. When this option is disabled everything is fine. >>

The Large File Support setting shouldn't affect this type of issue.   Is the
ElevateDB Server the only process accessing the database ?  And is the ODBC
Driver accessing the database directly, or through the ElevateDB Server ?

If you can give me a more thorough run-down of your configuration, it would
help immensely.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

This is what I do:
1. I recompile edbsrvr, give it new name, description (so service name is changed to) and change module libraries extension (from dll to edbdll because one of dlls I install with product caused handle leak if it was loaded and unloaded multiple times)
2. If I try to connect to my server from Word or Excel I get "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)" error in server log.
3. When I run orginal edbsrvr.exe and configure it to use the same database files everything works fine. So there must be something wrong in my server...

Marcin.

Tim,

Seems like there is no ODBC support when I compile server. Class TEDBODBCTables is not used in any module. It does not link to server.

I am compiling original edbsrvr project from RAD Studio (Delphi) 2007 2.03 build 13.

Marcin.