Info on Database Interface Designer needed

[mlapse]

Hi,

When a map accesses a DB (either input or output), do we always require the .mdq file to be present for the map to access it?

I have a problem where my map in production is trying to use the user id that I specified in test to log on to the DB. I have placed the prod user id and pwd in the mdq file in prod but it doesnt seem to be using that.

I also tried to pass the parameters to the map via the resource registry but still it seems to use the same id and pwd from the test environment.

Do I need to recompile the maps with the mdq from prod? What could be the reason for this error?

Thanks in advance

 

[janhes]

If you don't specify the database parameters (-dbname -mdq etc) in the Command part of the database card, the map uses the compiled in details from the DatabaseQueryFile parameters. This is why you get the test logon in production.