0
votes
1answer
43 views

Populate field in a form depending on value on another from database in SP2010

I have a List with three fields, all three text boxes. The first field is an ID, which when populated needs to trigger a DB query to pull corresponding title and description from a table in SQL Server ...
0
votes
1answer
60 views

SharePoint Designer SQL Server Connections, Connection Strings

Forgive me as I am new to SP Dev. I have a DB server that I use RDP to connect to via VPN from a local laptop. I know the name of the DB server. The DB (SQL Server 2008) is set up to use Windows ...
0
votes
0answers
17 views

Creating a BCS conectivity with Sharepoint Designer 2010 with MS SQL server 2005 (Externall Table)

When I tryied this Link and Connect with server 2005 : http://kowalski.ms/2010/07/20/sharepoint-server-2010-supplementing-user-profile-imports-using-bcs/ Get a lot of errors with tables(No One ...
1
vote
0answers
338 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...
1
vote
2answers
90 views

How can i retreive data from Web Server to my Intranet SP site

Would you please let us know the steps to connect a external Web Service that has specific attribute (GetAttributeProductsByID , GetAttributeProductsByName ... etc ) with an Intranet Sharepoint site ...
1
vote
1answer
84 views

SQL Server 2008 Installation on SP 2010

I'm installing SP 2010 on Virtual Machine Windows Server 2008 R2. My Question: Is it necessary to install SQL Server 2008 (or R2) before installing Sharepoint Server 2010? Plus, when installing SQL ...
1
vote
2answers
2k views

SharePoint Business Connectivity Services (BCS) Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I am running SharePoint 2010 with SQL 2012, I am trying to get Business Connectivity Services (BCS) running but I am facing a double-hope authentication issue. Every time I try to connect to the ...
0
votes
1answer
434 views

View SQL data from CRM into Sharepoint 2010 BCS failing

I'm trying to view CRM Customer data from the SQL database in SharePoint so that I can use it in surveys etc. I followed these instructions (amongst others) ...
0
votes
3answers
1k views

Dataview Web part and SQL - Way to use trusted connection?

As I'm sure you're already aware one of the biggest weaknesses of the data view web part is that it exposes connection strings for SQL Server connections. Instead of using a web service to pass my ...
1
vote
0answers
126 views

Dataview Web Part only works when pulling 110 lines or less of SQL

I recently started playing with the data view web part in SharePoint Designer. I've added a new data source and added a custom query. Unfortunately my queries appear to be limited to returning 110 ...
0
votes
1answer
797 views

How do I link (join) a sharepoint list and an external data source in a DVWP?

I've got an external data source (SQL Server) and a Sharepoint Custom List that I want to join in a single view using the data view web part. In theory this shouldn't be too hard, but I can't get it ...
0
votes
1answer
189 views

How do I get sorting to work in the DVWP when using custom SQL query to linked server?

WSS 3.0 I have a non-SQL database linked to a SQL database. I've created a datasource in SPD using a custom query to this database. select * from LINKEDDB...sometable I then created a data view ...
1
vote
1answer
492 views

SharePoint Dropdown Vaue not updating in to Dataview webpart with SQL backend

I have a data view webpart and its source is a sql server database table(2005). I have the data view setup to be able to edit some of the fields inside the dataview. Instead of providing the user ...