Re: [h2] Re: H2 database and Excel VBA

2013-08-09 Thread Thomas Mueller
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

Re: [h2] Re: H2 database and Excel VBA

2013-08-05 Thread Kovács András
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:

Re: [h2] Re: H2 database and Excel VBA

2013-08-04 Thread Thomas Mueller
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 ender02meis...@gmail.comwrote: Hi all, im new to this topic and h2, do you know a good way to connect c# code to h2

[h2] Re: H2 database and Excel VBA

2013-08-02 Thread Kovács András
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 =

Re: [h2] Re: H2 database and Excel VBA

2013-06-03 Thread Ryan How
Have you got the pgserver running in H2 ? on Port 5432? From memory the default Postgres port default H2 pgserver port might be different... On 3/06/2013 10:41 AM, Balaji M wrote: Hi, When i try to connect through DSN less connection i am getting error pls help /Could not Connect to

Re: [h2] Re: H2 database and Excel VBA

2013-06-03 Thread Balaji M
Hi , I am new to the H2 ... For ODBC DSN connection by default the port no is 5435 ..it is working fine For ODBC DSN less Connection by default the port no is 5432.. How to check server is running in specific port ? Thanks Regards Balaji On Monday, June 3, 2013 3:00:13 PM UTC+8,

Re: [h2] Re: H2 database and Excel VBA

2013-06-03 Thread Ryan How
When you start the PGServer you can also set the port it is listening on. [-pgPort port]The port (default: 5435) On 3/06/2013 3:55 PM, Balaji M wrote: Hi , I am new to the H2 ... For ODBC DSN connection by default the port no is 5435 ..it is working fine For ODBC DSN less

Re: [h2] Re: H2 database and Excel VBA

2013-06-03 Thread Balaji M
Hi, Thanks, I have change the port it was working. Thx . Thanks Regards Balaji M On Monday, June 3, 2013 4:44:23 PM UTC+8, Kartweel wrote: When you start the PGServer you can also set the port it is listening on. [-pgPort port]The port (default: 5435) On 3/06/2013 3:55

[h2] Re: H2 database and Excel VBA

2013-06-02 Thread Balaji M
Hi, When i try to connect through DSN less connection i am getting error pls help *Could not Connect to the Server; No connection could be made because the target machinne actively refused it . [127.0.0.1:5432] * *Connection string*