Hi,
If you want to connect to a H2 server over TCP/IP (assuming this is what
you want to do), then you do need a driver.
Regards,
Thomas
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]>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 h2-database...@**googlegroups.com.
>> To post to this group, send email to [email protected].
>> Visit this group at
>> http://groups.google.com/**group/h2-database<http://groups.google.com/group/h2-database>
>> .
>>
>> For more options, visit
>> https://groups.google.com/**groups/opt_out<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.
--
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.
