Search DaniWeb - database-connection

Database Connection Failing in MySQL – Need to Hire Developers in the USA 1 Month Ago by YashSmith I'm facing a database connection error in my MySQL-based application. The credentials are correct, … expert developers in the USA to resolve and optimize the database connection. Re: Database Connection Failing in MySQL – Need to Hire Developers in the USA 1 Month Ago by rproffitt Isn't that a little basic for the Dev Technosys company to not fix themselves? What happened to the coders and developers you had? Multiple MySQL connections + transactions 1 Month Ago by Dani …connection? e.g. // Open Connection 1 and connect to Database A // Start transaction with Connection 1 // Write some stuff with Connection 1 // Open Connection… 2 and connect to Database B … Re: Multiple MySQL connections + transactions 1 Month Ago by Dani …some writes, switched databases, and then wrote to that second database, and then switched back, and performed some more writes, …writes that were performed after switching back to the original database were rolled back, but the initial set, and the… set to the second database, were not. But what if I switch, just perform … Re: Multiple MySQL connections + transactions 1 Month Ago by toneewa You're not suppose to switch databases with a connection mid-transaction. It's by design to rollback…InnoDB storage engine. Create separate PDO connections for each database. I wonder what kind of results you get …to multiple databases on a single connection. Otherwise, just use separate connections for transactions. A database with ADHD is no good.… Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim … can connect to more than one database at a time but you require a separate connection object for each one. Since queries… go through the connection object you can't run a query on more than … a time. It seems to me that transactions are also connection based so you would have to manually roll back a… Re: Multiple MySQL connections + transactions 1 Month Ago by Dani I am already using multiple MySQL connections throughout the project, as well as select_db() in some other places. My question specifically revolved around if anyone can explain why select_db() implicitly committed the transaction, and then when done again to return back to the initial database, it did a rollback instead of commit. Re: Multiple MySQL connections + transactions 1 Month Ago by Dani > If the databases are on the same server and use InnoDB, you can use fully qualified table names, and write to multiple databases on a single connection. That's what I ultimately started doing instead! Thank you so much for a definitive answer to my question. Buggy career talk :-P 1 Month Ago by Dani … can’t use a MySQL transaction from within a persistent connection. Here’s [when I learned that lesson](https://www.daniweb… the miscommunication between myself and James that lead to our database being hacked in 2015. We are still experiencing the fallout… Re: Buggy career talk :-P 1 Month Ago by pritaeas … library soon showed a complete disregard for database transactions. This mangled the client's database completely and caused us to retrace all… Re: Multiple MySQL connections + transactions 1 Month Ago by Salem https://www.php.net/manual/en/mysqli.select-db.php I think the key word in all of this is "default". You can probably do what you want, but you have to refer to each DB by it's own handle. Using `select_db` is fine, if you only have one DB and you want to be lazy about referring to it. So you make it the default DB. But as … Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim In that case I can't suggest anything. I've never had to update multiple databases for any of the systems I set up. Re: Question/Answering over SQL Data Using LangGraph Framework 1 Month Ago by Pelorus_1 Through its combination of natural language processing and structured query generation, LangGraph makes interfacing with databases and extracting insights over SQL data easier than ever. Re: Buggy career talk :-P 1 Month Ago by Reverend Jim The most challenging bug was one I introduced myself. While making a miniscule code change I decided to improve the readability of the following line by inserting a space. In today's code that would not be a problem, however, most of our code (AGC/SCADA) was written in FORTRAN. Those of you who made your bones in the punch card era, or know a … Re: Buggy career talk :-P 1 Month Ago by Salem This https://en.wikipedia.org/wiki/Peterson%27s_algorithm Plus two different kinds of processors. Plus an error rate of less than once a week. After many months, the cause was eventually captured on a bus analyser. After which, the solution was obvious after a bit of RTFM. Turned out that one of the processors had the then awesome new … Database connection 16 Years Ago by Ragini.gudiya …;,"root","root"); System.out.println("Connection Established"); return con; } catch(Exception e) { System.out.println… a id and pwd admin,admin then give the error Database Connection does not exist plz help me how can i solve… database connection 17 Years Ago by lydia21 hi, i am using freehypespace.com.i want to know abt database connection.i want to insert data from my textbox to database.....thanks .lydia database connection 9 Years Ago by AnkÃ¯t … code for .aspx files, now i am looking for sql database connection for my project. exapmle: databasename: demo1 table_name: State user id… Database Connection Error 15 Years Ago by jockfaire … = \"a18b9e72d\";"; aDBconnection = new SqlCeConnection(_dbConnectionString); // open the database connection aDBconnection.Open(); // create the adapter and fill the dataset //aDBcommand… Database connection string error! 14 Years Ago by Acidburn … Computer"; // The link between the sql command and the database connection dataAdapter = new OleDbDataAdapter(commandstring, SQLServerConnection); // SqlConnection conn = new SqlConnection("… DataBase connection in Jsp to MS-Access 17 Years Ago by nireekshan hello i am nireekshan i have some prouble in database connection send my erres pless see and send Some Code . //...............................// [code=…(*.mdb)};DBQ=" + database + ";DriverID=22;READONLY=false"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection… Database connection problem 15 Years Ago by ajijacobm Hi, I have database connection problem. A part of the source is shown Below [code=… showing all the rows in the database.Please show me how to establish a connection with the database and also,how to execute… Database connection via method call 15 Years Ago by vishalanuj Hi,I am new to struts.i want to make a database connection with the help of a method call in some other class.I am not able to make the method for the database connectivity.Please if someone could help me. database connection(select ,insert query) within javascript function 19 Years Ago by muthumari Hi , How to write the database connection(insert,delete or select query) within javascript function.Is it possible.Anyone can you help me Thank you Re: database connection(select ,insert query) within javascript function 19 Years Ago by madhav_2k [QUOTE=muthumari]Hi , How to write the database connection(insert,delete or select query) within javascript function.Is it possible.Anyone can you help me Thank you[/QUOTE] You could put java code in JSP tags in a javascript function. I think that should be possible. Re: database connection(select ,insert query) within javascript function 17 Years Ago by kothala.srikant hi, can u please send me some sample coding of javascript having a database connection. thank Q. Re: database connection(select ,insert query) within javascript function 17 Years Ago by peter_budo JavaScript database connection? Are you sure you know what you talking about? Secondly, please read forum rules. We try to help solve your problems but not doing your job... Database connection in sqlserver 2005 in c# 15 Years Ago by tiwari.vinay96 how to make database connection in sqlserver 2005 in c# database connection using Oracle XE. 15 Years Ago by Parsu7 Hi Actually i want to know the driver name to use for database connection using Oracle XE. database connection status viewer 14 Years Ago by rheyn needdd help...... how could i view remote database connection status using vb6? if the status currently connected or not to other user........ TY in advnce :)