'PostgreSQL OLE DB Provider' failed with no error - dbread=dbcomm.E xecuteReader()

1 New Member

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(0x80 040155).
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.Ole Db.OleDbExcepti on: 'PostgreSQL OLE DB Provider' failed with no error message available, result code: -2147221163(0x80 040155).

Source Error:

Line 11: sql="SELECT table_name FROM nfmd_master"
Line 12: dbcomm=New OleDbCommand(sq l,dbconn)
Line 13: dbread=dbcomm.E xecuteReader()Line 14: nfmd_master.Dat aSource=dbread
Line 15: nfmd_master.Dat aBind()

Source File: G:\wwwroot\inte rnettest\cat.as px Line: 13

Stack Trace:

[OleDbException (0x80040155): 'PostgreSQL OLE DB Provider' failed with no error message available, result code: -2147221163(0x80 040155).]
Microsoft.Visua lBasic.Compiler Services.Contai ner.InvokeMetho d(Method TargetProcedure , Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) +202
Microsoft.Visua lBasic.Compiler Services.NewLat eBinding.LateGe t(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) +275
ASP.cat_aspx.Pa ge_Load() in G:\wwwroot\inte rnettest\cat.as px:13
System.Web.Util .CalliHelper.Ar glessFunctionCa ller(IntPtr fp, Object o) +8
System.Web.Util .CalliEventHand lerDelegateProx y.Callback(Obje ct sender, EventArgs e) +8668019
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +99
System.Web.UI.C ontrol.LoadRecu rsive() +50
System.Web.UI.P age.ProcessRequ estMain(Boolean includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +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>

can anyone help?

Thanks
Andrew

Sep 2 '10 #1

Subscribe Reply

1618

Similar topics

4613

Tables are skipped or export failed error occurs when upsizing MS Access to MS SQL Server

by: Bon | last post by:

Hello All I got "Tables are skipped or export failed" error when I used upsizing wizard on migrating MS Access 2000 to MS SQL Server 2000. I am changing my application backend database from MS Access 2000 to MS SQL Server 2000. My front end is MS Access interface. When I used the MS Access 2000's Upsizing Wizard for database migration, some tables cannot be migrated. The upsizing wizard report states some tables are "Tables are...

Microsoft SQL Server

1507

Crystal report with logon failed error

by: QZ | last post by:

This one happens once in while and I would appreciates any help that I can get. We have a webservice that generate pdf invoice files. We use dataset as our Source. i.e. we use SetDataSource(data); and data is a strong typed dataset. Everything works fine, we generate about 5000 invoices everymonth. But lately we have trouble with one account which happen to be the largest account. If I do a data.WriteXml("C:\\temp\\test.xml") the file size...

.NET Framework

3044

PostgreSQL query failed: ERROR: pg_atoi: zero-length string

by: shreedhar | last post by:

If I try to delete a record from my table which is giving following error Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in /xxx/database.inc on line 73 What might be the problem. Regards, Sreedhar Bhaskararaju

PostgreSQL Database

9233

WSAStartup failed: error code 10107

by: ralphdepping | last post by:

Trying to get moinmoin wiki working on Windows 2000 using IIS and python. I get the following error when trying to view the start page after insalling moinmoin and python - key error seems to be at the end related to socket.py (ImportError: WSAStartup failed: error code 10107). 10107 is "A system call that should never fail has failed"...which isn't very helpful. Any ideas what the problem may be? Thanks, Ralph

Python

1832

ODBC -- call failed ERROR with ms access and mysql

by: t0nt0n | last post by:

i have an xp OS service pack 2 currently working on a project that uses ms access 2003 with mysql 5.0 backend... i get an odbc--call failed error when I manually changed the system date in my computer.... I need to do this to test if my code works alright but instead the error occurs..... sometimes the error will not occur but often times it will.... i will have to relink the odbc connection to mysql because i cannot access the tables...

MySQL Database

1262

When im trying to update the records from mysql to postgresql, the connection error

by: rhepsi | last post by:

Dear All, Im vb.net 1.1, When im trying to update the records from mysql to postgresql, the connection error: the following code is Update data button click: Dim myPgrConnect As New NpgsqlConnection Dim myPgrCommand As New NpgsqlCommand

.NET Framework

2181

ASP form problem: Mailing Failed... Error is: FromAddress Property cannot be blank

by: jianxin9 | last post by:

Hi everyone, I don't have a lot of experience with ASP and I was hoping someone could help me. I want to use our ASP form along with some javascript code to create a form where our patrons can select which department they will send the form to (we are trying to consolidate forms). This is what I have so far, but when I test the form, I keep getting this error message: Mailing Failed... Error is: FromAddress Property cannot be blank. You...

ASP / Active Server Pages

6846

ODBC--call failed error when trying to view a report

by: kchang | last post by:

I am trying to view my reports based on a linked table database. However both the reports and the queries they're based on give me a "odbc--call failed" error. When I click on help it cites error 3146 and suggests that either the data source is on a network drive or that I am not connected to the network. I am not sure what either means but I am able to view the linked tables and access the database through data sources (ODBC) in administrative...

Microsoft Access / VBA

9208

Getting Error as : failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux)

by: aurekha | last post by:

Hi All, Im newbie to Perl. My problem is that, when i run my script, It is showing the error like "DBI connect('blah','blah',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at common.pl line 448" Here Im giving dependancies : Orcale Client-10.2.0 Perl - /usr/lib/perl5/5.8.8 Crypt::TripleDES -- 0.24

Perl

9643

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10147

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10081

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9946

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8968

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6735

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5378

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5511

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3643

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP