Dynamic link to Mas 90?

[CoderMan1]

Ive tried a couple techniques to create a linked server on the fly to a MAS90 database but all of them seem to hang (waiting for you to choose the company/login Im guessing)

I am able to create a linked server to a DSN that has the login information inside of it, but when I create one with a full connection string it doesnt work:

SELECT *
FROM OPENDATASOURCE(
'MSDASQL',
'DSN=SOTAMAS90;Company=I00;UID=7AB|I00;PWD=;Directory=\\HoRNE2\MAS200\MAS90;'
)...GL5_DetailPosting

OLE DB provider "MSDASQL" for linked server "(null)" returned an invalid index definition for table "GL5_DetailPosting".

Any other methods just seem to hang endlessly..as I said before I think its probly prompting for the login info in a window thats hidden.

Has anyone got this to work?

 

[BigLouie]

If you can make a silent DSN work why keep trying to use the SOTAMAS DSN? Also on Sage Talk they tell you that the way to go is with a silent DSN. Why keep trying a way that does not work for you if you have one that does work.

 

[CoderMan1]

Because I am traversing through all databases that we have on MAS90. And we have 2500 of them, I dont want to create 2500 DSNs

 

[BigLouie]

You have 2500 companies setup in MAS? You only need one per company so by saying you would need to create 2500 DSN you are saying you have 2500 companies set up. Is this correct?

 

[CoderMan1]

Correct