4,604 questions
1
vote
0
answers
80
views
SQL Server connection authentication in Azure DevOps pipeline for .NET seeding data .sln
I have a .NET application that seeds data to an Azure SQL database after deployment via Azure DevOps pipelines.
I'm struggling with authentication when using a connection string in Azure DevOps ...
- 3,221
1
vote
0
answers
45
views
Where should I put my MongoDB connection string in Vue CLI project?
I am learning to build an MEVN project. I have a MongoDB connection string that looks like this "mongodb+srv://<username>:<password>@<clustername>.abcdefg.mongodb.net/?...
- 125
0
votes
0
answers
118
views
Connection to SQL Server using Microsoft Entry MFA via sqlalchemy and ODBC in python always prompts for password
I am writing a python script that connects to Azure Serverless SQL and exports the rows for a given query. I am using sqlalchemy. I build the connection string
connection_string = 'DRIVER={ODBC ...
- 155
0
votes
0
answers
44
views
Test whether a string contains a valid database connection string
I'm using System.Data.SqlClient.SqlConnectionStringBuilder to pull apart a connection string we save when loading data. In theory (although not yet in practice), the user could load the OM from one ...
- 9,344
0
votes
1
answer
266
views
psycopg_pool.ConnectionPool conninfo WARNING error connecting in 'pool-1': [Errno -2] Name or service not known
with ConnectionPool(
conninfo = app.config["POSTGRESQL_DATABASE_URI"],
max_size = app.config["DB_MAX_CONNECTIONS"],
kwargs = connection_kwargs,
) as pool:
With a ...
- 4,280
0
votes
2
answers
173
views
Migrating from .NET Framework to .NET 9.0, How to access ConnectionStrings from a static class? (web.config vs appsettings.json)
I am in the process of migrating a large solution from .NET Framework 4.8 to .NET 9.0. I used .NET Upgrade Assistant to get started. I have a long way to go.
All of the projects in the solution have ...
- 29
-1
votes
1
answer
338
views
Azure function app with SQL Trigger not working after deployment
I have an Azure Function app created locally using Python code, SQL Server change tracking that tracks any operation and triggers the SQL Server trigger for further process.
app = func.FunctionApp() ...
- 1
0
votes
1
answer
382
views
Azure function not working once deployed to access Azure Storage
I created an Azure function project in VS Code, using .NET 8 isolated. I followed the instructions here Develop Azure Functions by using Visual Studio Code and once I finished and deployed it, the ...
- 1,175
1
vote
0
answers
97
views
How to prevent custom ConfigurationBuilder affecting the XSD designer?
I have a custom configuration builder that changes database connection strings based on the current environment configuration using the concept of this answer as shown in the code below. To my ...
- 3,907
0
votes
1
answer
91
views
Problem with SQL entity connection string
I have an app that is called on a remote web hosting server. It calls up customer details and amends records in response to notification of a sale. It used to work fine but recently it does not.
The ...
0
votes
1
answer
59
views
dsnless connection using oracledb
Using VBA I can make a dsnless connection to oracle in the following way.
Driver={Oracle in OraClient21Home1};DBQ=<<string_returned_from_tnsping>>;User Id=fake_user;Password=fake_password;
...
- 89
1
vote
1
answer
277
views
VS Code Database Connection String
Issue:
In VS Code, I created a .NET Web API application using Entity Framework. To activate .NET commands, I always have to run the following command:
export PATH="$PATH:$HOME/.dotnet/tools"
...
0
votes
1
answer
143
views
Oracle RCU Database Connection Details Connect String with Oracle Cloud Free trial DB not able to connect
I am encountering the error below. I tried both with jdbc:oracle:thin:@ and without it. I didn't understand what is the issue?
The error is:
Unable to connect to the DB. Check if DB connection ...
0
votes
1
answer
147
views
Connection string ignores userId and pwd provided and logins with the Windows authentication user
In the .net core I'm having a connection string something like this,
Data Source=.\\SQLEXPRESS;Initial Catalog=TestDB;MultipleActiveResultSets=True;User Id=AdminUser;Password=Admin;Integrated Security=...
- 41
-2
votes
1
answer
657
views
Default user and password for MongoDB docker [closed]
I am running a local MongoDB docker using following command
docker run --name mongodb -p 27017:27017 -d mongodb/mongodb-community-server:latest
This works fine and I can connect to this using ...
- 73
0
votes
1
answer
311
views
Authentication failure when trying to copy a blob from one container to another
I am trying to copy a blob from one container to another and am creating a BlobServiceClient using a connection string as described here. However I am running into the following error.
Error ...
0
votes
1
answer
660
views
How to access connection string with python
I have this local.settings.json in my local Azure function (Timer trigger)
{
"IsEncrypted": false,
"Values": {
"AzureWebJobsStorage": "",
"...
0
votes
0
answers
71
views
Connection string to read recordset from a table in Microsoft WORD
In Powerpoint, I'm writing VBA code to read data from different data source files. To get data from Excel, I have no problem creating a recordset by using a connection string as follows:
With cn
....
- 1
0
votes
1
answer
395
views
Downloading file from Azure Blob Storage from a React-Native application
I want to connect to azure blob storage via my React-Native Application.
I am getting this error: [Error: Account connection string is only supported in Node.js environment]
Does this mean that I ...
0
votes
1
answer
700
views
Connection string exacly the same to same Power BI dataset in both Test and Prod workspace in Excel
I have a problem where I have a Power BI semantic model in 2 different workspaces, one for Test and one for Prod.
A user is accessing the dataset via a PivotTable in Excel connecting with "From ...
1
vote
2
answers
478
views
How to configure NHibernate to connect to SQL Server?
I am facing a little problem with my NHibernate configuration connection with SQL server database. My App structure is just for simple test. Here is my hibernate.xml.cfg:
<?xml version="1.0&...
- 41
0
votes
1
answer
1k
views
ADO Connection for Excel on Sharepoint
I built an excel file with macro code that accesses a lot of data on one of its own worksheets. I use an ADO connection so that I can use SQL on the data. This worked fine on my local computer. When I ...
- 105
-2
votes
1
answer
49
views
store in configuration or not [closed]
What is the Best Location for connection string in the Program.cs or Appsetting.json and i want To know about the hard codding more ..
Well I put the connection string in the appsetting.json and ...
- 27
0
votes
0
answers
83
views
vb.net connection string to a regular google drive
I am trying to link my program to my google drive but only for the database but it gives me an error message. In my program properties - settings - I have the name
"RatesConnectionString" ...
- 23
2
votes
1
answer
344
views
Azure App Service Connection String Not Working
I am working on an asp.net core web api project and its hosted on azure app service. What I'm trying is to put my cosmos db connection string in app service connection string. I added a document db ...
- 85