.NET Forum

**andynewforest** · 05:24 PM

I'm making a very simple webpage to view data in a Postgres tbale. Having not done this belore with ASP.NET I'm taking it slowly and overcoming most problems. However I cannot work out what is going on here: I get this message:

SERVER ERROR
'PostgreSQL OLE DB Provider' failed with no error message available, result code: -2147221163(0x80040155).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: 'PostgreSQL OLE DB Provider' failed with no error message available, result code: -2147221163(0x80040155).

Source Error:

Line 11: sql="SELECT table_name FROM nfmd_master"
Line 12: dbcomm=New OleDbCommand(sql,dbconn)
Line 13: dbread=dbcomm.ExecuteReader()Line 14: nfmd_master.DataSource=dbread
Line 15: nfmd_master.DataBind()

Source File: G:\wwwroot\internettest\cat.aspx Line: 13

Stack Trace:

[OleDbException (0x80040155): 'PostgreSQL OLE DB Provider' failed with no error message available, result code: -2147221163(0x80040155).]
Microsoft.VisualBasic.CompilerServices.Container.I nvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) +202
Microsoft.VisualBasic.CompilerServices.NewLateBind ing.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) +275
ASP.cat_aspx.Page_Load() in G:\wwwroot\internettest\cat.aspx:13
System.Web.Util.CalliHelper.ArglessFunctionCaller( IntPtr fp, Object o) +8
System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +8668019
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

MY CODE IS

Code:

<%@ Page Language="VB" Debug="true" %> 
<%@ Import Namespace="System.Data.OleDb" %> 
<script runat="server"> 
sub Page_Load 
dim dbconn,sql,dbcomm,dbread,nfmd_master 
dbconn=New OleDbConnection("Provider=PostgreSQL OLE DB Provider;Data Source=localhost;location=gis;User ID=postgres;password=password;") 
dbconn.Open() 
sql="SELECT table_name FROM nfmd_master" 
dbcomm=New OleDbCommand(sql,dbconn) 
dbread=dbcomm.ExecuteReader() 
nfmd_master.DataSource=dbread 
nfmd_master.DataBind() 
dbread.Close() 
dbconn.Close() 
end sub 
</script> 

<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> 
<title>PostGIS Data Catalogue</title> </head> 
<body> 
<form runat="server"> 
<asp:Repeater id="nfmd" runat="server"> 
<HeaderTemplate> 
<table border="1" width="100%"> <tr> <th>table_name</th> </tr> </HeaderTemplate>  
<ItemTemplate> <tr> <td><%#Container.DataItem("table_name")%></td>  </tr> </ItemTemplate>  
<FooterTemplate> 
</table> </FooterTemplate>  </asp:Repeater> 
</form>   
</body> </html>

can anyone help?

Thanks
Andrew http://bytes.com/topic/net/answers/8...-executereader

can anyone help?

Thanks
Andrew
can anyone help?

Thanks
Andrew

**stbuchok** · 09-27-2010, 11:32 AM

I'm assuming the error you are getting has to do with your connection string.

Try the following:

On your desktop create a new file (a blank txt file). Rename it so that the extension is .udl

Once this is created, double click the icon. Use this to put in what provider, catalog, database, username, password... all the information to connect to your database. Click the test button. Once you have it working, open the file in notepad.

You now have the connection string you need in order to connect to your database.

Hope this helps.