4,605 questions
0
votes
1
answer
75
views
Why is my appsettings.json being ignored?
I have an ASP.NET Core 8.0 web application. In the appsettings.json I have a connection string defined. One pointing to a local database and one pointing to another database.
"ConnectionStrings&...
1
vote
0
answers
84
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 ...
-1
votes
1
answer
99
views
Unable to connect to local database using local IIS instance
Firstly there's a similar question on Stack overflow, and I have tried suggestions from the responses, none of which have worked.
I have SQL Server and IIS running on my development machine and have ...
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/?...
-1
votes
1
answer
71
views
SSIS: Connection may not be configured correctly or you may not have the right permissions on this connection
I have following problem:
I use a variable:
Server=DESKTOP-156DAO6\FILEWATCHERSER;Database=testDb;User ID=florian;Password=test123321;TrustServerCertificate=true;Trusted_Connection=False
for ...
0
votes
0
answers
119
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 ...
0
votes
2
answers
1k
views
Unable to connect to Azure AI Foundry AgentsClient
Getting following issue:
[DEBUG] .NET DNS resolution failed: nodename nor servname provided, or not known
[DEBUG] Inner Exception Type: Azure.RequestFailedException
when trying to connect to my Azure ...
0
votes
0
answers
47
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 ...
0
votes
1
answer
80
views
SQL Open returns mysterious error: "System.Security.SecurityException: The operation completed successfully."
I have a C# program using this connection string:
Server={ServerName,Port##};Database={databasename};Trusted_Connection=True;Application Name=MyApp
I'm using System.Data.SqlClient v4.8.6 in a .NET 6....
0
votes
1
answer
279
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 ...
0
votes
0
answers
85
views
NetworkService identity for applicationpool but keep getting "login failed" in SQL Server for my machine
Just get a new Windows 11 PC replacing my old Windows 10 PC and trying to transfer an ASP.NET Core 6 website for the last 2 days.
I have done all the necessary steps, enabled IIS, copied the DB, the ...
0
votes
2
answers
177
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 ...
1
vote
2
answers
62
views
builder.Configuration.GetConnectionString("DefaultConnection") Returns Null
I have an ASP.NET Core 6 Web API project. My controller will connect to a SQL Server database. When I run the app I can't get the connection string in Program.cs, it's returned as null.
Here's my ...
-1
votes
1
answer
350
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() ...
0
votes
0
answers
71
views
Cannot connect to remote MySQL server via connection string [duplicate]
I have a server running at let’s say 10.55.1.95 that runs MySQL database engine. I try connecting to it on a different server lets say 10.55.1.98 via a connection string like
sql_alchemy_conn=mysql+...
0
votes
1
answer
391
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
votes
2
answers
160
views
"The certificate chain was issued by an authority that is not trusted." Occurring without explanation
I have four identical environments containing Windows Server 2019 servers running IIS and Microsoft SQL Server 2019. ASP.NET 4.7.2 applications on the IIS servers access databases on our SQL servers ...
1
vote
0
answers
98
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 ...
1
vote
1
answer
120
views
Wrong or missing application name in ConnectionString since update to Excel 2409
I have a severe problem preventing some of my Excel sheets from working properly. Till version 2408 of Excel 365, all vba code in it worked just fine. Since the update from September (2024) to version ...
0
votes
1
answer
99
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
471
views
How to set different connection strings based on build configurations for debug sessions
I am trying to have different sets of connection strings based on the build configuration. (Debug, Release, Beta, LocalTraining, etc...) The use of Config Transform files, such as web.beta.config can ...
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;
...
0
votes
1
answer
89
views
Getting error with connection string when calling update-database in EF code first, but the connection string is correct (checked with other tools)
I have a test application that uses EF and it is using Context Factory to create context for use with migration.
I can call add migration and it generates suitable migration in my project, but when I ...
1
vote
1
answer
282
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
83
views
Connecting to MS Azure application fails on Status 403: Forbidden when trying to retrieve a response from API
I am trying to connect to an application registered at MS Azure that enables me to retrieve information from CRM (connecting to D365). I am using HttpClient library. When I try to send a GET method to ...
0
votes
1
answer
150
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
4
answers
413
views
Why users get locking errors when connecting to MS Access using C# with shared connection string?
I have a WPF app using C# that connects to a MS Access file to read and write data input by the user, and there are around 20 users that use the application almost daily (at one time, there may be ...
0
votes
1
answer
152
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=...
0
votes
2
answers
99
views
Azure Env Variables not being picked up
I have a web app on Azure that I am trying to connect to a mysql db hosted on aiven.io. The connection works if I hard code the connection string in appsettings.json. When I enter the exact same ...
-2
votes
1
answer
682
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 ...
1
vote
1
answer
386
views
Synapse Notebook to Azure SQL Database connection issue
created Linked service to Azure SQL database in Synapse Analytics that uses Authentication type "
System Assigned Managed Identity". Than referencing it in PySpark Notebook. Method ...
0
votes
1
answer
314
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
0
answers
120
views
Azure Connection String not readable in Spring Boot application.properties
I have a Java Spring Boot app deployed on Microsoft Azure that is connected to a PostgreSQL database. I want to connect to the database using credentials stored in Azure as Connection strings. The ...
0
votes
1
answer
666
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
1
answer
186
views
TTL setting for Redis inside Connection String, is it possible?
I am doing a maintenance on several Python applications, which use connections to Redis services. Due to an infrastructure need, I am reducing the number of variables we will have in the environment ...
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
vote
1
answer
333
views
GCP hostname resolving error (no such host)
I have been working with Google Cloud Run and PostgreSQL for some years.
Now I am trying to set up a new web application for hours, created the postgres instance, set the password to the user postgres,...
0
votes
1
answer
404
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
0
answers
66
views
Get data via SQL with connection string doesn't work
I want to create an Excel file that can fetch data from SQL. This should be with embedded username & password so I can pass on the file to a colleague who doesn't have SQL permissions. I have made ...
0
votes
1
answer
703
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 ...
0
votes
0
answers
215
views
Error -2147217887 connecting to SQL Server Express using MSOLEDBSQL in Excel VBA
I'm trying to connect to a new SQL Server Express database (SQL Server 16.0.1000) and I can establish the connection with a .BAT file and also SSMS, but not in VBA. The name in SQL Server Management ...
1
vote
2
answers
481
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&...
0
votes
2
answers
90
views
problem making a passthrough query via oracle in Access
I am having a problem with making an Access passthrough query in the following code which uses Oracle as the database:
Sub doit()
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim rs As ...
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 ...
0
votes
0
answers
55
views
SqlException when using instance in SQL Server connection string [duplicate]
Currently I am using .NET 8 and AddDbContext with UseSqlServer:
services.AddDbContext<DbContext>((provider, options) =>
{
options.UseSqlServer(dbConnectionString);...
-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 ...
0
votes
0
answers
393
views
Old project connection string using metadata tag, and providerName, is this needed? [duplicate]
I've started working on an older C# API application (over 10+ years when it was created), it has recently been updated by another dev somewhat to use .NET framework 4.8 with EF 6 (but still with the ...
0
votes
0
answers
86
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" ...
-1
votes
1
answer
343
views
Using multiple connection strings in blazor 8.0
I wanted to check in program.cs "force" after "builde", when the application is loaded, if it is local (127.0.0.1), it will use the local database (LocalConnection), and if it is a ...
2
votes
1
answer
345
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 ...