How to install the MySQL JDBC connector?
Can anybody tell me how to install the MYSQL JDBC connector. I am getting error “java.sql.SQLException: No suitable driver “. I placed the driver in the java-jrelib folder also in the shared folder of tomcat 5.0. Even in the lib folder of WEB-INF. But I am getting the same error.

Answer Question   |  March 4, 2009  6:32 AM
Apache Tomcat, Database connectivity, Java, Java Database Connectivity, java.sql.SQLException, JDBC, JSP, Linux hosting, MySQL, Tomcat hosting, Web developers, Web development

MySQL and JSP connection
I hosted my site and I got the mysql server. Now, I want to connect it with the jsp pages . I am not understanding how to use ip address in connection string and while creating DSN i used my local server that is tomcat. But my website is in linux server. Will it create [...]

Answer Question   |  February 25, 2009  5:43 AM
Apache Tomcat, Database connectivity, DSN, JSP, Linux servers, MySQL, Web development

How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.

Answer Question   |  February 18, 2009  8:38 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures

Notes rich text field to BLOB/Memo field in SQL Server using ADOdb
I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I’m finding examples of reading this kind of data back [...]

Answer Question   |  February 2, 2009  7:40 PM
ADO, ADOdb, Binary Large Object, BLOB, Database programming, Memo fields, MySQL, SQL Server development

Permissions for writing stored procedures in MySQL
Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I got [...]

Answer Question   |  January 27, 2009  12:31 PM
Database Backup, Error 1044, Java development, MySQL, MySQL Access Denied error, MySQL backup, MySQL Stored Procedures, Navicat, SQL stored procedures, Stored Procedures, Web development

Restoring a MySQL database
Perhaps somebody can point me in the right direction. I have a MySQL database that I inadvertently deleted all records from. There is a regular backup I have which I can access, but I have no idea where the MySQL database tables reside in the system. I have the root password and complete access to [...]

Answer Question   |  April 24, 2012  7:33 PM
Linux, MySQL, MySQL Restore

JavaScript addContent function – Packaging Options
* IS THERE A WAY to use this javascript addContent function, * Incorporate the utility of an ADD button * But avoid using the packaging of FORMS? While making use of a sample for addContent (located at http://www.randomsnippets.com/2008/04/14/how-to-dynamically-add-content-to-a-div-via-javascript/, I stumbled into a problem that I hope someone can help on. We have a PHP/MySQL page [...]

Answer Question   |  April 23, 2009  11:44 PM
addContent, JavaScript, JavaScript addContent function, JavaScript forms, MySQL, PHP, Web development

MySQL capabilities
Do you guys know where CanI find specific details for mysql like max number of records, max number of connections, max size of databse etc etc? my version is Ver 14.12 Distrib 5.0.51a

Answer Question   |  December 9, 2008  1:39 AM
MySQL, MySQL documentation, Recommended reading

create database using java
How to create database (not table) using java? For example, I want to create database in MSAccess, MySQL, Oracle etc.

Answer Question   |  May 11, 2012  2:53 PM
Database, Java, Java Database, Microsoft Access, MySQL

MySQL vs SQL server
If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they’re cabable of or does it just change what front-end you use? Why would I need a WAMP stack [...]

Answer Question   |  February 27, 2011  4:34 PM
MySQL, SQL, SQL Small Business Server, WAMP Stack

Oracle, MySQL connectivity by HSODBC
Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL and Oracle are running on windows [...]

Answer Question   |  October 27, 2008  6:04 AM
Database connectivity, HSODBC, MySQL, ORA-02063, ORA-28545, Oracle, Oracle 10g, Oracle error messages, Solaris

PHP functions
how do multiple functions work

Answer Question   |  September 10, 2010  9:43 AM
MySQL, PHP, Web development

Get user input in MySQL query
How can i get user input in any mysql query at runtime.

Answer Question   |  October 15, 2008  9:41 PM
MySQL, MySQL query, RunTime

Table storage settings at table creation time
How can i set table storage settings at table creation time or any existing table

Answer Question   |  October 15, 2008  9:38 PM
MySQL, Table storage engine

Recovering the MySQL database
In the process of editing my database, I accidentally deleted the MySQL database. I thought I recovered it, but when I opened MySQL Query Browser, it was not there. Is there an easy way to recover it for good?

Answer Question   |  May 31, 2012  6:14 PM
MySQL, MySQL Query Browser, Recovery, SQL Server

AUTO INCREMENT
We created a File with an Auto Increment Field using MYSQL statements through PHP. I have no Idea how to do this using DDS statements or settings.

Answer Question   |  May 4, 2010  2:58 PM
Auto increment, DDS, MySQL, PHP

New to php/mySQL having an issue with Mac OSX
I’m following the lynda.com video series on php with mySQL and have run into a hangup. When I install mysql and I’m checking to make sure it’s all running, pointing a browser to http://localhost gives me the apache is running page, but going to http://localhost/~(myusername)/, I get an error saying “Forbidden. You don’t have permission [...]

Answer Question   |  August 8, 2008  5:16 AM
Apache, Mac OS X, MySQL, PHP, Web development

equivalent for crosstab query
Is there any function in MySQL that can create a query similar to crosstab query in MS Access???

Answer Question   |  August 5, 2008  3:06 PM
Microsoft Access, MySQL, SQL Query

Echo a variable in PHP which displays as a link
hi, I have a number of variables that i pull from a mysql database. I want 1 of the variables to show as a link to a web page. i have tried the following code, which displays everything fine, except for the $url bit echo "<p>$djname $genre $biography <a href='/$url'> Profile</a>"; [/code] any help would [...]

Answer Question   |  June 30, 2008  3:21 PM
MySQL, PHP, PHP/MySQL

URL link in PHP/MySQL script
I am adding a URL within a table with PHP and a MySQL Database, my string doesn’t show all of the URL, it cuts it off.

Answer Question   |  June 21, 2008  10:43 PM
MySQL, PHP, Table Functions, URL