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

progress_gal

New Member
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.
 

Attachments

Stefan

Active Member
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

New Member
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

Curmudgeon
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

New Member
Yeah it work perfectly in local environment.
 

RealHeavyDude

Well-Known Member
Just guessing - are you blocked by a firewall?
 

progress_gal

New Member

Stefan

Active Member
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

New Member
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

Active Member
it?
 
Top