Page 1 of 1

Accessing more than one db?

Posted: Tue Nov 09, 2004 9:14 am
by Christian Lempereur
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

Posted: Tue Nov 09, 2004 1:46 pm
by DataMystic Support
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.