Nope. I dont use any driver. I thought c# can handle it, because i also
tried now with tcp connection. I set up a local database as server, and
want to conect to it local as client. It should go... but it doesnt work.
Do i need a driver for it? i cant avoid that?
my connection string:
"metadata=res://{0}/{1}LocalDatabase.csdl|" +
"res://{0}/{1}LocalDatabase.ssdl|" +
"res://{0}/{1}LocalDatabase.msl; " +
"provider=System.Data.SqlClient;" +
"provider connection string=\"Data
Source=tcp:localhost;Initial Catalog=Localdatabase;" +
"User ID=admin;Password=1234;"+
"Persist Security Info=false\";";
On Sunday, August 4, 2013 8:41:05 PM UTC+2, Thomas Mueller wrote:
>
> Hi,
>
> Are you using the PostgreSQL ODBC driver?
>
> > Should i use it throught tcp
>
> Yes, it would need to be TCP/IP.
>
> Regards,
> Thomas
>
>
>
> On Fri, Aug 2, 2013 at 5:18 PM, Kovács András
> <[email protected]<javascript:>
> > wrote:
>
>> Hi all, im new to this topic and h2, do you know a good way to connect c#
>> code to h2 database?
>>>
>>> I would like to use it together with an entity data model. My connection
>> string looks like this:
>>
>> protected const string ConnectionFormatString =
>> "metadata=res://{0}/{1}LocalDatabase.csdl|" +
>> "res://{0}/{1}LocalDatabase.ssdl|" +
>> "res://{0}/{1}LocalDatabase.msl; " +
>> "provider=System.Data.SqlClient;" +
>> "provider connection string=\"Data
>> Source=Localdatabase.h2.db;" +
>> "User ID=admin;Password=1234;"+
>> "Persist Security Info=false\";";
>>
>> I get the error: provider: Named Pipes Provider, error: 40
>> Do you have any idea perhaps? Should i use it throught tcp, or just the
>> local file? I tried many things, and none of them works yet.
>> thx in advance!
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> Visit this group at http://groups.google.com/group/h2-database.
>>
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
