Appendix F2

assistantashamedΔιαχείριση Δεδομένων

29 Νοε 2012 (πριν από 4 χρόνια και 10 μήνες)

224 εμφανίσεις


F2
-
1




Delphi environment was used to generate the connection string. After creating a
TADOConnection object, the
provider

property was set to MSDASQL and the
connection string according to OLE DB guidelines was entered:

Provider=MSDASQL;DSN=PostgreSQL;UID=f
ts_user; PWD=***;
DATABASE=testdb;




After this the “connected” property was set to
true

and the user is prompted to enter the
username and password of the database in which they want to get connected (in this case
testdb). Once the connection is establ
ished the full connection string is generated. This
connection string is then used to establish the connection from the Wrapper to
PostgreSQL.


A
A
P
P
P
P
E
E
N
N
D
D
I
I
X
X


F
F
2
2
:
:


G
G
E
E
N
N
E
E
R
R
A
A
T
T
E
E


C
C
O
O
N
N
N
N
E
E
C
C
T
T
I
I
O
O
N
N


S
S
T
T
R
R
I
I
N
N
G
G



F2
-
2

In order to do this the Wrapper application is opened. From the “Servers” menu item on
the Wrapper main form sel
ect the option “Server Settings”. The following screen appears.





The + button at the top was pressed and the contents in the last row were entered. The
“Connection Type” selected was ADO and the “Connection Params” was the connection
string that was g
enerated in the previous step.