postgresql
postgresql
But some of our apps is using Npgsql.
-
- Posts: 280
- Joined: Sat Dec 12, 2015 2:22 pm
- Location: Germany
postgresql
Hi there,
we use Postgres and XS2ADO and thus the normal data server
we use Postgres and XS2ADO and thus the normal data server
postgresql
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
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
-
- Posts: 280
- Joined: Sat Dec 12, 2015 2:22 pm
- Location: Germany
postgresql
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
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
- Posts: 726
- Joined: Fri Sep 25, 2015 3:11 pm
- Location: South Africa
postgresql
Hi Juraj,
johan(dot)nel(at)xsinet(dot)co(dot)za
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.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.
johan(dot)nel(at)xsinet(dot)co(dot)za
______________________
Johan Nel
Boshof, South Africa
Johan Nel
Boshof, South Africa
postgresql
Hi Johan
I sent a message from my email.
Juraj
I sent a message from my email.
Juraj