PDA

View Full Version : No connections through ODBC or sql server


CGibson
2013-07-16, 15:01
Hello,
I have been following the tutorials and I've been accessing data from Southwind without any issue.

Testing the connection through the ODBC manager, I receive the following message


No connection could be made because the target machine actively refused it.


In addition, starting the sql server manager service yields the following message


Service state was not set.


Any suggestions on what I need to do to get both of the above tests to complete successfully?

Thanks,
Cory
davefoss
2013-07-16, 15:11
Hello,
I have been following the tutorials and I've been accessing data from Southwind without any issue.

Testing the connection through the ODBC manager, I receive the following message


In addition, starting the sql server manager service yields the following message


Any suggestions on what I need to do to get both of the above tests to complete successfully?

Thanks,
Cory

Hi Cory, it sounds like you may not have the latest version of the Lianja SQL Server. Can you verify that you have the July 11 build installed.
CGibson
2013-07-16, 15:20
Thanks for the response Dave.
I did not know that there was an updated version. I will install the newest version and try again.
davefoss
2013-07-16, 15:24
Thanks for the response Dave.
I did not know that there was an updated version. I will install the newest version and try again.

No problem at all. Get in touch if that doesn't fix it for you.
CGibson
2013-07-16, 15:27
As a side note, if I click "Uninstall Lianja SQL Server" from the start menu, it provides the following message: "Do you want to uninstall Lianja App Builder and all of its modules?"
davefoss
2013-07-16, 15:43
As a side note, if I click "Uninstall Lianja SQL Server" from the start menu, it provides the following message: "Do you want to uninstall Lianja App Builder and all of its modules?"

Thanks, that's a known issue that we expect to be resolved in the next release. A temporary way to work around it is to double click the uninstall.exe in the C:\Lianja\sqlserver\ directory directly.
CGibson
2013-07-17, 07:38
uninstall and install of the new version worked. ODBC connection is successful and the sql server is running.
Thank you.
barrymavin
2013-07-26, 19:04
And that was fixed in RC7.