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

P

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

  • err.PNG
    err.PNG
    8.8 KB · Views: 9
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?
 
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)
 
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.
 
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.
 
Stefan said:
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.
Click to expand...
Stefan said:
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.
Click to expand...
Can you elaborate it briefly.
 
You must log in or register to reply here.
Back
Top