Accessing more than one db?

Christian Lempereur · Post by **Christian Lempereur** » Tue Nov 09, 2004 9:14 am

I need to select data from 2 data bases.
Special filter > DataBase connection seems to only accept one database.
Any way it can be done in a single TextPipe filter?

thanks,

Christian

Post by **DataMystic Support** » Tue Nov 09, 2004 1:46 pm

Yes - you can create a connection using the Scripting filter. There is an example VBScript filter that connects to a database, creates a table, adds data and then drops the table. You can use this approach to create multiple table lookups.