CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Unable to create PostgreSQL Connection

Print topic Send  topic

Author Message
cvboucher

Posts: 187
Posted: 05/28/2015, 8:35 PM Quote message

ASP.Net InMotion C# (Also tried this in a PHP project)

I've been looking at PostgreSQL as an alternative to Sql Server and so far I'm really impressed with it. Only problem is I'm unable to create a usable database connection in CCS. When creating the connection if I just select an ODBC Data Source Name, I can create the connection but none of the tables show up in any of the builder dropdowns. If I change the Data Source Type to SQL, I can manually type in a SQL statement (like select * from customers) and all of the columns will show up.

When I try to create a database connection by building a connection string, I get the following error:



Is anyone using PostgreSQL and if so how did you create a connection? What am I doing wrong? It looks like PostgreSQL should be supported since it is one of the databases in the Add New Connection Database drop down.

Thanks,
Craig
View profile  Send private message
cvboucher

Posts: 187
Posted: 05/31/2015, 6:49 PM Quote message

Update: My first attempt at using the PostgreSQL database was in CCS5. I created a new project in CCS4 using the PostgreSQL database and it worked great. So this tells me it's a bug in CCS5. Anyone else out there have any CCS5 projects using the PostgreSQL database?

Thanks,
Craig
View profile  Send private message
quasimidi


Posts: 151
Posted: 06/03/2015, 12:28 AM Quote message

Hi,

Did you installed the latest Postgres ODBC driver?

http://www.postgresql.org/ftp/odbc/versions/msi/

Q.
_________________
RS
View profile  Send private message
cvboucher

Posts: 187
Posted: 06/03/2015, 9:24 AM Quote message

Hi Q,

Thanks for responding. Yes, I installed the latest drivers. I also tried some ODBC drivers from Devart.com (https://www.devart.com/odbc/postgresql/) and those didn't work either. I tried this on two different machines.

What I did get working was a PostgreSQL OLEDB provider from PGNP (http://www.pgoledb.com/). I'm using the trial version because the retail version is $320. Then in the database connection on the Server tab, I uncheck Same as Design and select "Use Custom Provider" and set it to the Npgsql driver. I don't like the idea of using trial software so I'd like to get the ODBC driver working.

Are you using PostgreSQL in CCS5?

Thanks,
Craig
View profile  Send private message
vartron


Posts: 7
Posted: 06/30/2015, 11:25 PM Quote message

Im in the same problem, can anyone help connect codecharg 5.1 to postgresql 9.x.
View profile  Send private message
Oper


Posts: 1174
Posted: 07/01/2015, 7:01 AM Quote message

Happened same thing to us in MySQL for ASP
DNS Less , OLEDB dont work in CCS5 unless you use a valid NetProvider
(For Design Mode)

Install 32bit Driver and 64bitDriver (D/R)

Did you try creating a DSN connection this way:

c:\Windows\SysWOW64\odbcad32.exe <------ CCS5 use 32bit ODBC Creator

go to system DSN / Add / Look for your Driver / Add Parameter and Name

now should appear in CCS5


in CCS4 we use ODBC and DSN-Less for Design and RunTime
in CCS5 we use System DSN for Design and ODBC/String for runtime

give a try





_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message
cvboucher

Posts: 187
Posted: 07/01/2015, 8:44 AM Quote message

Hey Vartron,

Download and install the trial PGNP OLEDB providers for postgreSQL, desktop edition from http://www.pgoledb.com. There's a pop up nag once a day but it doesn't look like they time out.

Oper,

Yes, I tried the 32 bit version of the ODBC drivers. Both the delivered and Devart ODBC drivers but still no luck. I can see my DSN and select it, but anywhere I'm supposed to get a list of tables, it's empty.

Thanks,
Craig
View profile  Send private message
Oper


Posts: 1174
Posted: 07/01/2015, 9:32 AM Quote message

ok I see, and the Pay version is expensive.


Did you try another Postgress OLDB Providers?

http://sourceforge.net/projects/pmpostgresqlole/

http://www.postgresql.org/ftp/odbc/versions/msi/


if not you will have to buy the connector :(
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message
cvboucher

Posts: 187
Posted: 07/02/2015, 9:03 AM Quote message

Oper,

I haven't tried the open source oledb provider. I'll give it a try and post my results.

Craig
View profile  Send private message
rukl

Posts: 3
Posted: 07/11/2016, 9:00 AM Quote message

Hello,
is there any solution available for this deccribed, still existing problem. Connection to the database ist sucessfull, but there are no tables visisble.

Best regards
Ruediger
View profile  Send private message
cvboucher

Posts: 187
Posted: 07/11/2016, 10:06 AM Quote message

I've been using this driver in CCS.

http://www.pgoledb.com/

The free version has a nag screen once a day but it doesn't time out. I then use the Devart driver for the web application. These are my settings on the Server tab of the connection properties window:

Same as design: unchecked

Connection String: Server=localhost; Port=5432; Pooling=True; Database=dvl; UID=postgres; PWD=*********; Unicode=true
Note: the Unicode=true is needed if you need to display foreign language characters (Japanese in my case). The Devart documentation says the driver is a little slower when this parameter is set to true.

Use custom provider: Selected.

Name: Devart Data Provider
Invariant: Devart.Data.PostgreSql-local
Type: Devart.Data.PostgreSql.PgSqlProviderFactory, Devart.Data.PostgreSql, Version=7.4.616.0, Culture=neutral, PublicKeyToken=09af7300eec23701

There's a free NPGSQL driver (http://www.npgsql.org/) but I was unable to get the provider configuration figured out.

HTH,
Craig
View profile  Send private message
MichaelMcDonald

Posts: 584
Posted: 07/14/2016, 11:51 PM Quote message

Hi All,

I don't have experience with PostgreSQL but what I do know is if you install an ODBC driver and configure it to work on a PC, you can find find the DSN/ODBC config in the Windows registry and save that key as a registry file and simply save it into the registry of another pc and it will work as long as the driver is also installed on that other pc.
_________________
Central Coast, NSW, Australia.

Use the EXETA Online Business Valuation Tool to
value your business.

www.exeta.com.au
View profile  Send private message

Add new topic Reply to topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.