Questions tagged [dbconnection]
230 questions
0
votes
1 answer
Can i establish an alternative db connection despite of existing Yii-framework db conection
We do application in yii framework working with mysql db connection defined in config.php file.
Yet for some reason we want to connect to other server mysql db. Can i do it just this way (without using existent connection):
public function init_db()…
Igor Savinkin
- 5,669
- 8
- 37
- 69
0
votes
1 answer
Database connection in WCF using dedicated system account stored in IIS server's registry
I have WCF Service project which connect to the SQL server 2008 to do operation like Insert, Update, Delete and select. On IIS I want the connection to sql server is made by using dedicated system account which is stored in server's registry. I am…
Yogi
- 233
- 5
- 19
0
votes
1 answer
Php - mysqli connect to db several times
I have an MVC framework that works like this:
/models/Mo_Sql.php (contains the connectdb function)
/models/Mo_ClassName1.php (that extends Mo_Sql)
/models/Mo_ClassName2.php (that extends Mo_Sql)
/models/Mo_ClassName...X.php (that extends…
Lebach
- 19
- 1
- 6
0
votes
1 answer
Ef global asax open db connection
how can i open db connection in global asax file. For example i am trying to open in
using System;
using System.Web;
using System.Web.Mvc;
using System.Web.Routing;
using EDefterWAP.Helpers;
using EDocSis.DAL;
using System.Configuration;
namespace…
altandogan
- 1,245
- 6
- 21
- 44
0
votes
1 answer
Testing db connection time out
I am trying to test db connection pool time out scenario. I need to bring the db connection pool to test this scenario, could you please let me know how to bring the db connection pool of jboss down while jboss server is running, i do not have the…
Adam
- 727
- 4
- 11
- 21
0
votes
2 answers
How much timeout to use in isValid()?
In the method from Connection, how much timeout should I give it? :S I have no idea what a normal timeout would be, how much time should it take? :)
I dont want isValid() to return false if it could return true if it had gotten more time, but also…
user89862
0
votes
1 answer
connection problems when running mysql query from php file
I'm having problems with a script i wrote to automatically update stock levels from the contents of a csv file.
On my local zend server it worked perfectly. Note, phpMyAdmin has user root, no password.
But, when uploaded to the clients server i get…
Steve Price
- 600
- 10
- 28
0
votes
1 answer
Send DbConnection via OperationContract in WCF
Is there any possibility to send DbConnection as a parameter of OperationConstract in WCF? Because I get exception "Type System.Data.SqlClient.SqlConnection with data contract name…
user1759320
- 57
- 5
0
votes
2 answers
How to find out all the commands executed on a MySQL database within a given timeframe?
Is it possible to find out all the command executed against a database in a given timeframe? For example, I would like to know who executed insert command on a database table in the last 24 hours.
Any help would be greatly appreciated.
Thanks.
Murali Bala
- 1,133
- 2
- 18
- 28
0
votes
1 answer
Wordpress Hook - External Db Connect
I am developing a shortcode for wordpress. My shortcode and widget both need to connect to an external database in order to pull in formation.
My first question is what hook do i use to connect to an external db. The way I have it set up…
user982853
- 2,470
- 14
- 55
- 82
-1
votes
0 answers
AttributeError: 'NoneType' object has no attribute 'cursor'
I have a code that populates data to DB every time I run a script and this data gets displayed on a webpage. But I'm getting the error as :
File "/xyz/dept/triangulation/work_dir/db.py", line 124, in populateSpecificRecord
cur =…
Arti Bichkunde
- 17
- 2
-1
votes
1 answer
How can I resolve 'net::ERR_CONNECTION_REFUSED' error when connecting to DB API in React JS?
React JS: DB API connection error
I want to connect to DB API, but I can't resolve the below error.
- courseApi.js:10 GET http://localhost:3001/courses/ net::ERR_CONNECTION_REFUSED
- react_devtools_backend_compact.js:2367 API call failed.…
J. Nam
- 1
- 1
-1
votes
1 answer
Connection string to SQL Server Express only works from the same server but not from other clients
I have this connection string and working well when I test my aplication from the same SQL Express, I have an instance called DOKUSTAR.
using (SqlConnection conn = new…
Obed Silva
- 19
- 1
- 5
-1
votes
3 answers
why we need --skip-grant-tables in mysql to remove error 1045:access denied ?what does it really do?
why we need --skip-grant-tables to remove Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Every where either for linux/unix or windows there is same error.
can any one please explain it.
And what does…
Kushagra Sharma
- 101
- 1
- 11
-1
votes
3 answers
Old database connection class with functions deprecated
Working on an old website (PHP 3), I need to update its code, notably this DB connection class (mysql_db_query seems deprecated) :
class db {
var $host;
var $port;
var $login;
var $pass;
var $data_base;
function db(){
$this->host = "";
…
guillaume
- 21
- 5