Mapping Load and Applymap error

[#1]

Cannot open file 'C:\Users\User\Desktop\Northwind.dbo.Customers' The system cannot find the file specified.

Customers:
MAPPING LOAD
CustomerID,
CompanyName
FROM Northwind.dbo.Customers

Hi All,

I am getting above error. Please help.

Customers:
 MAPPING LOAD
 CustomerID,
 CompanyName
 FROM Northwind.dbo.Customers;
 
 Orders:
 LOAD *,
 ApplyMap('Customers', CustomerID, 'N/A') AS CompanyName
 FROM Northwind.dbo.Orders;
 
 EXIT Script;

[Anonymous]

There might be a problem with the connection string.

[robert_mika]

Go to this Folder

C:\Users\User\Desktop\Northwind.dbo.Customers

and check if your database is still there.

[jonathandienst]

Hi

I think you are missing the connection string to the Northwind database, so QV is assuming this is a file. Also, you will need a SQL SELECT rather than just a LOAD to retrieve data from a database.

HTH

Jonathan