Hi Guyzz. need your help. I have successfully setup an Oracle dataserver using DATA ADMINISTRATION --> DATESERVER --> ODBC UTILITIES. I have created a dataserver schema which primarily connect to Oracle tables. The setup was fine and yes I have accessed the Oracle tables necessary for my progress application. My concern is, since I have used a manual setup to connect to this oracle dataserver, how could i connect automatically using only a parameter file to setup the application connectivities. Basically during starp up I have used a parameter file called phi.pf to connect first to the two databases namely phisys01 and masters. After successfully connected I then tried to get connected to the dataserver manually by supplying the userid and password. The content of my parameter file is as follows.
-db phisys01 -H 192.0.0.0 -N tcp -S phisys -U user -P password
-db masters -H 192.0.0.0 -N tcp -S phimas
how should I include the connect statement for the dataserver in the parameter file?
when I have created the dataserver , i have used phisys01 as its schema holder. the logical name of my dataserver is BILLCARE. I have tried to include the syntax below but it failed connect.
phisys01 -db oradb -dt ORACLE -ld billcare -U user -P password
PLEASEEEEE NEED YOUR HELP.
THANKSSS
-db phisys01 -H 192.0.0.0 -N tcp -S phisys -U user -P password
-db masters -H 192.0.0.0 -N tcp -S phimas
how should I include the connect statement for the dataserver in the parameter file?
when I have created the dataserver , i have used phisys01 as its schema holder. the logical name of my dataserver is BILLCARE. I have tried to include the syntax below but it failed connect.
phisys01 -db oradb -dt ORACLE -ld billcare -U user -P password
PLEASEEEEE NEED YOUR HELP.
THANKSSS