Stack Overflow
Stack Overflow

Questions tagged [data-connections]

116 questions
0
votes
0 answers

LINQ to SQL classes Data Base in c#

enter image description hereI have been created a data base by LINQ to sql classes .. the problem is when I make connection it in any project , the associations ( or the relations) between tables don't appear !! could the problem be in the data…
D.SH
  • 3
  • 3
0
votes
1 answer

Reading data from multiple data source type solution

I have some data in different data souses like SQL server, Oracle and even some from web service. I want to access them from my new application. Is there any data connector that can help me doing it without writing code for creating/changing data…
Ashkan S
  • 10,464
  • 6
  • 51
  • 80
0
votes
2 answers

Excel Data Connection returns no results via SMSS

I have no issues using Data Connections in Excel 2010 most of the time, but occasionally when I get external data via Microsoft Query (via SSMS), the query results will display fine in the GUI, but when I click export to Excel, The "Query from…
TWaller
  • 81
  • 1
  • 7
0
votes
1 answer

OLEDB change connection error 1004

I have done some investigation on this issue, but nothing works out. I am trying to change my PowerPivot connection. Im able to change Access source file, but on refresh it gives me an error, because the workbook(highlighted) connection string…
grechill
  • 1
  • 1
0
votes
1 answer

Communication Link Failure, caused by EOF: Can not read response from Server: (DB: MySql)

I browsed a lot about above exception, and got some doubt for one of the servers I' am looking into. I have Websphere Application Server 8 running with MySQL 5.5, all works fine. Until one day when the connections start failing on runtime and DB is…
simer
  • 23
  • 4
0
votes
1 answer

Datazen (excel on a network share as source for data)

I couldn’t find any other place where I could get support on Datazen. Maybe here I'll have some luck with this. I have a problem when I try to create Data connection from Datazen control panel, using option Excel Document in a network share. I tried…
ES59
  • 3
  • 2
0
votes
1 answer

Designate Excel Data Connection ReadOnly

I have an Excel file with a data connection to another Excel source which is referenced by several other reports. The data connection should be read only, but I cannot seem to setup the properties to do so - whenever the source file is open…
CJK
  • 99
  • 7
  • 20
0
votes
1 answer

Excel data sync fill down formulas every other

I have a data connection to a csv which fills out cells (A to N), I also have some basic formulas which run matches on that data (O to V).. the data I'm matching is grouped by every 2 rows. If I import the data I can manually duplicate the formulas…
8eecf0d2
  • 1,569
  • 1
  • 13
  • 23
0
votes
1 answer

Call Macro dynamically when cell value changed by formula

In Excel, through "Data connection", I am getting live data in cell A1. Using A1's value, I am doing some calculation on cell B1. If the value in B1 is TRUE, then that value should be copied to C1. I have so far been unable to achieve the desired…
user3744071
  • 165
  • 1
  • 1
  • 8
0
votes
1 answer

Create a data connection from MS Project Server to Excel 2007

Hi I have a Project plan which sits on MS Project Server. What would be the easiest way for me to create a data connection which isn't just a one time refresh from Project to Excel with the use of VBA? I could obviously take an extract manually each…
Vince
  • 33
  • 1
  • 2
  • 6
0
votes
1 answer

SpotFire 7 Add (OData) connection to standard data connections from plugin

We are developing a SpotFire 7 plugin. The functionality is adding a Wizard on top of creating a standard data source. We want to supply a dropdownlist to select a filter parameter for our source. The resulting mashup will be saved as library item…
JMan
  • 2,611
  • 3
  • 30
  • 51
0
votes
1 answer

In EF are add-migrations triggered by class changes or by the context interface?

MVC5, EF 6.0 Code First, SQL I have a remotely hosted MVC5 website using an SQL database. My objective is to easily code up to copy or copy/delete certain records out of the hosted database to a local database. So I added an additional context to…
Alan
  • 1,587
  • 3
  • 23
  • 43
0
votes
1 answer

Refreshing Excel Data connection on a Windows Server

I am running an automated Data job on a windows server that outputs a SAS dataset everyday. On top of this, I have an Excel Report connected via Excel's Local Data Provider. My problem is, that the Data Connection needs to be manually refreshed by a…
HermannHH
  • 1,732
  • 1
  • 27
  • 57
0
votes
1 answer

How to Query Large Sharepoint 2013 Lists in Infopath 2010?

I'm designing an Infopath form to help guide people in a data creation process. The form needs to draw from a Sharepoint list that contains around 19,000 rows, each with six columns that contain attributes (Column 1 = Attribute A, Column 2 =…
Lee Carver
  • 35
  • 1
  • 7
0
votes
5 answers

Connecting PHP to mySQL and retrieving data

i am new to PHP, and i am attempting to create a simple connection from html to mySQL using php. I met with some problems when running my codes. this is my code:
student15
  • 1
  • 1
  • 1
1 2 3 4 5 6
7
8