What is the connect string for mssql express supposed to be? there are a lot of conversations around the topic!
Also tried this:
http://docs.day.com/en/home/communique_4/cq42/setup/configuration/dtd_reference/database_connections...
<datasource
name = "systemDataSource"
driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"
url = "jdbc:microsoft:sqlserver://pasadena:1433"
user="cqdbo"
password="cqpwd">
</datasource>
It finds the datasource but cannot connect in thr jdbc DriveManager.class.
The mysql datasource is working fine!
I generated the OSGI plugin for mssql jdbc4 from Eclipse luna, installed it in the console datasources and bundles. I also opened up tcp/ip for mssql and connect from eclipse.
Thanks
Solved! Go to Solution.
Views
Replies
Total Likes
Please refer to this Adobe Community article to learn how to inject a DataSourcePool to connect to a database :
https://helpx.adobe.com/experience-manager/using/datasourcepool.html
Now to connect to another database - replace the configuration shown in this article with required configuraton. To connect to MS SQL Server- see:
https://www.connectionstrings.com/sql-server/
Also - make sure that you package up the Driver file too.
Views
Replies
Total Likes
Please refer to this Adobe Community article to learn how to inject a DataSourcePool to connect to a database :
https://helpx.adobe.com/experience-manager/using/datasourcepool.html
Now to connect to another database - replace the configuration shown in this article with required configuraton. To connect to MS SQL Server- see:
https://www.connectionstrings.com/sql-server/
Also - make sure that you package up the Driver file too.
Views
Replies
Total Likes