Hi, Thanks Jiri. That was fast!! :)
Well System.Data.SQLClient works both ways. Here it is a sample using SQLClient: <add name="pubsConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\pubs.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> This is directly from Microsoft Corporate Web Site Template, downloaded from MSDN. <add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|sampledb.mdf" providerName="System.Data.SqlClient"/> This one is from another sample project and also works fine. Luis Madaleno -----Mensagem original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Em nome de Jiri Cincura Enviada: terça-feira, 22 de Julho de 2008 10:59 Para: For users and developers of the Firebird .NET providers Assunto: Re: [Firebird-net-provider] ConnectionString and |DataDirectory| Hello guys, it's fixed now. The connection string is untouched (to be able to copy it in (internal) code etc. without problems), only during asking for database value is expanded. You can grab it from http://netprovider.cincura.net, feel free to comment any problems. BTW is there any concensus about the syntax - should it be "|DataDirectory|\something" or "|DataDirectory|something"? On MSDN it's with slash, google found also some without. For this time it's implemented as the first example, but can be easily changed to checked whether the |DataDirectory| is followed by slash or backslash (or just simply Path.DirectorySeparatorChar). Luis, I've added item to tracker [http://tracker.firebirdsql.org/browse/DNET-168], I hope the user I've chosen as reporter is you. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
