ASP connection to SQL linked server

[jrichardson]

I am not really sure if an asp connection to a sql linked server is possible. The SQL server does not have a database itself but there is a linked server to the mainframe. Would I need to query the linked server first then create a connection to the query?

Thank you in advance for any help

[chrismartz]

Originally posted by jrichardson
Would I need to query the linked server first then create a connection to the query? sounds logical!....is the database on the mainframe an access db or sql?

[jrichardson]

The database on the mainframe is actually a unisys database. I am using a unisys ole db connection from sql.

Thanks

[chrismartz]

have you tried what you said above and gotten an error or are you looking for code to do this?

[jrichardson]

I am just not sure how to create the connection string