cvboucher
Posts: 191
|
Posted: 05/28/2015, 8:35 PM |
|
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
|
|
|
cvboucher
Posts: 191
|
Posted: 05/31/2015, 6:49 PM |
|
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
|
|
|
quasimidi
Posts: 151
|
Posted: 06/03/2015, 12:28 AM |
|
Hi,
Did you installed the latest Postgres ODBC driver?
http://www.postgresql.org/ftp/odbc/versions/msi/
Q.
_________________
RS |
|
|
cvboucher
Posts: 191
|
Posted: 06/03/2015, 9:24 AM |
|
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
|
|
|
vartron
Posts: 7
|
Posted: 06/30/2015, 11:25 PM |
|
Im in the same problem, can anyone help connect codecharg 5.1 to postgresql 9.x.
|
|
|
Oper
Posts: 1195
|
Posted: 07/01/2015, 7:01 AM |
|
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 |
|
|
cvboucher
Posts: 191
|
Posted: 07/01/2015, 8:44 AM |
|
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
|
|
|
Oper
Posts: 1195
|
Posted: 07/01/2015, 9:32 AM |
|
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 |
|
|
cvboucher
Posts: 191
|
Posted: 07/02/2015, 9:03 AM |
|
Oper,
I haven't tried the open source oledb provider. I'll give it a try and post my results.
Craig
|
|
|
rukl
Posts: 3
|
Posted: 07/11/2016, 9:00 AM |
|
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
|
|
|
cvboucher
Posts: 191
|
Posted: 07/11/2016, 10:06 AM |
|
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
|
|
|
MichaelMcDonald
Posts: 640
|
Posted: 07/14/2016, 11:51 PM |
|
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.
|
|
|
nlmunro
Posts: 6
|
Posted: 01/18/2018, 12:08 PM |
|
Old thread but for anyone still interested it works using OLD version of the official driver, I tried this one and it worked first time!
https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_00_0100.zip
(Windows 10 / CCS5)
|
|
|
nlmunro
Posts: 6
|
Posted: 01/18/2018, 12:09 PM |
|
-
|
|
|
nlmunro
Posts: 6
|
Posted: 01/18/2018, 12:11 PM |
|
-
|
|
|