Navi3.7 C/ODBC problem: cannot find tablelist

Hi,

I am testing C/ODBC for Navi 3.7.

I installed it with I think mostly default settings:

Data Source: sc
Program Folder: C:\Program Files\Microsoft Business Solutions-Navision\Client
Connection: Local
Database Name: \Navi\fdb\helyesbit\helyesbit.fdb
Company Name: CRONUS Rt.
User ID: ODBC
Password: ODBC (tested)
Commit Cache: Yes
DBMS Cache: 1000
Enable BLOB Fields: Yes
Identifiers: azAZ09 (to play it safe)
Option Fields: Text
Query timeout: Yes and 120
Read-Only: No
TMP Path: C:\
Closing Date: Yes
Use Regional Decimal: No
Language: Auto

Now, when I try to open it in Excel 2003, it says table list cannot be read.

And when I try the following Perl program:


use Win32::ODBC;

my $DSN = "sc";
if (!(my $db = new Win32::ODBC($DSN))){
print "Error connecting to $DSN\n";
print "Error: " . Win32::ODBC::Error() . "\n";
exit;
}

my @list=$db->TableList;
print "Number of bloody tables: ";
print scalar @list;

it happily prints zero. It can connect to the datasource, as it does not say error connecting, but no tablelist. The datasource seems to be empty.

I tried to trifle with all the settings, language etc. I also tried it on a machine where I am sure there never was another version of Navi installed.

Any ideas?

thanxalot:

Miklos