Tag Info

New answers tagged

0

you can write web service for sql connection and deploy to sharepoint app pool in iis. then in infopath you can connect to this webservice. if you want you can pass parameters to webservice or get data from sql with webservice to infopath whatever you want.


0

Go to regedit.exe, browse HKLM_Local_Machine/Software/Microsoft/Shared Tools/Web Server Extensions/14.0/WSS/. Then change the value of attribute named ServerRole from SINGLESERVER to APPLICATION. But in windows 8.1 please watch HKLM_Local_Machine/Software/Microsoft/Shared Tools/Web Server Extensions/**14.0**/WSS/


0

If you already setup the ECT and List then you need to follow the steps mentioned in the below blog. Creating InfoPath Forms that Save to SQL Server Database Populate Data From SharePoint List to a SQL Table


0

You mention both SPD and source code? With code, it would be a custom web part or SharePoint app (aka add-in), which are both developer tasks. But this can be done with SPD with no code. Just set up an "external content type". Here's one tutorial, but there are many others: https://msdn.microsoft.com/en-us/library/office/ee557243%28v=office.14%29.aspx ...


0

I believe the easier option is to use External Content Type (Which points to SQL table) and use it to create External List. In this case you don't need to develop anything. After creating External List you can customize the forms.


0

The "proper" way to do this is with Business Connectivity Services (BCS). BCS can be a bit heavy handed if your needs are for a periodic one way sync of a single list. Does it have to be real-time? The path of least resistance would be a scheduled SSIS package leveraging the SharePoint List Connector available here: ...


0

This is not really the best approach to post the data to SQL via infopath. I would suggest to follow the below create a web service which internally connects to SQL server. Consume that service and post to the service in infopath. reference link Create a BCS external list and then modify the forms using infopath with required rules and submit the ...


1

There is a rough way to see which database is in use running the query sp_who which outputs (among other things) loginame, hostname and dbname. You will find the connections to all databases in this sql server instance. If you save the query to a file, you can easily import it to excel to filter its content.


0

You shouldn't be querying SharePoint databases directly, no matter what data you want to get. More info: Here and here


2

I recommend using SQL Server Reporting Services (SSRS) as it supports displaying data in charts, and integrates with SharePoint. Install SSRS in SharePoint integrated mode, details Create SSRS reports that connect to your DB, details NOTE! You don't need to use Visual Studio to create the reports, the Report Builder works just fine and is easier as you ...


5

If you want to split your site collection into multiple Content DB and then spread those DB across both SQL server. then it is Big NO You can not have a site collection in to Multiple database, it is not supported. If you want multiple SQL server attached to a farm, then you can do it. It is supported. we have 4 SQL server attach to one farm due to ...


1

There are two ALIAS which can be configured - for 32 and 64 bit. Make sure you have both and try again.


0

I was going to comment first, but I don't have enough reputation yet. Yes according to your link it is not supported. Only SSRS 2012 SP1 add in is supported for sharepoint 2013. https://msdn.microsoft.com/en-us/library/gg492257(v=sql.110).aspx However depending on the version of your SSRS instance and if it is in native or integrated mode it might be ...



Top 50 recent answers are included