Connecting LinqPad to an AS400 linked server

tanner.dev

I have an AS400 linked server that I connect to through SQL Management Studio... LinqPad automatically configured ALL of the linked servers that are running SQl Server, but unfortunately left out my AS400 and a couple others. Can anyone assist me with the proper driver I need to download to connect to this remote server? Is connecting to this server even possible? Is there anyway to tap into the connection already made through Management Studio? Thank you in advance, any assistance would be greatly appreciated.

nescafe

You could create views for the tables you wish to access (e.g. in a dummy database solely for this purpose) which will appear in the object browser.

CREATE VIEW table1 AS
SELECT * FROM OPENQUERY(server1, 'SELECT * FROM dbo.table1')

or

CREATE VIEW table1 AS
SELECT * FROM server1.db1.dbo.table1