postgresql

[rjpajaron]

But some of our apps is using Npgsql.

[Frank Müßner]

Hi there,
we use Postgres and XS2ADO and thus the normal data server

[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]

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 

 

[lumberjack]

Hi Juraj,

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

[Juraj]

Hi Johan

I sent a message from my email.

Juraj