A database connection is the means by which a database server and its client software communicate with each other.

learn more… | top users | synonyms

0
votes
1answer
34 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
2answers
20 views

Establish ConnectionString using a list as a source

I have a field named "classes". I need to fetch data from the database and bind it to the classes field. But the requirement is, instead of using connection string directly I need to store the ...
1
vote
1answer
95 views

SharePoint 2013 app connected to PostgreSQL

I want to create an app for SharePoint 2013 (Foundation so far, soon to be paid version). I would love to include SP lists filled with data from sql query to PostgreSQL. Sounds easy, right? I am ...
0
votes
1answer
82 views

Business Connectivity Services vs. ADO.NET

Why should I prefer Business Connectivity Services (BCS) over plain ADO.NET, if all I want are simple CRUD operations on an external database (e.g. remote Oracle Database), which are made from a ...
3
votes
3answers
129 views

Where to store dynamic connection string in provider-hosted app?

I have a Sharepoint 2013 provider-hosted app that gets installed (along with a custom WCF Sharepoint-hosted service) using a powershell script. This script also creates a SQL Server database that the ...
0
votes
3answers
886 views

display data in SharePoint 2013 through ODBC

We are two students doing our internship (meaning we work with SharePoint 2013) in a company where they are already using SharePoint 2007, they want to implement what they have in SP2007 into SP2013. ...
1
vote
0answers
409 views

Access keeps losing connection to Sharepoint list

I'm setting up an Access 2010 database to have a table that is linked to a Sharepoint list, and I'm experiencing connectivity problems. Whenever I edit a record in the linked table, and then press ...
1
vote
0answers
56 views

How do I change SQL connection from one server to another on an an External list

I have an external list that points to SQL Server A. Server A is being de-commission and the database is moving to SQL Server B. I need to change my connection for my lists. I created a new ...
1
vote
1answer
396 views

Accessing Entity Framework from Timer Job: connection string problem

I had a DB that normally I access from my SharePoint (2010) custom feature by Entity Framework. The connection string is stored in the web.config. If I do something like that from outside TimerJob: ...
2
votes
1answer
444 views

InfoPath Form Works Under Admin Account But Not Under Regular User

An InfoPath browser enabled form that has udcx connections from a connection library, code in C# and some rules, was created and tested on the SharePoint server and functions more or less as designed ...
1
vote
1answer
526 views

Service accounts for database connection

We have a SharePoint web application with multiple site collections under that. We have built a new site which will be hosted under the same web application but in a new site collection. It has some ...
1
vote
1answer
680 views

SharePoint 2010 - Force to use non-1433 SQL Port

In my farm, I was using the standard 1433 port for SharePoint to communicate with SQL. Our project lead came down with the order to change the SQL port to a non-standard port from 1433. I went ...
1
vote
3answers
7k views

Moving the Sharepoint 2010 configuration Database to a new DB server..?

We were using the database server "OldDBServer" and have copied all the databases on the new database server "NewDBServer". Now, all the reference (like CA admin content DB, content DBs & Service ...
0
votes
1answer
226 views

Connecting to Access Database with Sharepoint

i'm trying to connect to an Access Database which is located on the desktop's server. I tried this : DatabaseAcces dbSAP = new DatabaseAcces(@"Provider=Microsoft.Jet.OLEDB.4.0;Data ...
0
votes
2answers
2k views

Cannot connect to the configuration database

I don't really know what to do. I was trying to get some bcs working, and because they were not, I've decided to restart the server. After it restarted I was unable to go on any site / page or on the ...
0
votes
2answers
255 views

How can I pass an argument to a FeatureReceiver during solution setup?

I have this Sharepoint 2010 solution containing 3 projects: Class Library with Model classes Class Library with LINQ to SQL data context Sharepoint 2010 project WCF REST service 3 Visual web parts ...
1
vote
1answer
2k views

PerformancePoint 2010: Could not add an Analysis Service Data source in the Dashboard Designer

Environment: SharePoint 2010 on Windows 2008 R2 Standard + SQL Server 2008 R2, Dashboard Designer I was successfully able to add a standard SQL Table as a data source and create a Scorecard Dashboard ...
1
vote
1answer
741 views

Looking up a value in SQL to set a value on the InfoPath Form

Looking up a value in SQL to set a value on the InfoPath Form. I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
2
votes
3answers
2k views

DB Planning: SQL Alias or CNAME Record?

When planning connectivity with the Database Tier, it's wise not to hard-code any specific database info into the SP client connection. I've gotten many recommendations to use SQL Alias on the client ...
1
vote
2answers
1k views

How to Bind Data to Traditional ASP.NET Controls in SharePoint Foundation 2010?

First off, my background is ASP.NET Web Forms. I'm sure this is very simple but I'm quite new to SharePoint. We're running SP Foundation 2010. I'm going to build a WebPart in VS.NET 2010 and deploy ...
0
votes
1answer
1k views

how can i get Web Analytics database name with Object Model?

First let me say, that all of we doing in sharepoint is base on the object model, so i can go to Central Administration and get my "Web Analytics Service Application" Database Name and Server Name, ...
1
vote
3answers
3k views

How to have settings per web part instance

We have developed a Sharepoint 2010 Visual Web Part. This web part adds some extra functionality to Sharepoint but depends on a custom database we've created to index some stuff in a scheduled job. ...
0
votes
1answer
891 views

Custom database access with impersonation in Sharepoint 2010

I'm building a custom application on Sharepoint 2010 that runs in an IIS virtual directory under a Sharepoint site (so it has access to SPContext and such which I need). My application (Asp.net MVC by ...