Stack Overflow
Stack Overflow

Questions tagged [database-connectivity]

96 questions
1
vote
0 answers

Spring Boot error with multiple data-sources :: dataSource or dataSourceClassName or jdbcUrl is required

I can see following error in my Intellij local for sometime now. Caused by: java.lang.IllegalArgumentException: dataSource or dataSourceClassName or jdbcUrl is required. I have multiple data-sources configured for my project. Something similar as…
Jayanta Mandal
  • 23
  • 7
1
vote
0 answers

Is it possible to avoid warning when using LOAD DATA LOCAL INFILE to import duplicates

I have a table errors with the following columns : id_error, product_id, error_code which is already filled up with some errors. I am using id_error as a primary key and I added a UNIQUE index composed of columns product_id and error_code in order…
J. K.
  • 11
  • 2
1
vote
1 answer

Error in Connecting Visual Studio 2019 with Oracle 19c

I have installed oracle 19c 64 bit version on my computer. And I have installed Visual Studio 2019. Below are the details of my visual studio installation. Microsoft Visual Studio Community 2019 Version 16.9.4 I have created my database and I am…
ChathurawinD
  • 756
  • 1
  • 13
  • 35
1
vote
3 answers

Error on connecting AWS RDS to Google Sheets using Google App Scripts

I'm trying to connect AWS RDS to Google Sheets, but all i get is Failed to establish a database connection. Check connection string, username and password. I have tried the method found in trackers i.e, "using the IP of the endpoint host address",…
Tanmay Dwivedi
  • 71
  • 1
  • 9
1
vote
3 answers

Question regarding SQL connection in a web application

I have a doubt regarding the sql database connection that we open for performing CRUD statements on the database in the context of web application (a web store) in asp.net What is advisable to keep the database connection open (when user logs into…
Sreedhar Danturthi
  • 7,119
  • 19
  • 68
  • 111
1
vote
2 answers

Generic way to test connection string of various rdbms

I am having different data source like mysql, SQL Server and Oracle and for each of the data source i will test the whether handshake with the server is successful or not based on the connection string. So I have created 3 class and each of this…
I Love Stackoverflow
  • 6,738
  • 20
  • 97
  • 216
1
vote
1 answer

Getting error after installing sql server 08 Express edition

I have installed SQL server 08 express edition and then tried to connect using SQL server management studio, but getting below error: TITLE: Connect to Server Cannot connect to My-PC\SQLSERVER. ------------------------------ ADDITIONAL…
Wondering
  • 4,950
  • 22
  • 71
  • 90
1
vote
1 answer

sql server 2008: configuration information

I have sql server 2008 installed on my dev machine. How I figure out things like, the name of the server, do I connect to it using windows auth or using sql auth. If I connect using sql auth what is my account information. I set it up a while back…
dotnet-practitioner
  • 13,968
  • 36
  • 127
  • 200
1
vote
2 answers

Oracle Error: ORA-12154: TNS: could not resolve the connect identifier specified

I am new in oracle. I am using windows 10 64 bit, Oracle XE 11g, visual studio 2010 and vb.net. But Why I am getting error: related to listener always when I turn off or hibernate my machine Services are also running. This is listner code:…
ZearaeZ
  • 899
  • 8
  • 20
1
vote
1 answer

MongoDB 2.0.18 unable to connect via node whereas older version 1.4.32 works

i installed mongodb via npm using npm install mongodb Which installed 1.4.32 version of mongodb driver. The code given at the bottom worked fine, but when i upgraded my driver ( and deleted the older folder of 1.4.32 from node modules, updated…
Bharat
  • 152
  • 1
  • 9
1
vote
1 answer

DataBase Connectivity on the client side using (JavaScript)

I have a question which really Poked me for several days... I have came across a hurdle, the problem is that i need the Php application on the server side and the database to be on the client side... and the application should communicate with each…
user2420211
  • 280
  • 1
  • 3
  • 11
1
vote
3 answers

Test Connectivity of SQL Server from remote machine using C#

I need to test the connectivity of SQL Server with my remote machine, I have SQL server name not IP address. How can I check this connectivity. How will I know on which port the communication enabled.
AMIT SHELKE
  • 501
  • 3
  • 12
  • 34
0
votes
1 answer

How to connect html5 mobile web app to an iis server to get info from the sql server database?

I think the question is self explanatory. How can i get info from sql server database and pass it to my web app so the content is dynamic. How to make a connectivity between html5 and the server? I know is using ajax any examples???? How to do it…
elvainch
  • 1,369
  • 3
  • 15
  • 32
0
votes
2 answers

can stored proc in SQL Server 2008 on-premise db reference a table in SQL Azure db

I can see my SQL Azure database in SQL Server Management Studio, and am able to execute queries, create objects, etc etc, in SSMS. The VPN is working. I know there are (or will be) synchronization utilities available from Microsoft, but let's say…
blint
  • 191
  • 1
  • 9
0
votes
1 answer

jnlp: Reading properties file from server

I am launching application through jnlp, where i need to read the database configuration from server (Tomcat). Is it possible to connect to the host address or can i read properties file before jnlp launching the application?
Dyapa Srikanth
  • 1,231
  • 2
  • 22
  • 60
1
2
3 4 5 6 7