Re: [GENERAL] Npgsql - Where can I find Npgsql.NpgsqlServices

2013-12-12 Thread Francisco Figueiredo Jr.
On Thu, Dec 12, 2013 at 2:55 PM, Mike Christensen wrote: > Thanks! Got it working after messing around for a while.. > > Great! I'm glad to hear it. > I decided to check out EF for a new project I'm working on. So far, I > think I like NHibernate better. A lot more control, and works flawless

Re: [GENERAL] Npgsql - Where can I find Npgsql.NpgsqlServices

2013-12-12 Thread Mike Christensen
Thanks! Got it working after messing around for a while.. I decided to check out EF for a new project I'm working on. So far, I think I like NHibernate better. A lot more control, and works flawlessly with Postgres and Npgsql. Mike On Thu, Dec 12, 2013 at 8:34 AM, Francisco Figueiredo Jr.

Re: [GENERAL] Npgsql - Where can I find Npgsql.NpgsqlServices

2013-12-12 Thread Francisco Figueiredo Jr.
Hi, Mike. We are working to get EF6 properly supported and our master branch already has support for it. Unfortunately pgfoundry is down at the moment. Please, if you can compile Npgsql from source code, please get a current snapshot from github and give it a try: https://github.com/npgsql/Npgsql

[GENERAL] Npgsql - Where can I find Npgsql.NpgsqlServices

2013-12-11 Thread Mike Christensen
It seems I need NpgsqlServices to use Npgsql with EF6, however I can't figure out where you get this thing! I've tried installing it through NuGet: PM> Install-Package Npgsql -pre Installing 'Npgsql 2.0.14.1'. Successfully installed 'Npgsql 2.0.14.1'. Adding 'Npgsql 2.0.14.1' to EFTest. Successfu

[GENERAL] Npgsql Integrated Authentication Problem

2013-03-20 Thread ylu123
Hi; I have set up a windows domain trying to run Postgres client using SSPI. I've reached a point that I can use psql to login from my client machine without specifying username and password. But everytime I ran my .NET client program, I got following error messages. Any help is much appreciated!

[GENERAL] Npgsql Integrated Authentication Problem

2013-03-20 Thread ????
Hi; I have set up a windows domain trying to run Postgres client using SSPI. I've reached a point that I can use psql to login from my client machine without specifying username and password. But everytime I ran my .NET client program on a domain computer other than the database server itself,

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
Yes. It would not be advisable to do that but at least you could check you are able to use npgsql. The best way would to create a Web application and put your files there. I hope it helps. Em 26/11/2012 19:02, "Peter Kroon" escreveu: > >Do you have more than one .net installation? > Yes 2 and 4

Re: [GENERAL] Npgsql

2012-11-26 Thread Peter Kroon
>Do you have more than one .net installation? Yes 2 and 4. I've tried with both pools and get same result. >Also, can you try to add a bin folder in the root of your web app and put npgsql.dll and mono.security there? You mean create a folder called bin in: C:\inetpub\wwwroot ? 2012/11/26 Franci

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
Hm, this is very strange. Somehow your vb. Net isn't able to find npgsql in the gac. Do you have more than one .net installation? Also, can you try to add a bin folder in the root of your web app and put npgsql.dll and mono.security there? Sorry for not being very helpful. Em 26/11/2012 18:51

Re: [GENERAL] Npgsql

2012-11-26 Thread Peter Kroon
Installed as well. C:\Program Files\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools>gacutil -l mono.security Microsoft (R) .NET Global Assembly Cache Utility. Version 4.0.30319.17626 Copyright (c) Microsoft Corporation. All rights reserved. The Global Assembly Cache contains the following asse

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
Ok, and what about mono.security? Npgsql depends on it and it should be in the gac as well. Em 26/11/2012 18:36, "Peter Kroon" escreveu: > It appears to be installed. > > C:\Program Files\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools>gacutil > -l Npgsql > Microsoft (R) .NET Global Assembly Ca

Re: [GENERAL] Npgsql

2012-11-26 Thread Peter Kroon
It appears to be installed. C:\Program Files\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools>gacutil -l Npgsql Microsoft (R) .NET Global Assembly Cache Utility. Version 4.0.30319.17626 Copyright (c) Microsoft Corporation. All rights reserved. The Global Assembly Cache contains the following as

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
ct? >>> >>> >>>> ____ >>>> From: Peter Kroon >>>> To: "pgsql-general@postgresql.org" >>>> Sent: Friday, 23 November 2012, 18:13 >>>> Subject: [GENERAL] Npgsql >>

Re: [GENERAL] Npgsql

2012-11-26 Thread Peter Kroon
ng else. 2012/11/26 Glyn Astill > An actual error message would be useful, but did you add a reference to > the assembly in your project? > > > -- > *From:* Peter Kroon > *To:* "pgsql-general@postgresql.org" > *Sent:* Friday, 23 No

Re: [GENERAL] Npgsql

2012-11-26 Thread Glyn Astill
An actual error message would be useful, but did you add a reference to the assembly in your project? > > From: Peter Kroon >To: "pgsql-general@postgresql.org" >Sent: Friday, 23 November 2012, 18:13 >Subject: [GENERAL] Npgsql >

[GENERAL] Npgsql

2012-11-23 Thread Peter Kroon
I've installed Npgsql via Application stack builder without a problem(I guess, no error messages seen). http://npgsql.projects.pgfoundry.org/docs/manual/UserManual.html The projectpage tells me I have to add: <%@ Assembly name="System.Data" %> <%@ Assembly name="Npgsql" %> When I do this I get

[GENERAL] Npgsql 2.0.12 beta1 released!

2011-03-24 Thread Francisco Figueiredo Jr.
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta1 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org Thsi is the

Re: [GENERAL] Npgsql Exception

2010-08-23 Thread Mike Christensen
BTW, version is: 'PostgreSQL 8.3.4, compiled by Visual C++ build 1400' I don't have any such setting referenced in any .conf file. So I guess NHibernate tries to set this setting, assuming I have a more recent version of PG. If that's the case, it'll go away when I upgrade.. Mike On Mon, Aug

Re: [GENERAL] Npgsql Exception

2010-08-23 Thread Mike Christensen
Sounds good, I think I'll take Tom's advice.. Actually I'm planning on waiting for the 9.0 release to upgrade, so in theory that should just fix everything.. This only happens if I break on all exceptions, which I usually have turned off.. Thanks! Mike On Mon, Aug 23, 2010 at 11:56 AM, Francis

Re: [GENERAL] Npgsql Exception

2010-08-23 Thread Francisco Figueiredo Jr.
Whooops, I didn't check the message header... You can ignore my first question :) On Mon, Aug 23, 2010 at 15:56, Francisco Figueiredo Jr. wrote: > Are you using Npgsql with NHibernate? > > We added an option to send this command when starting a connection. > > But the setting is inside a try ca

Re: [GENERAL] Npgsql Exception

2010-08-23 Thread Francisco Figueiredo Jr.
Are you using Npgsql with NHibernate? We added an option to send this command when starting a connection. But the setting is inside a try catch error handler, so you aren't supposed to receive it. On my tests I couldn't reproduce the error. The only error we got about that was a user who had a b

Re: [GENERAL] Npgsql Exception

2010-08-23 Thread Tom Lane
Mike Christensen writes: > Sorry, when I had emailed the NHibernate DL the exception was in the > subject line. I forgot to copy the subject this time. The exception > is: > ERROR: 42704: unrecognized configuration parameter > "ssl_renegotiation_limit" ssl_renegotiation_limit is a server param

Re: [GENERAL] Npgsql Exception

2010-08-22 Thread Mike Christensen
Sorry, when I had emailed the NHibernate DL the exception was in the subject line. I forgot to copy the subject this time. The exception is: ERROR: 42704: unrecognized configuration parameter "ssl_renegotiation_limit" On Sun, Aug 22, 2010 at 8:54 PM, Mike Christensen wrote: > Hi all, this is

[GENERAL] Npgsql Exception

2010-08-22 Thread Mike Christensen
Hi all, this is really a NHibernate issue I believe, but I emailed their DL and all I got was crickets.. Lots and lots of crickets.. I get this error every time I start my app. It also appears in my SQL log files. I'm running Postgres 8.3.x. The exception occurs on this line of code: ISession

Re: [GENERAL] Npgsql connection string editor?

2010-02-24 Thread Francisco Figueiredo Jr.
Hi! This code is for initial design time support on VS.net 2003. We are still working to get vs.net 2005 design time support as the code to support it changed completely. Sorry for this confusion. I'll check the docs to clarify this. On Tue, Feb 23, 2010 at 17:00, Radcon Entec wrote: > Greeti

[GENERAL] Npgsql connection string editor?

2010-02-23 Thread Radcon Entec
Greetings! I have found references on the Internet to a connection string designer for npgsql, but I haven't found where to get it. I don't seem to have it with my download of npgsq. Or am I just looking in the wrong place? For example, http://npgsql.projects.postgresql.org/exampleprograms.htm

Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread Merlin Moncure
On Thu, Oct 15, 2009 at 4:14 PM, danclemson wrote: > > Thanks for the information. > > I did try the approach, but it failed due to any other issue with npgsql. > > The stored procedure returns a setof refcursor. > If I use "select * from test('e1':testEnum)", the command.ExecuteReader does > not

Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread danclemson
Thanks for the information. I did try the approach, but it failed due to any other issue with npgsql. The stored procedure returns a setof refcursor. If I use "select * from test('e1':testEnum)", the command.ExecuteReader does not return the datareader properly. The code errored out when I use t

Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread Merlin Moncure
On Thu, Oct 15, 2009 at 2:52 PM, William Temperley > I recently stopped using enums after reading this: > http://www.commandprompt.com/blogs/joshua_drake/2009/01/fk_check_enum_or_domain_that_is_the_question/ > Using a foreign key to a single column table is pretty much as fast as > an enum, is supp

Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread William Temperley
2009/10/15 Merlin Moncure : > On Thu, Oct 15, 2009 at 12:31 PM, danclemson wrote: >> >> Hi, >> >> As postgres now has enum type, does npgsql driver support the enum type? >> >> I use c# and npgsql as databse driver.  One of the database stored procedure >> takes enum as its parameter. >> >> What w

Re: [GENERAL] npgsql and postgres enum type

2009-10-15 Thread Merlin Moncure
On Thu, Oct 15, 2009 at 12:31 PM, danclemson wrote: > > Hi, > > As postgres now has enum type, does npgsql driver support the enum type? > > I use c# and npgsql as databse driver.  One of the database stored procedure > takes enum as its parameter. > > What will be the DbType for postgres enum typ

[GENERAL] npgsql and postgres enum type

2009-10-15 Thread danclemson
Hi, As postgres now has enum type, does npgsql driver support the enum type? I use c# and npgsql as databse driver. One of the database stored procedure takes enum as its parameter. What will be the DbType for postgres enum type? Thanks /dan -- View this message in context: http://www.nabb

Re: [GENERAL] Npgsql GUI problem C#.net

2007-08-29 Thread Hiroshi Saito
Message - From: "Jessie" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 28, 2007 4:04 AM Subject: [GENERAL] Npgsql GUI problem C#.net Hi all, I'm using C#.net 2005 dealing with Npgsql. I have a very newbie question about how to use the data received from the database. I

[GENERAL] Npgsql GUI problem C#.net

2007-08-29 Thread Jessie
Hi all, I'm using C#.net 2005 dealing with Npgsql. I have a very newbie question about how to use the data received from the database. I've already connected the database with the program and reading data from database works very well in the Console application. But in windows form application, I

[GENERAL] npgsql and standard_conforming_strings

2007-05-08 Thread William Garrison
I use npgsql 1.0 to access a PostgreSql 8.2.3 database. Recently, I decided to test with standard_conforming_strings = on and I noticed that npgsql still sends double-backslashes, which corrupts the data. This is especially bad with byte arrays: if I insert N bytes I get back 4*N bytes becaus

[GENERAL] Npgsql and 57014 query_canceled error message

2007-02-06 Thread Karen Hill
I'm doing some testing on a larger dataset, and I've started getting a 57014 error message when I catch an NpgsqlException. I thought it might be timing out on me, so in the connection string I've set the time out settings to the maximum of 1024 seconds before timeout. Has anyone else experienced