UniMetadata with SQLite and SQLServer.

adoniram · Post by **adoniram** » Fri 26 Feb 2010 18:06

I can attach another database to connected SQLite database, with attach command.

I can perform queries on it.

But if I try to retrieve meta datas with TuniMetadata, it fetch only connected database.

This error happens with sqlserver too.

How can I fetch information from another database under the same SQLite connection?

Dimon · Post by **Dimon** » Fri 05 Mar 2010 15:24

The point is that the SQLite server does not provide information about attached databases.
We are investigating this problem. As soon as we solve this question we will let you know.

adoniram · Post by **adoniram** » Fri 05 Mar 2010 21:13

thanks!!!

tobias_cd · Post by **tobias_cd** » Sat 06 Mar 2010 06:47

Adoniram: under SQL Server how do you switch the default database for subsequent Selects to another database without reconnecting? Do you call "USE xxx" as a SQL statement to switch? I haven't tried that myself, maybe you could confirm that, thanks.

adoniram · Post by **adoniram** » Sat 06 Mar 2010 14:10

Tobias,
I decide to work with schemas on SQLServer. Instead of spread tables among many databases, i will keep it on one database and put them on different schemas.
It solve my problem.

Thanks!