Messages posted by: ron_l

Thanks Justin

Hi Guys,

I recently downloaded and installed the latest PostgreSQL Plus installer and tried it on my PC.

This is the first time that I wasn't able to connect to the update server. My connection is working fine and the firewall is off.

Is there a problem with the Update Server?

Thanks

Yup, can you guys teach me how to compile the source code using MS C++? so that i could contribute a x64 bit driver

Thanks

PLEASE HELP!!!!

I need a 64 bit driver for Windows

Is upgrading into x64 system. SQL Server 2005 x64 is using Our POSTGRESQL server to connect via a linked server. But it could not see the x86 drivers.

Please help on the x64 drivers.... Were could I get a fully tested one.

PLEASE HELP!!!

Hi there,

I would like to know what I software and other components that I need to download and how to configure them in order to compile the ODBC driver.

Thanks

Hi Guys!

I would like to ask if it's possible for us to wrap the existing enterprisedb installer into another one so we could automatically fill in the username, password, port number etc during the installation just to prevent the user from messing up the database system. And for security purposes too.

Thanks alot!

More power to you guys

Thanks man!

Hi Guys!

I'm me again!

I would like to ask if EDBDataProvider.dll is 100% compatible with PostgreSQL 8.3.

I was using Npgsql before but unforunately when doing debugging is always ask for the source code.

I never encountered this when using EDBDataProvider when connecting into EnterpriseDB Advanced SErver.

Please help!

Thanks

Where can I get the 8.3 version? Thanks

Hi Deepa_G,

That's a good thing that you were able to decide.

Glad we could help!

Hi Muhammad,

My EnterpriseDB is version 8.2.9.18 and my .NET connector is version 8.2.4.12

Good day guys,

I hit a wall with the EDBDataReader.

i have a table FACT_CDR

CREATE TABLE "public"."fact_cdr" (
"cdr_date" date,
"cdr_time" time without time zone,
"cdr_duration" character varying(10),
"cdr_condition_code" character varying(5),
"cdr_codedial" character varying(5),
"cdr_codeused" character varying(5),
"cdr_intrkcode" character varying(5),
"cdr_dialed_numner" character varying(25),
"cdr_calling_number" character varying(25),
"cdr_account_code" character varying(15),
"cdr_authorizarion_code" character varying(15),
"cdr_incrtid" character varying(5),
"cdr_outcrtid" character varying(5),
"cdr_vdn" character varying(25),
"costing_date" date,
"costing_time" time without time zone,
"costing_duration" integer,
"costing_condition_codename" character varying(50),
"costing_department_extension" character varying(50),
"costing_department_authorization_code" character varying(50),
"costing_extension_user" character varying(50),
"costing_authorization_code_user" character varying(50),
"costing_incoming_provider" character varying(50),
"costing_outgoing_provider" character varying(50),
"costing_destination_code" character varying(50),
"costing_callgroup_name" character varying(50),
"costing_calltype_name" character varying(50),
"costing_country_name" character varying(50),
"costing_area_name" character varying(50),
"costing_rate_name" character varying(50),
"costing_cost" numeric(32,2));
)

sample data

cdr_date cdr_time cdr_duration cdr_condition_code cdr_codedial cdr_codeused cdr_intrkcode cdr_dialed_numner cdr_calling_number cdr_account_code cdr_authorizarion_code cdr_incrtid cdr_outcrtid
2008-08-18 10:29:00 00024 7 0 #001 07065633081 9381 022
2008-08-18 10:30:00 00002 G #055 9381 7065633081 001
2008-08-18 10:31:00 00119 9 #055 9381 7065633081 001
2008-08-18 10:33:00 00014 H #055 9614 9021556587 001
2008-08-18 10:37:00 00017 G #001 29002 08066130726 001
2008-08-18 10:38:00 00034 9 #001 2002 08066130726 001
2008-08-18 10:38:00 00043 G #001 29002 09083484737 002
2008-08-18 10:38:00 00001 G #001 29002 0443884011 001
2008-08-18 10:39:00 00017 7 0 #001 08066130726 9373 004
2008-08-18 10:39:00 00100 9 #001 2002 0443884011 001
2008-08-18 10:40:00 00508 7 0 #001 09077100419 2392 003
2008-08-18 10:42:00 00313 9 #001 2002 09083484737 002
2008-08-18 10:42:00 00826 7 0 #001 54708811 9687 023
2008-08-18 10:45:00 00321 7 0 #001 09027364026 9385 005
2008-08-18 10:45:00 00009 G #001 29002 08013932871 001
2008-08-18 10:46:00 00038 9 #001 2002 08013932871 001
2008-08-18 10:48:00 00002 7 0 #001 01085381184494# 9788 012
2008-08-18 10:48:00 00057 7 0 #001 09021556587 9614 011
2008-08-18 10:49:00 00011 7 0 #001 09027364026 9385 013
2008-08-18 10:50:00 00501 7 0 #001 52516564 9620 007
2008-08-18 10:51:00 00008 G #001 29010 0456515508 001
2008-08-18 10:52:00 00008 G #001 29002 08066130726 002
2008-08-18 10:53:00 00325 7 0 #001 09083484737 9614 015
2008-08-18 10:53:00 00018 9 #001 2002 08066130726 002
2008-08-18 10:58:00 00538 9 #001 9622 08066130726 002
2008-08-18 11:00:00 00921 9 #001 2010 0456515508 001
2008-08-18 11:00:00 00535 7 0 #001 45604518 9620 017
2008-08-18 11:02:00 00952 7 0 #001 010862162884762# 2392 016
2008-08-18 11:03:00 00018 7 0 #001 35601786 9614 022
2008-08-18 11:04:00 00002 G #001 9643 0362738653 001
2008-08-18 11:05:00 00006 G #055 29010 456514784 001

my VB.NET code is as follows

myEDBCommand.CommandText = "SELECT * FROM dump_cdr"
myEDBDataReader = myEDBCommand.ExecuteReader()

when the records in the table is relatively small like 10 the code above doesn't any issue

but when the records go large like say 250 - 500 the EDBDataReader appears to hang

the line myEDBDataReader = myEDBCommand.ExecuteReader() never finishes

so what i did as a work around is this

myEDBCommand.CommandText = "SELECT * FROM dump_cdr WHERE cdr_idx < " + myDumpIdx.ToString
myEDBDataReader = myEDBCommand.ExecuteReader()

I would like to know why does the EDBDataReader suffers from this. Is this a limitation?

Regards,

Ron Limson

I forgot to mention for reporting you can go for Crystal Reports it works great for .NET. for Java go for Jasper Reports

I would suggest if your going to use .NET then use what language makes you comfortable to work because ultimately any .NET code boils down to a single machine code. If you want more difficult programming go for Java.

Good day guys,

I hit a wall with the EDBDataReader.

i have a table FACT_CDR

CREATE TABLE "public"."fact_cdr" (
"cdr_date" date,
"cdr_time" time without time zone,
"cdr_duration" character varying(10),
"cdr_condition_code" character varying(5),
"cdr_codedial" character varying(5),
"cdr_codeused" character varying(5),
"cdr_intrkcode" character varying(5),
"cdr_dialed_numner" character varying(25),
"cdr_calling_number" character varying(25),
"cdr_account_code" character varying(15),
"cdr_authorizarion_code" character varying(15),
"cdr_incrtid" character varying(5),
"cdr_outcrtid" character varying(5),
"cdr_vdn" character varying(25),
"costing_date" date,
"costing_time" time without time zone,
"costing_duration" integer,
"costing_condition_codename" character varying(50),
"costing_department_extension" character varying(50),
"costing_department_authorization_code" character varying(50),
"costing_extension_user" character varying(50),
"costing_authorization_code_user" character varying(50),
"costing_incoming_provider" character varying(50),
"costing_outgoing_provider" character varying(50),
"costing_destination_code" character varying(50),
"costing_callgroup_name" character varying(50),
"costing_calltype_name" character varying(50),
"costing_country_name" character varying(50),
"costing_area_name" character varying(50),
"costing_rate_name" character varying(50),
"costing_cost" numeric(32,2));
)

sample data

cdr_date cdr_time cdr_duration cdr_condition_code cdr_codedial cdr_codeused cdr_intrkcode cdr_dialed_numner cdr_calling_number cdr_account_code cdr_authorizarion_code cdr_incrtid cdr_outcrtid
2008-08-18 10:29:00 00024 7 0 #001 07065633081 9381 022
2008-08-18 10:30:00 00002 G #055 9381 7065633081 001
2008-08-18 10:31:00 00119 9 #055 9381 7065633081 001
2008-08-18 10:33:00 00014 H #055 9614 9021556587 001
2008-08-18 10:37:00 00017 G #001 29002 08066130726 001
2008-08-18 10:38:00 00034 9 #001 2002 08066130726 001
2008-08-18 10:38:00 00043 G #001 29002 09083484737 002
2008-08-18 10:38:00 00001 G #001 29002 0443884011 001
2008-08-18 10:39:00 00017 7 0 #001 08066130726 9373 004
2008-08-18 10:39:00 00100 9 #001 2002 0443884011 001
2008-08-18 10:40:00 00508 7 0 #001 09077100419 2392 003
2008-08-18 10:42:00 00313 9 #001 2002 09083484737 002
2008-08-18 10:42:00 00826 7 0 #001 54708811 9687 023
2008-08-18 10:45:00 00321 7 0 #001 09027364026 9385 005
2008-08-18 10:45:00 00009 G #001 29002 08013932871 001
2008-08-18 10:46:00 00038 9 #001 2002 08013932871 001
2008-08-18 10:48:00 00002 7 0 #001 01085381184494# 9788 012
2008-08-18 10:48:00 00057 7 0 #001 09021556587 9614 011
2008-08-18 10:49:00 00011 7 0 #001 09027364026 9385 013
2008-08-18 10:50:00 00501 7 0 #001 52516564 9620 007
2008-08-18 10:51:00 00008 G #001 29010 0456515508 001
2008-08-18 10:52:00 00008 G #001 29002 08066130726 002
2008-08-18 10:53:00 00325 7 0 #001 09083484737 9614 015
2008-08-18 10:53:00 00018 9 #001 2002 08066130726 002
2008-08-18 10:58:00 00538 9 #001 9622 08066130726 002
2008-08-18 11:00:00 00921 9 #001 2010 0456515508 001
2008-08-18 11:00:00 00535 7 0 #001 45604518 9620 017
2008-08-18 11:02:00 00952 7 0 #001 010862162884762# 2392 016
2008-08-18 11:03:00 00018 7 0 #001 35601786 9614 022
2008-08-18 11:04:00 00002 G #001 9643 0362738653 001
2008-08-18 11:05:00 00006 G #055 29010 456514784 001

my VB.NET code is as follows

myEDBCommand.CommandText = "SELECT * FROM dump_cdr"
myEDBDataReader = myEDBCommand.ExecuteReader()

when the records in the table is relatively small like 10 the code above doesn't any issue

but when the records go large like say 250 - 500 the EDBDataReader appears to hang

the line myEDBDataReader = myEDBCommand.ExecuteReader() never finishes

so what i did as a work around is this

myEDBCommand.CommandText = "SELECT * FROM dump_cdr WHERE cdr_idx < " + myDumpIdx.ToString
myEDBDataReader = myEDBCommand.ExecuteReader()

I would like to know why does the EDBDataReader suffers from this. Is this a limitation?

Regards,

Ron Limson

Hi Ashaar,

Thanks for the reply.

I didn't noticed that part of the manual.

Regards,

Ron Limson

Hi Muhammad,

I was looking for error codes and their meanings like Error Code "23505" for Duplicate Items and so on.

I couldn't find such info in the EnterpriseDB Manual

Regards,

Ron Limson

Hello,

I would like to ask if there is any available manual for the EnterpriseDB .NET Connector

So I could easily identify the usage of each class like EnterpriseDB Connector and so on.

Regards,

Ron Limson

Hi Ashaar,

Thanks for the reply.

I tried interchanging the two files; the old and the new and found no issues.

I believe that the file is used for JDBC connectivity. Since I am using VB.NET I have not encountered any problems.

Regards,

Ron Limson

Hi Guys!

Any updates on this one?

Thanks

Hi ashaar,

I am using Windows XP Sp3 32-bit.

Regards,

Ron Limson

Hi

Yes this happens every installation. It occurs when the installation reaches 96% or so.

This was a fresh install so the folders does not exist.

Here is what I think is happening:

- during the course of the installation the folder C:\EnterpriseDB\8.2\devstudio\lib was created
- the files are written
- then before the installation finishes at 96% the installer is trying to put the file jtds-1.2.jar into that directory.

I hope this helps.

Hi,

The file that was detected was jtds-1.2.jar in C:\EnterpriseDB\8.2\devstudio\lib

What I did this time was backedup the existing jtds-1.2.jar file into a folder then choose replace with older version during the installation.

Atleast I will be able to restore the newer one just in case there are any side effects from using the older version.

Regards,

Ron Limson

Hi Ashaar,

Thanks for the reply.

I will do another installation of EnterpriseDB in another machine.

I'll post the screenshot here as soon as I have it available.

Regards,

Ron Limson

Hello,

It's been a while since I last installed my EnterpriseDB and I noticed that before the installation finishes it asked me that a certain file already exist and is newer that the file that I am trying to install.

Weird because this was a fresh install. So what I did is just click 'no' so that the newer file will not be replaced.

Was there an issue if I replaced the file with the older one?

By the way the Online Update for EnterpriseDB is cool!

Keep it up guys!

More power!

Regards,

Ron Limson