MYSQL :: Create A C++ Based Program Using Mysql Odbc.

Create My Own VB Backup Program For A Remote MySQL DB
I understand that the basic principles to create a TCP/IP backup program for

a remote MySQL DB are:

a) Query/retrieve the schema.

b) Query/retrieve each table and create inserts for each row of data.

The way I want to do it is even more basic, as I know what my schema is so I

only need to reterieve and create the insert rows to put into my backup text

file, which is basically a large DDL.

The problems that I am experiencing are I want to keep the schema in an

external text file so that I'm not storing it in the actual app and I

thought I would also have another external file to store each 'select * from

tablex' query.

Is this a good way of doing it?

How would I merge the results together to make a new (and 3rd) external text

file backup?

Create ODBC To MySQL
I have programed PHP appliction using apache and IBM DB2 database using ODBC connection. Is there any simple way to specify ODBC connection to MySQL database and use the same PHP program which is using DB2 as datasource without need to change PHP program code?

Create Odbc Connect From Mysql To Oracle
can someone provide step by step instructions on how to set up a odbc connection from mysql to oracle and have records in a table transferred from a mysql table to an oracle table. Mysql and Oracle are on Solaris OS.

CREATE Tablename Based On Result Of SELECT Statement?
Is it possible to have an CREATE statement that contains a SELECT in the section of the CREATE that specifies the TABLE?

I want to have a sql script that can execute SELECT YEAR(CURDATE()) and SELECT MONTH(CURDATE()) to give me the Year and Month and then use these to create the Table Name: tbl_MetaData_2008-03

Example:

CREATE TABLE tbl_MetaData_X-Y
( ...

Where X is the YEAR and Y is the MONTH

CREATE Tablename Based On Result Of SELECT Statement?
Is it possible to have an CREATE statement that contains a SELECT in the section of the CREATE that specifies the TABLE?

I want to have a sql script that can execute SELECT YEAR(CURDATE()) and SELECT MONTH(CURDATE()) to give me the Year and

Month and then use these to create the Table Name: tbl_MetaData_2008-03

Example:

CREATE TABLE tbl_MetaData_X-Y
( ...

Where X is the YEAR and Y is the MONTH
s the MONTH

MYSQL In A Program
How would I access a database from a program? All I need to connect in the program is the IP address or the URL, though I do not know how to get those from a database.

Also, I'm still having trouble with this:
http://forums.mysql.com/read.php?10,141978,141978#msg-141978

Using MySQL To Input Into Another Program
I have been working on a workaround to see if I can figure out how to get DATA from MySQL into another program. The other program is built on MS SQL server. The problem is that it is so bloated that a remote and my computer at the plant cannot correspond back and forwards. It takes approximately 10 minutes to key an order in to the remote plant.

I was working on a much smaller database through MySQL and using OpenOffice.org as the front end. I just wanted to go a step further and see if there was a way to use a triggering mechanism of some sort to input the data from OOo/MySQL to the actual program the company uses.

Good Program For Mysql
Do you now a good program for mysql admin like phpMyAdmin, than better!!

Linking C Program With Mysql API
I'm linking a simple C code with mysql. I compile the code with
this command:

linux> gcc -L/usr/lib/mysql -I/usr/include/mysql sqlTest.cpp -lmysqlclient -lsocket -lnsl

But it complains that "-lsocket" cannot be found. So, I removed "-lsocket" and
try again, then I got the messages like

/tmp/ccIelMdT.o(.eh_frame+0x11): undefined reference to `__gxx_personality_v0'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x66): In function `my_uncompress':
/usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:85: undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x11c): Infunction `my_compress_alloc':
/usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:58: undefined reference to `compress'

My system is SUSE Linux 9.1, and I installed mysql by downloading the rpm files
from this site, and use "rpm -i mysql-xxxx.rpm" to install them. The libraries
are installed at /usr/lib/mysql, and include files are at /usr/include/mysql.
Can anybody tell me how I can configure my system to make it work?

Program MySQL With Apache
I don't even know what this is called, but I'm looking for a free tool that allows me to code MySQL and will work with Apache and PHP.

Program To Optimise Mysql Queries
Basically im looking for a program that will take input (my query) and produce an output with a much nicer, more efficient query. I have seen sql programs that do this sort of thing, but nothing for mysql.
Just wonder if there is any programs that i have missed? Tryed Toad for mysql, but that wasnt what i wanted, i dont want a program to admin a mysql database, simply to produce a more efficient query.

Packaging A MySQL Database With A Program
In writing a visaul basic database program with Access as the database you simply copy the database file into the packager and it is installed with your program on the target machine. I am guessing that with mysql, since it is a 'server' program, it is not that easy. Am I wrong? And where would I find information on this.

I have been working on a business accounting program and am a long way from finished, but I wanted something more robust than access as the database. I just need to know how to get the database to the target machine with my program.

How To Access MYSql From External Program
I have a Mysql database on a webserver and would like to access order information automatically from my home computer. I have the ecommerce software send me an email of the order and I wrote a VB program to extract the information from the email and populate an Access database. There must be a better way. Can I somehow have MS Access backup that database on my home computer?

Another Program To Access MySQL Database
I have a list of 8 rows by 11 columns that I exported from Excel into MySQL to populate my Database and that all made it through.

I am now trying to create a label with a label making program that will connect to a database. I have installed the ODBC 3.51 driver and tested the link and it finds the file.

When I try to open the database file from the label making program it says "Error Reading Record Fields", I click on details and it says "ODBC driver does not support dynasets."

I have no idea what a dynaset is or why it is an error???
Is there a way around this?

I can save the excel file as a DBaseIII .dbf file and it works but I wanted to be able to use a database for better tracking of information.

MySQL Admin Program/Script
I'm looking for an application, or php script that makes entering and retrieving information out of a database automated. The process would like so:
I enter in the mysql un/pass etc. and create tables and rows. Also defining what type of input each row should have. Whether it be a checkbox, a dropdown menu, plain text input. Also defining what options for things like the checkboxes and dropdowns.
After that, you would be able to go to a simple front end that had the inputs you defined. You could create your entries and retrive them. Sorting them how you see fit.
Given the obvious use for such a thing, there must be plenty. I must not be wording my searches correctly though. I would prefer something free/open source.

Redirect Out Of Mysql Client Program To A File
I have mysql on MS Windows2000.

I like to redirect the output/error messages of MySQL client programs to a file.
For example, when I execute:

"mysql --user=root --password=[wrongpaswd] --silent --database=mysql > errfile"

The following error message is coming in the screen, not in 'errfile'

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"

I also need to capture the same for utility "mysqlimport".

How capture the output of these client programs in a file?

Developing Database Program Using Delphi And MySQL
how I can use MySQL with Delphi? What I'm really looking for is a header file which can be used in each project which will allow me to use MySQL.

Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype
is set to TEXT, I'm trying to output this through a C program.

the line is as follows:

while((row = mysql_fetch_row(result)) != NULL)
{
printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL"));
}

I have trued %c and %s in to print the Sensor name, however %s
crashes the program and %c produces a smiley face.

Making Connection To Mysql From A C Program On Windows
can any one please tell me "how to make a conncetion to mysql database
from a C program on windows " .
Please help me by giving possible code for making a
conncection,selecting data etc.
i.e. what library files i need to include,what are the functions needed
to be called.

Problem: Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program.

the line is as follows:

while((row = mysql_fetch_row(result)) != NULL)
{
printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL"));
}

I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.

Odbc 3.51, Visual Studio 2003, Odbc DataAdapter
one Question. Is here anybody who had success in accessing a mySQL database
via the ODBCDataAdapter in the Visual Studio design view?

I get always Errors after creating the select Statement in the
ODBCDataAdapter Configurartion wizard. The error-Message tells me, that the
user has no permissons. If I do the access in Code, it works. But I want to
Create a Dataset in the Desing View.
----
in German:

mal ne Frage. Hat es hier schon mal jemand geschafft mit dem odbc
Dataadapter auf eine MySQL Datenbank zuzugreifen und zwar in der Design-View
vom VS?

Bei mir klappt das nur im VS 2003, und dann habe ich aber nachdem ich den
Select-Querie zusammengestellt habe Probleme mit dem Zugriff.

Wenn ich das ganze über Code probiere, klappt der Zugriff wunderbar. Aber
nicht über den Wizard.

Im alten VS geht das sowieso nicht. da kann man den ODBC DataAdapter nicht
konfigurieren.

User Based PHP W/MySql
If I were to take a few different (gpl released) php programs that use MySql databases for the user data, could I integrate all the users into one database?
For instance, a user signs up in one of my forums, and their info is stored in a database. Then if they go to my auction script using the same database, they don't have to sign up again.

My guess is that yes it would work, but I'd have to go through each php file and edit where it called for the table data in each database to point to the same places.

Web Based MySQL Editor
I am looking for a Web Based MySQL Editor to manage, database, users, etc and if you can, tell me why you like it, good points, bad points, etc. I use PHPMyAdmin right now, so I am looking for something possibly better.

Mysql Select Based On Datetime
I am having an issue returning a known record based on a date field that is of datetime format from mysql.

the data looks like this in mysql: 2006-01-26 20:01:45
here is the eror I receive:
SQL error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ཐ:01:45' at line 1

this is the select statement I am using

("SELECT selections from your_show WHERE userid = $userid and date = ".rawurldecode($date)." ");
$date is passed as 2006-01-26%2020:01:45

File Based Version Of MySql
I would like to create a program in C# and use MySql as a backend. Is there a file based version of MySql that does not require the server to be installed. I know that if I use a Ms Access db, I can manitpulate the data without the user having Access installed (using ADO). I want to know such a thing exists for MySql?

Mysqlimport Program
I have been using load data in file command until recently on a windows machine - works fine.

we are now using a Netware 6.5 box and are trying to use mysqlimport from the command line.

I am using:

mysqlimport --password=123456789 --fields-optionally-enclosed-by="" --fields-terminated-by="," 0608c sys:mysqlinstirling.txt

to import a CSV text file into the database 0608c.

the data looks like this

"2007-06-28 16:07:00",0,13.58,15.77,-13.35,-12.69,-13.36,-6.61,-3.821,......

when the program executes it seems to give the desired results except the timedate is all zeros...

Extraction Program
I am looking for a simple extraction/load program to load data daily from a
Progress 8.3B database via ODBC to a mysql 3.23.57 database. It does not
necessarily need to do any data-type transforms. It need to run on Windows
2000 and be able to run it as a service, or as a cron task if running under
Unix.

Setup Program
I'm writing a Java setup program for installing a JDBC app, which connects to a Mysql database.I want to create a script in order to provide final user setting privileges in that database and add it a table, without needing to write Mysql commands.
How can I do it ?

DB Modelling Program
Is there a database (ERM) modelling program for Mac OS X that can handle MySQL? Maybe a freeware one?

Php Email Program
Does anyone know of a php or even cold fusion based script out there for
accessing email that can be customized? Right now I use SquirrelMail
which is great, however, you can't really customize it to tie in with
your web site. Is there something out there that is very flexible that
I could make fit right into my site which is pretty reliable in terms of
web email?

Using MySQL From ADO.NET And ASP.NET Via ODBC
I have the following problem when I try and connect to MySQL -

REGDB_E_CLASSNOTREG(0x80040154) - (MySQL ODBC 3.51 Driver).

I have used this driver via VB6 using ADO and ODBC without a problem. The connection string I'm using in ASP.NET and using .NET Framework 1.1 and MDAC 2.8 RTM is:

MyConnectionString = "Provider=(MySQL ODBC 3.51 Driver);Data Source=localhost;uid=;initial catalog=property;password="

Mysql + Odbc
What are the advantages / disadvantages of using odbc to connecting to a
(mysql) database???

MySQL ODBC
I downloaded the MySQL 3.51 ODBC driver and it is hanging on connection for some reason. Is there a fix? I just want to get data from my web tables via VBA

MySQL 5.0 And ODBC
Tried the ODBC 5 connector that MySQL provides - it is an Alpha product and is really not ready for prime time. Does anyone know of any 3rd party ODBC connectors - even commercial ones - that are ready for MySQL 5.0 and support the new stpred proc with parameters functionality in MySQL 5?

Mysql Odbc
i am using Access 2003 connecting to mysql 4. and newest odbc driver, and i set a checkbox form control bound to a unsigned integer field in my database. if its intially set to 0, or 1. it will be checked in my access form. if i uncheck it, it will update my mysql database accordingly to 0. but if i check an unchcked box, it will not let me do it. it seems to send -1 to the field whoever at microsft made (-1 == yes) should die lol.

anyone know a way to make access recognize it, or fix odbc driver so it knows if microsoft uses the driver to convert -1 to 0?

my best solution is make a trigger on update, and if that new value is -1 set it to , hoping it wont spit back error back to Access for the inital -1 being wrong. any other ideas? wish i knew what event to override to do my own insertion. if checked, UPDATE with 1, if unchcked, UPDATE with 0.

C- Program To Write To Myi , Myd File
is it possible to create a myi, myd file for mysql using a C program. I
am using Stata that is written in C API, and I want to write the data
out to MYSQL database. Using ODBC and loading the data in MYSQL from
STATA takes forever. Can anyone please tell me if I can create the myd
files by using the data in memory thru C programming.

Trigger To Run An External Program
Can I trigger an external program to run when a new record is added to
the mysql table?

The external program is in C and instead of scanning the table
continuously for new insertions, it will be better if an external
program could be triggered.

Can't Update A Field From VB Program
I've just setup MySQL on a Linux machine and I'm using Visual Basic in
Windows to connect to it (using MySQL ODBC 3.51 driver). Everything works
fine for browsing the database (used for stock control), but some parts of
the VB program refuse to update the database. It was using an Access
database (which worked ok) and I'm using the same SQL statement and table
structure.

Here's the SQL statement that VB runs:

SELECT Stock.GJGStockCode, Stock.PartName, Stock.Discontinued,
Stock.UnitsInStock, Stock.UnitsOnOrder, Stock.ReorderLevel,
Stock.ReorderQty, StockSuppliers.SupplierID,
StockSuppliers.OrderCode, StockSuppliers.PackQty,
StockSuppliers.Price, Stock.PartsToOrder
FROM Stock, StockSuppliers
WHERE Stock.CurrentSupplier = StockSuppliers.Position AND
Stock.GJGStockCode = StockSuppliers.GJGStockCode AND
((Stock.UnitsInStock + Stock.UnitsOnOrder <= Stock.ReorderLevel)
OR
(Stock.PartsToOrder > 0))
ORDER BY StockSuppliers.SupplierID, Stock.GJGStockCode

....which works ok for browsing the database. If I change the
Stock.PartsToOrder field in the VB program, when VB trys to update it I get
the error message "Insufficient key column information for updating or
refreshing". The Stock table has a primary key (GJGStockCode), and the
StockSuppliers table has a primary key (UniqueID) which is an auto_increment
bigint.

Does anybody know what I need to do to allow VB to update the database? Or
is this a VB question!?? - Although the same SQL statement works with an
Access database.

Program Refusing To DROP DB
I am getting this problem over phpmyadmin and also over a preprogrammed php script.
When there are more than 30 or 40 selected DBs the programs refuse to carry out any command when I click on the drop button.
They would just take as if there is no command issued at all.....

Anyone know how to make it delete more DBs at one time?
I looked at trhe my.cnf file but don't see any options to do this...
It however runs on small batches but I need it to drop a lot more databases at one time.

Mysql ODBC Connection +VC+Win
Want to create Mysql ODBC connection with visual C under Windows. I do not want to use DSN. Any ideas? I know there is ODBCconnection class under .NET, but how about visual C?

MySQL ODBC Driver 3.51
The table it is selecting on contains 64 rows.
here is an example piece of code:

strSQL = SELECT DISTINCT id from table where id = 10
set conn = CreateObject("ADODB.Connection")
conn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=as3;Database=name","user","password"
set rs = conn.execute(strSQL)
'next line of code'

It takes 5 seconds plus to get the the next line of code from "set rs = conn.exec......."

ODBC To Connect Mysql
I would link to use VB to connect mysql using ODBC, but the mysql database is outside my OS. I'm sure that the setting of ODBC is done, but when I connect the ODBC, it prompt me the error message " Host 192.168.xxx.xxx is not allow to connect to mySQL server" What wrong with it?

Mysql Access Through ODBC
I have a Mysql table which has over 40000 records.
If i want to access from VB using ODBC connection.
will that be good choice related to performance wise.
or any other options there.

MySQL ODBC Connection
This is my first task with MySQL. We have a site with php as front end
MySql as back end. The remote database is on Linux.

Now my task is to update some data to MySql database (on the web
server) from VB. My operating system id Windows.

I installed the MySQL ODBC 3.51 driver on my system. Now when i'm
trying to create a DSN with the above driver, I'm getting an error '
Lost connection to MySQL server during query'.

What could be the reason...the same error is coming when tried to
create a ADO connection from VB.. and the same error when tried to
create a service from MySQL front end.

Win XP Missing MySQL ODBC 3.51
Windows XP sp2, Installed MyODBC 3.51 and the driver.
It does not appear in the User/System DSN ODBC control panel.
Does not appear in the driver tab
Is listed in the ODBCINST.INI
and appears in the registry

REGEDIT4
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMySQ L ODBC 3.51 Driver]
"UsageCount"=dword:0000000c
"Driver"="C:WINDOWSsystem32myodbc3.dll"
"Setup"="C:WINDOWSsystem32myodbc3S.dll"
"APILevel"="2"
"ConnectFunctions"="YYN"

Connecting To Mysql Vi ODBC
I'm trying to connect to a remote mysql database via odbc but for some reason I keep getting the following error in the odbc panel
Code:

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '69.65.107.209' (10060)

I added access to % in mysql access host for now to see if it might just work this way... but for some reason I can't get it working.

MySQL ODBC Connection
I am trying to connect to a MySQL database on our Linux Server using MS Access on a Windows 2000 machine and MySQL ODBC drivers.

Each time I try to connect I get the following error:

*****************************
ODBC --call failed.
[TCX][MyODBC]Host 'du-069-0221.access.clara.net' is not allowed to connect to this MySQL server (#1130)

*****************************