Connection pool needed?

From what I understand, some database drivers provide automatic database pooling, in the sense that when an application closes a connection, it is not dropped until after a certain timeout. If the same, or another application, request a connection then the "pooled" one is returned.

What's the situation with C#, .NET Compact Edition and SQLce? Is it a performance hit to open and close a connection, or is some kind of automatic pooling in effect?

Thanks.

Martin

SQL CE is a single user database, so I find that having a single connection during the lifetime of your application is best. There is some overhead in opening and closing connections.

Connection MSSQL with Oracle

Hai Pals:
I need a solution where I can access,Update values of MSSQL from Oracle and vice versa.
Could you provide a solution..
Take care
byeHello,

you can use ADBC to update datas from Oracle to MSSQL and vice versa.
Pls download http://www.alligatorsql.com/download/alligator.zip

If you need help, pls send an e-mail to m.peter@.alligatorsql.de

Best regards
Manfred Peter
Alligator Company Software GmbH
http://www.alligatorsql.com

Connecting to SQL Server from Unix

Has anyone tried to connect to a SQL Server 2K running on Windows 2000 from a unix machine? If so then could you provide me some help?
Thanks in advanceHave you tried sqsh for connecting to sql server from unix?|||Maybe the link http://www.algonet.se/~sommar/mssql/unix.html is helpful.