Just tried lucee express. Although it didnt run out of the box (had to manually set JAVA_HOME) its really nice. However i am having really a bad time in setting up a datasource to mssql. My sql server lives on another machine on the same lan as my pc from where i tried lucee. Firewalls on both sides totally disabled. I can connect to mssql through ms sql studio with no issues. Still lucee cannot verify connection.
Any tips to further try?
Thanks
george
As AJ mentioned…
(Yes, it’s an old Coldfusion post, but still very relevant)On Wednesday, January 20, 2016 at 10:56:58 AM UTC+11, Geo Geo wrote:
Just tried lucee express. Although it didnt run out of the box (had to
manually set JAVA_HOME) its really nice. However i am having really a bad
time in setting up a datasource to mssql. My sql server lives on another
machine on the same lan as my pc from where i tried lucee. Firewalls on
both sides totally disabled. I can connect to mssql through ms sql studio
with no issues. Still lucee cannot verify connection.Any tips to further try?
Thanks
george
it might have to do with TCP connections being allowed/enabled on the ms
sql serverOn 20 January 2016 at 07:33, Geo Geo <@Geo_Geo> wrote:
Just tried lucee express. Although it didnt run out of the box (had to
manually set JAVA_HOME) its really nice. However i am having really a bad
time in setting up a datasource to mssql. My sql server lives on another
machine on the same lan as my pc from where i tried lucee. Firewalls on
both sides totally disabled. I can connect to mssql through ms sql studio
with no issues. Still lucee cannot verify connection.Any tips to further try?
Thanks
george–
Love Lucee? Become a supporter and be part of the Lucee project today! -
http://lucee.org/supporters/become-a-supporter.htmlYou received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/2410e258-8ee6-4858-ab51-bf54c98c1f1e%40googlegroups.com
.
For more options, visit https://groups.google.com/d/optout.
–
AJ Mercer
<webonix:net strength=“Industrial” /> http://webonix.net | <webonix:org
community=“Open” /> http://webonix.org
http://twitter.com/webonix
This is an issue with Lucee, I’m out of the office atm, will post detail tomorrow. You need to manually set the data source connection string.
The jdbc driver that ships with Lucee is not compatible with sqlServer 2012 and above. Microsoft changed the class namespaces for the jdbc4 drivers for these editions of mssql. I always have to select ‘other jdbc’ and manually enter the class and connection string.
I found the solution to this. It’s not a Lucee issue - it’s my issue, I
guess 
it appears that I never added the SQL port (1433) into the IPALL at the SQL
Configuration tool … what’s weird though is that my SQL Studio was still
able to connect, but I guess it was figuring another method to achieve this
(named pipes?)
Anyway, I am glad that Lucee worked for me. I have even ported an ACF
project into it and it’s 100% compatible not even any fine tuning was
required - though it was really a very simple project.
GioOn Wednesday, January 20, 2016 at 1:56:58 AM UTC+2, Geo Geo wrote:
Just tried lucee express. Although it didnt run out of the box (had to
manually set JAVA_HOME) its really nice. However i am having really a bad
time in setting up a datasource to mssql. My sql server lives on another
machine on the same lan as my pc from where i tried lucee. Firewalls on
both sides totally disabled. I can connect to mssql through ms sql studio
with no issues. Still lucee cannot verify connection.Any tips to further try?
Thanks
george