Devart Forums

Create a table with this script

CREATE TABLE test.actfile_billing_data
(
_rid serial NOT NULL,
_last_updated timestamp without time zone,
actnum character(7) NOT NULL,
xmldata character varying NOT NULL DEFAULT ''::character varying,
CONSTRAINT actfile_billing_data_pkey PRIMARY KEY (actnum),
CONSTRAINT actfile_billing_data_actnum_fkey FOREIGN KEY (actnum)
REFERENCES ars.actfile (actnum) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT actfile_billing_data__rid_key UNIQUE (_rid)
)
WITH (
OIDS=FALSE
);
ALTER TABLE test.actfile_billing_data OWNER TO postgres;
GRANT ALL ON TABLE test.actfile_billing_data TO postgres;


In a VB Windows Application project create a new class of type DataSet. Open this DataSet in design mode. Right click and add a TableAdapter. Select all columns in above table. Access the Advance Options window and make sure that the "Generate Insert, Update and Delete statements" checkbox is check. Click on Next. The Create Methods checkbox is unchecked and greyed out.

I am working in VS 2005 trying to add a table adapter with the Table Adapter Configuration Wizard. Everything works except that the Insert, Update and Delete methods are not being generated. I am doing a select statement from a single table. It looks like this:

SELECT _rid, created, person_type, address_type, isprimary, actnum, "name", address1, address2, city, "state", zip, geo_confidence, geo_latitude,
geo_longitude, agent_visibility, client_visible, status, owner_type, owner_id, verified, verified_by_type, verified_by_id, verified_datetime, "source",
notes, first_update_submitted, integration_id, _last_updated
FROM ars.actaddresses

This table does have a primary key (_rid).

I have tried every combination of the advanced options without success. This worked with version 4.55 of dotconnect but I had to upgrade to fix a Reporting Services issue and now I have this problem. Please advise.

Version of Postgres is 8.4
Version of dotConnect is 5.10.96.0.
Version of Visual Studio 2005 is 8.0.50727.762 (SP.050727-7600)
.NET Framework version is 2.0.50727 SP2
XP Professional version 2002 SP 3 (32 bit)

I am using the using the Professional version of dotConnect. The name of the download file is dcpostgres510pro.exe.

So should I have to register for Reporting Services manually or should the install do it? If I have to then what is the procedure?

Version of dotConnect is 5.10.96.0.
Version of Visual Studio 2005 is 8.0.50727.762 (SP.050727-7600)
.NET Framework version is 2.0.50727 SP2
XP Professional version 2002 SP 3 (32 bit)

I am using the using the Professional version of dotConnect. The name of the download file is dcpostgres510pro.exe.

I am trying to create a Report Server project. I have read the thread you referred to and attempted to follow the instructions therein. The odd thing is that is that with the previous version of dotConnect (4.55) that I had everything installed correctly, the only problem was that version of dotConnect didn't support parameters in Report Server.

I just purchased dotConnect for PostgreSQL version 5.10. I have installed and am now trying to use Reporting Services. However, I get this error when I try to open the data tab on an existing Reporting Services project (VS 2005), "The data extension Devart.Data.PostgresSQL was not found in the configuration file RSReportDesigner.config. Add the extension to the configuration file before proceeding or choose another data extension."

If I try to create a new Reporting Services project using the wizard. dotConnect for PostgreSQL is not found in the list of data source types.

What is the procedure for registering dotConnect for PostgreSQL? It worked earlier in version 4.65 (http://www.devart.com/forums/viewtopic. ... 54ef671894) except that the parameters didn't work, so I upgraded to version 5.10 to hopefully fix that problem.

Removing the schema name from the query produces the same result; Parameter 'xlegal' is missing.

I'm using dotconnect 4.55 with Postgres 8.3.

I have a query that looks like this:

SELECT actnum, lglnum, notenum
FROM mainschema.actfile
WHERE
(mainschema.actfile.lglnum = :xlegal)

xlegal is defined as a report parameter.

When I try to preview the report I get this error: Parameter 'xlegal' is missing.

I'm trying to use dotConnect with Reporting Services. It mostly works except that I can't figure out how to use a report parameter in a query. Does this work? If so how? I've created a parameter and then tried to reference it with @param and :param without success.