Search DaniWeb - npgsql

How to have more than one set of data for NPGSQL prep statement in VB .Net? 5 Years Ago by imBaCodes … parameters in my vb .net code for prepared statements of npgsql. Dim xConn As NpgsqlConnection = ConnectDB() Dim xCmd As NpgsqlCommand = xConn… error . > A first chance exception of type 'Npgsql.NpgsqlException' occurred in Npgsql.dll >ERROR: 08P01: bind message has 34193 parameter… Re: How to have more than one set of data for NPGSQL prep statement in VB .Net? 5 Years Ago by rproffitt This may be too rare. That is I read the NPGSQL forum closed 3 years ago at https://groups.google.com/forum/#!forum/npgsql-help I'm sure if it wasn't specific to NPGSQL you may have heard something but why did they shutter the forum? How to disconnect database in ASP.NET 11 Years Ago by varoluscu_prens … System.Collections.Generic; using System.Data; using System.Drawing; using Npgsql; public partial class _08_Veritabanlari_AD0_NET_select_data_2 : System.Web.UI.Page { public _08_Veritabanlari_AD0_NET_select_data_2… Re: How do you connect to a sql database using C# 16 Years Ago by PoovenM … access to a postGres database. I've tried to use Npgsql but I get an error with the Mono.Security.dll… Re: PostGis plugin 14 Years Ago by zortec You can use the NPGSQL library or ODBC. This article will explain the process: [url]http://www.codeproject.com/KB/database/afppostgresqlintro.aspx[/url] Re: How to have more than one set of data for NPGSQL prep statement in VB .Net? 5 Years Ago by imBaCodes OMG! no one wants to bother! thanks anyways. :( Re: How to disconnect database in ASP.NET 11 Years Ago by varoluscu_prens It seems I can not depict the problem properly: The button in aspx file, in which id is "*closeConnect*" is connected to the *disconnectFromDatabase* doesn't work. It is expected to disconnect, but it is failed to disconnect. Re: How to disconnect database in ASP.NET 11 Years Ago by nakor77 You shouldn't be trying to leave a connection open like that. You should close the connection in the same request in which it was opened. Also I doubt Your static variables will work quite like you want. ASP.net is a multi threaded environment which means you could still have multiple instances of those static variables, one for each thread that … Re: How to disconnect database in ASP.NET 11 Years Ago by varoluscu_prens Hi Cherryhomesj; Thank you for your reply. > You shouldn't be trying to leave a connection open like that. You should close the connection in the same request in which it was opened. How can I handle this? Where can I get information? Re: How to disconnect database in ASP.NET 11 Years Ago by nakor77 just move your code to close the connection to the end of the request where you open the connection. your code should follow the basic format of open connection perform work in database close connection