Jump to content

SQL connection error - or can I use web services


bjarni

Recommended Posts

Hello, I would like to push and retrieve data to and from the the internet directly from my Unistream. 

I tried to connect to a server  on Amazon, a working database (MSSQL) we are using in another project.  But when doing a simple query I get error:

"20009 Unable to connect to data source  Unable to connect: Adaptive server is unavailable or does not exists"

image.thumb.png.52dabb8d4d82cafeec1ec8509d9af4c9.png

Anyone here who could give me a hint on what I need to do?

The Database is set up as "SQL Server" with IP-number and instance name,  database name, user name and password.

Another question is if I can use other kind of web services to handle my data ?

Thanks, 

Bjarni Gudmundsson

 

 

 

Link to comment
Share on other sites

On 2/21/2020 at 11:37 AM, Patko said:

Hello, is it definitely a type of SQL database - SQL Server? You try to change the SQL type to MYSQL and specify a port. Also check IP, name, password ...

THanks for the input Patko.  It's a MSSQL database I'm using and I´ve tried both with one located on an Amazon server as one on my local net.

Link to comment
Share on other sites

  • 4 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

This site uses cookies. By clicking I accept, you agree to their use.