'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

1616

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

3042

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

2180

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

9589

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

9423

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10212

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9863

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

8872

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

7410

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5447

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

3962

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2815

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General