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:
Expand|Select|Wrap|Line Numbers
- <%@ 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>
Thanks
Andrew