ODBC and SQL 7.0

[Ingark]

I try to do an import into FM 5.0v1 with ODBC driver from SQL 7.0.

When i come to the SQL Query dialog I have a little problem.

In the selected database there are several tables with the same name but with different database owner. In FM's Query dialog I get all the tables with the same name but I can't see the owner.

An example:

Database= Sales

Tables: Customer with owner Adm

and Customer with owner User

This shows in the Query as:

Customer

Customer

To get the Query to function I have to manually edit like this:

From: Select Customer.CustomerName

To: Select User.Customer.CstomerName

or else I get an error.

In MS Access the tables show as Adm.Customer and User.Customer.

Can anyone tell me if there is a workaround on this issue?

Ingar Karlsen

Norway

[iamme]

Ingar Karlsen,

I have seen this behavior myself. Just find out what

the order of the user table and use that one.

If you are seeing two Customer tables.

Customer

Customer

pick the one that is user.Customer and always use tables in that

order.

I don't believe you have to fully qualify the table name, do you?

i.e

Select

Customer.CustName,

Customer.CustAddress,

Order.OrderNumber,

Order.Price

Where

Customer.ID = Order.ID

Should work. At least it did in my case.

Dave