postgresql

This forum is meant for questions and discussions about the X# language and tools
User avatar
rjpajaron
Posts: 364
Joined: Fri Nov 06, 2015 12:01 am

postgresql

Post by rjpajaron »

But some of our apps is using Npgsql.
Frank Müßner
Posts: 280
Joined: Sat Dec 12, 2015 2:22 pm
Location: Germany

postgresql

Post by Frank Müßner »

Hi there,
we use Postgres and XS2ADO and thus the normal data server
User avatar
rjpajaron
Posts: 364
Joined: Fri Nov 06, 2015 12:01 am

postgresql

Post by rjpajaron »

Hello Frank,

I want to know more.

My initial email on this to Robert, he told me XS2Ado is just a X# ported from VO2Ado.

It is not ADO.NET. So, my question, how do you connect to PostgreSQL?
1. It is via OLEDB/ODBC driver something that comes with Windows?
2. Or something else.

Thanks anyway for the info,

--

Rene
Frank Müßner
Posts: 280
Joined: Sat Dec 12, 2015 2:22 pm
Location: Germany

postgresql

Post by Frank Müßner »

Hello Rene,
my old VO Code use XS2ADO with the ODBC Driver:

InitConnection := MyAdoConnection{}       
InitConnection:ConnectionTimeout := 5
InitConnection:CommandTimeout:=720
InitConnection:CursorLocation := adUseClient
InitConnection:ConnectionString:="Provider=MSDASQL.1;DRIVER=PostgreSQL Unicode;DATABASE=postgres;SERVER="+Server+";PORT="+port+";UID="+user+";PWD="+pw+";B9=0"
InitConnection:Open(nil,nil,nil,nil)  
oServer := MyAdoserver{"Select * from Table", InitConnection,adOpenKeyset,adlockoptimistic,nil}

And for new Code i use Npgsql Functions. 

Frank 

 
User avatar
lumberjack
Posts: 727
Joined: Fri Sep 25, 2015 3:11 pm
Location: South Africa

postgresql

Post by lumberjack »

Hi Juraj,
FFF wrote:Hi Juraj,
for PG ask Johan Nel, i think he uses it from the beginning... IIRC, Wolfgang R. also has it in production for some time.
Sorry for late reply was a couple of days (week) without internet connection. Please send me a private mail, I will have to get pieces of code out of Assemblies,but I do have examples of using PG with both direct Npgsql and DbProviderFactories (Database Agnostic) interfaces. Just need to extract the crucial bits since most of it is in Data-driven classes.

johan(dot)nel(at)xsinet(dot)co(dot)za
______________________
Johan Nel
Boshof, South Africa
Juraj
Posts: 161
Joined: Mon Jan 09, 2017 7:00 am

postgresql

Post by Juraj »

Hi Johan

I sent a message from my email.

Juraj
Post Reply