What I am missing while connecting ms sql database remotely in progress environment in linux platform

[progress_gal]

I have created database student in ms sql server management studio 2014, I want to connect this database remotely in linux environment. I have installed datadirect 7.1 in linux system. I had changed odbc.ini file and give sql server credentials. While i check this with running example i can query to the student database. But when I am trying to connect this datasource with progress by creating schemaholder i get error 'failed to connect ti mss database.(6142). please need help.

 

[Stefan]

You are running on Linux - I thought the DataServer process providing your schema holder needed to be on a Windows machine. How are you connecting to the schema holder? How are you connecting to the sql database?

 

[progress_gal]

I have created the datasource in window and started the broker in window proenv terminal by command ' proserve holder -H localhost -S 6001 -ServerType 4GL -n 200 -Mn 7 -Mi 3 -Ma 3 -Mpb 4'
and in linux proenv '_progres holder -H 10.0.1.167 -S 6001 -N tcp -db prodb1 -ld person -dt MSS -H 10.0.1.167 -S 1433 -N tcp -U sa -P P@ssw0rd' It gives me errorvthere is no server active for database holder on
-H 10.0.1.167 -S 6001. (704)

 

[TomBascom]

It will usually be easier to see the problem if you work in smaller steps.

Before you try connecting from a remote client first ensure that it works locally. If you have set it up correctly you ought to be able to connect from the windows box. If that does NOT work then the issue has nothing to do with the Linux configuration and that local issue will need to be resolved first.

 

[progress_gal]

Yeah it work perfectly in local environment.

 

[RealHeavyDude]

Just guessing - are you blocked by a firewall?

 

[Stefan]

You're following steps similar to Progress KB - How to create a MS SQL Server DataServer schema holder in UNIX? ?

 

[progress_gal]

Just guessing - are you blocked by a firewall?

No firewall is off.

 

[progress_gal]

You're following steps similar to Progress KB - How to create a MS SQL Server DataServer schema holder in UNIX? ?

yeah it works finally thanks.
Is it possible to connect mssql database without creating schemaholder?? Like in my .p file i can use statement like connect(mssql) and query in that point.

 

[Stefan]

Yes, but not as something known in the context of the progress client.

You would need to use some sql client library and call that, either using external procedure calls or os-command calls.

If you have an empty schema holder attached, then you can use send-sql-statement to pass all your sql queries through.

 

[progress_gal]

Yes, but not as something known in the context of the progress client.

You would need to use some sql client library and call that, either using external procedure calls or os-command calls.

If you have an empty schema holder attached, then you can use send-sql-statement to pass all your sql queries through.

Yes, but not as something known in the context of the progress client.

You would need to use some sql client library and call that, either using external procedure calls or os-command calls.

If you have an empty schema holder attached, then you can use send-sql-statement to pass all your sql queries through.

Can you elaborate it briefly.

 

[Stefan]

it?

 

[Stefan]

first google hits on site:documentation.progress.com:

1. os-command

or

2. send-sql-statement