Crystal Reports Database Connector Error

PEzechiels

Hi

I'm having trouble with the database connection.
Through ODBC i see all the tables in the Database Expert window but when i select a table i get the following error:

Database Connector Error: '22003:[Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]Out of range [Database Vendor Code: 1011]'

I tried the connection through Access and there i have no problems except with linking some tables and then i get a message that says:

'Cannot define field more than once'

This seems to be odd because in navision there's no way to define a field more than once.

Can anyone help me with these's issue's?

thnx in advance

Savatage

using sql?

http://www.mibuso.com/forum/viewtopic.php?t=11723

PEzechiels

Thnx Savatage....problem solved

ara3n

Ran into this problem at the client. Found the problem to be this.

Two different fields had the same caption!!!!!!!!!!!
Grrrrr.