SQL Data Server - ODBC error

[Sumitgupta74]

I'm using SQL Server as Dataserver and connecting it through ODBC connection from my .pf file. But it gives me error no. 1432 and 6142. It works fine in my development version while connecting through provision. Can any body tell me any reason? Thanks in advance.

 

[Unregistered]

Have you looked at the knoledge base?
Here are links to :

Error No: 6142
http://www.progress.com/services/su...y.p?kbid=21652&keywords=6142&wintype=kbwindow

Error No: 1432
http://www.progress.com/services/su...y.p?kbid=21410&keywords=1432&wintype=kbwindow

Both of these errors indicate a problem with your -H pram.

I currently have this setup and it works fine.

Here's what I did:

Host file: <Local host file that points to server>
200.200.220.2 flmiaa01nor

Services File:
pentgon 2288/tcp #SQL Service for Penagon2000 GDB_01_009
pentgon2 2298/tcp #SQL Service for Penagon2000 GDB_GBL_009

Icon Target String:
"C:\Program Files\Progress\bin\prowin32.exe" -pf m:\admin\pentagon.pf -basekey INI -ininame m:\admin\pentagon.ini -p menu\user-menu.w

Pentagon.pf File:
# PF-TYPE = R "Pentagon Run" no
#
# SESSION,Session-related parameters
-Bt 500
-n 70
-D 150
-TB 4
-TM 15
-inp 5000
-mmax 8192
-nb 255
-rand 2
#
# Company DB, sQL Holder for Schema Tables
-db F:\PROGRESS\DB\SQLHolder
-N TCP
-S 2244
-H flmiaa01nor
#
# Company DB, GDB_01_009, Actual Data
-db GDB_01_009
-dt MSS
-ld pent
-S pentagon
-H flmiaa01nor
-N TCP
-B 500
#
# Global DB, SQL Holder2 for Schema Tables
-db F:\PROGRESS\DB\sqlholder2
-N TCP
-S 2254
-H flmiaa01nor
#
# Global DB, GDB_GBL_009, Actual Data
-db GDB_GBL_009
-dt MSS
-ld pent2
-S pentagon
-H flmiaa01nor
-N TCP
-B 500

Hopefully this helps you,

Wayne
(305) 463-0455 Ext: 252