Visual LANSA Forum

HI

We have a LANSA WEB POC project for one of our customers. They are running an ERP system from Microsoft (C5).

The C5 Database is running in an MS SQL Server named LANSADEV\SQLS19L15 and the database is name C5SQLDB.

I have installed LANSA V15 (EPC150050) on the same MS SQL server, but it is named LANSADEV\LANSAC5 and the database is named LANSAC5

I am able to import the C5 tables into the LANSA IDE as an “Other” tables by pointing to the ODBC pointing to the CSQLDB, but when I run the WEB application it is not able to get any data and it fails.
How can I point from my LANSA WEB application running in the LANSADEV\LANSAC5 to get data from the C5SQLDB on the LANSADEV\SQLS19L15 ? Should I use the BIF - DEFINE_DB_SERVER
Or can I do something in the settings of the LANSA WEB?

Thanks

/klaus

Hi klaus, check if your default user that you use in the web administrator or your lansa iis configuration, it's also authorized to the other database in sql. Check the errors. Notice the lansa_users group authorized to your primary database