Stack Overflow
Stack Overflow

Questions tagged [data-connections]

116 questions
2
votes
1 answer

How to get Internet Speed?

Currently, I am struggling to show the internet speed consistently in the status bar. What I am able to do is, finding the internet speed by the old approach(Upload & download some file from/to server and using TrafficStats API). I tried some of the…
hacker
  • 8,919
  • 12
  • 62
  • 108
2
votes
0 answers

Why does Excel crash when attempting to update a pivot table connection?

I have a pivot table attached to a table of 65 rows of data, 8 columns. I have added a slicer of 1 of the columns. When I attempt to update the pivot table connections to have the slicer control others Excel crashes. I am unable to add other…
t.mo
  • 253
  • 1
  • 4
  • 13
2
votes
0 answers

Adding Text Data Connection to Data Model with VBA

Wondering if there is a way to do this. I am looking to add multiple csv files to a single files data model. I have tried both the Listobjects method and query ables methods each seem to come just short of what I need. Listobjects successfully adds…
olavharald02
  • 21
  • 2
2
votes
1 answer

Cannot connect to Data, on Tableau Server, from Tableau Desktop

The client gave me a Tableau Server link, let's say, https://example.com. The aim is to connect tableau desktop to the data on this tableau server. But these weird things are happening - The link does not load in the browser with and without the…
Rohit Lodha
  • 43
  • 8
2
votes
1 answer

Change Data Connection to Read Only

I have a "summary" Excel workbook with pivots and data connections to other "data" workbooks. When refreshing the connection and a user is in the data workbook the refresh falls over saying it is read only. (It then tries to open the data…
Baseline9
  • 101
  • 1
  • 3
  • 12
2
votes
1 answer

Microsoft Query in Excel VBA - how to pass date filters

I am really hoping someone here could help me with the issue I have spent hours trying to fix with no result. I am trying to establish a data connection with a csv file using MS query in Excel VBA. I need to filter the data out from the csv file…
KMLN
  • 79
  • 2
  • 3
  • 14
2
votes
1 answer

Excel-to-Excel data connection gives limited SQL options

I'm mainly an Excel user and only dabble into the techie/programming sides of things when I need to, so assume I'm a bit of a newbie when it comes to all these data links, but: On a number of occasions, in Excel 2010, I have gone to Data -> From…
psymann
  • 137
  • 1
  • 10
2
votes
1 answer

How to open data roaming setting in dual sim android?

By this code: Intent i = new Intent(); i.setFlags(Intent.FLAG_ACTIVITY_NEW_TASK); i.setAction(android.provider.Settings.ACTION_DATA_ROAMING_SETTINGS); context.startActivity(i); I am able to open the data roaming setting activity successfully. Lets…
Tushar Monirul
  • 4,944
  • 9
  • 39
  • 49
2
votes
1 answer

SharePoint REST query SP.UserProfiles.PeopleManager

Is it possible to get data using REST query like below: http://moss.moss/_api/SP.UserProfiles.PeopleManager/GetPropertiesFor(accountName=@v)?@v='user_domain\user'&$filter=DirectReports And call by JavaScript. I would like to create script which…
stockDevelopers
  • 53
  • 1
  • 3
  • 8
2
votes
2 answers

editing odc file data connections in Excel to Stored proceedures

I'm migrating my data to a new server and therefore will have a new data source address, username and password. I can keep the username and password the same, but will have to have a new address. My issue is that I have about 20 Excel workbooks…
Mike
  • 537
  • 1
  • 8
  • 18
2
votes
1 answer

web.config connection string for Oracle Data Provider for .NET

Does anyone know the connection string for Oracle Data Provider for .NET for .NET 4.0 ? I have tried entering the Data Connection properties as a connection string and looking on connectionstrings.com. Neither seem to work. Thanks in advance.
wheatie
  • 31
  • 1
  • 5
2
votes
2 answers

Excel Table Data Connection Removes Cell Reference Upon Refresh

I have a Data Connection within my Excel Workbook (2007) which references a table within another Excel workbook. I have a cell that is referencing a date value within the last column header of the table. Each time the external workbook is updated…
B Hart
  • 1,108
  • 11
  • 20
1
vote
0 answers

Jaydebeapi.connect() from Databricks

I am able to read and write the data from databricks to Teradata but not able to run jaydebeapi.connect() funtion. import jaydebeapi jdbc_driver_loc…
Shobhit Jain
  • 21
  • 1
1
vote
0 answers

Is there a way to suppress the "Data connections have been blocked" warning in Excel when running a VBA macro from a Word document

I have a Word document (.dotm) with an embedded graph. When the document opens, I want to read data from a file on the local machine and add the data to the workbook associated with the embedded graph. However, when I open the file, I get the…
Andrew
  • 59
  • 5
1
vote
0 answers

Is it possible to create a new data connection without navigating server explorer manually?

I have a local database, and of course it works on other devices but they have to add the data connection that comes with the project themselves (image for reference): I'm in a position where I need to add a new data connection like WorkerLogin.mdf…
SpakyDaky
  • 21
  • 3
1
2
3 4 5 6 7 8