Questions tagged [data-connections]
116 questions
12
votes
5 answers
Auto-updating Power Query Connection via VBA
I have a Power Query set in myexcel.xlsx. I set its connections's properties as
this and this.
I wrote a VBA code like the following
Sub UpdateData()
Dim filename As String
Dim wbResults As Workbook
filename = "C:\myexcel.xlsx"
Set…
Salim
- 121
- 1
- 1
- 4
9
votes
1 answer
Where to define the maximum number of connections in Postgres?
I want to limit the number of users per database in a multi tenant environment. But there are three levels of max connections and I should be grateful for any advice.
Level 1 Entire Server
By editing the config for Postgresql I can set the Max…
sibert
- 1,968
- 8
- 33
- 57
6
votes
3 answers
How to import data into Excel without automatic connections?
I know this might be a simple question but is there an easier way to import a CSV into Excel without it automatically generating a data connection?
I know you can do it by:
Importing the csv then deleting the connections
Opening the csv and copying…
user1529403
- 71
- 1
- 1
- 4
5
votes
3 answers
Why doesn't OR designer let me drag tables to design surface?
I have a database hosted at somee.com
I have added a new connection in Server Explorer in VS 2012 and the test connection was successful. I can also successfully see the tables in the SE and any changes made to the database from the admin panel @…
user1705923
4
votes
1 answer
Spotfire connection to mysql?
I am trying to find a way to connect to mysql database with spotfire but I can only find the connector for sql server and oracle. I am using spotfire cloud. If someone can help thanks.
Jonathan
- 43
- 6
4
votes
1 answer
How to use mobile wifi and data connection simultaneously for different purposes in android app
I am working on a research task and I need to use wifi and mobile data connection simultaneously for different tasks in an Android app. Is it possible? if yes then how? Any suggestions for work-around are also appreciated.
Kanwar Saad
- 2,138
- 2
- 21
- 27
3
votes
0 answers
Why DataConnectionDialog window are different depending on thread it running?
I got an WPF form with DataConnectionDialog (from Microsoft.Data.ConnectionUI)
And the thing is in case of it called from the same thread as UI it looks like this:
Code is here:
private void btnSetDbConnection_OnClick(object sender, RoutedEventArgs…
DanilGholtsman
- 2,354
- 4
- 38
- 69
3
votes
0 answers
Connection Changed broadcast doesn't work when mobile data is enabled in Marshmallow
I have registered ConnectivityManager.CONNECTIVITY_ACTION to get broadcast when WIFI is connected. It doesn't work when my mobile data is enabled and connected WIFI has no internet connection.
I have created a hotspot in another mobile device which…
shantanu
- 2,408
- 2
- 26
- 56
3
votes
1 answer
Excel automatically opens data source when I refresh connection
I have two workbooks on a shared network drive:
Workbook A (source: Table with data)
Workbook B (Pivot Table -Connected to Table in Workbook A)
When a user has workbook A open and another user tries to open workbook B and refreshes the data, it…
DigitalSea
- 191
- 1
- 2
- 22
3
votes
2 answers
Power profiles in android
I looked into
http://source.android.com/devices/tech/power.html
, where "battery.capacity" is there and "WiFi.on" ,"WiFi.active" are there, but how to use them any Ideas?
thank you.
Ak-
- 335
- 4
- 17
3
votes
2 answers
DataTable's Data
I have a readymade library(dll) given to me, which has important data, i m able to take that data into Datatable and successfully displaying it on a GridView.
Now my further task is the Data what it is displaying in GridView should be filterable,…
N Khan
- 366
- 1
- 6
- 15
2
votes
3 answers
SQL syntax error, connection issues simple form PHP
I have a simple form that inserts data in a table on my server. I have set up a special user to handle this, with insert permissions only. I'm getting connection and syntax errors.
Here's my form:
2
votes
2 answers
Alternative to enabling data connection
On android 2.3 the permission
user874649
2
votes
0 answers
Get current database connection in Visual Studio extension
I'm trying to write an extension for Visual Studio (2019) which will add new Intellisense capabilities when writing SQL queries.
I have found an example on how to extend the text editor and show suggestions. But in order for the suggestions to be…
Copil tembel
- 399
- 4
- 22
2
votes
3 answers
SpringBoot and HikariCP relationship
SpringBoot already is managing dataConnection then why is Hikari CP needed?
I have just started using SpringBoot so do not know much about SpringBoot and Hikari relation, although i read about Hikari but couldn't find any explicit explanation about…
Just_another_developer
- 5,737
- 12
- 50
- 83