Menu
▾
▴
dev-cpp-users
|
From: Terry O. <te...@st...> - 2004-11-24 19:49:31
|
I have a freshly loaded XP pro machine. Just downloaded 4.1 mysql from the mysql website. Downloaded 4.9.9.0 Dev-cpp from sourceforge and downloaded the mysql devpak from planetmirror. I set up a test database with a simple table and can access it from the mysql client. When I compile and run the mysqlclienttest that loads with the devpak I get =91Error: Unable to select database=92. Any ideas? |
|
From: Terry O. <te...@st...> - 2004-11-28 02:08:28
|
I have not set up a ODBC data source on my XP box. Do I need it? I had developed some programs using cygwin and mysql and never had to set up ODBC. |
|
From: P.D. v. Z. <pa...@di...> - 2004-11-28 12:05:37
Attachments:
smime.p7s
|
When using the MySQL C or C++ API, you certainly don't need an ODBC data source, since you are connecting to the MySQL server directly, without using ODBC. Terry Orgill wrote: > I have not set up a ODBC data source on my XP box. Do I need it? I had > developed some programs using cygwin and mysql and never had to set up > ODBC. > |
|
From: Terry O. <te...@st...> - 2004-11-28 05:22:01
|
Which version of mysql should I use with devpak 4.0.16? I have tried 4.0 and 4.1. Do I need to fall back into the 3.s? |
|
From: Terry O. <te...@st...> - 2004-12-01 19:40:09
|
I am still trying to get the mysql devpak 4.0.16 to work with mysql 4.1 on WinXP. If anyone is successfully using this combination, please send me a snippet of source or something so I can get rolling. I have gotten suggestions of how to change the mysqlclienttest but nothing is working. The mysql_real_connect works with a result of 0, but after that, nothing else works. |
|
From: Terry O. <te...@st...> - 2005-09-27 18:22:01
|
I am going to install dev-cpp and the mysql devpak on my laptop. I have had problems getting mysql to work with dev-cpp in the past. What version of mysql should I download? |
|
From: <jua...@ug...> - 2005-09-27 19:46:51
|
Hello, you can try this link but is in spanisk: http://c.conclase.net/mysql/index.php ----- Original Message -----=20 From: Terry Orgill=20 To: dev...@li...=20 Sent: Tuesday, September 27, 2005 8:23 PM Subject: [Dev-C++] mysql I am going to install dev-cpp and the mysql devpak on my laptop. I = have had problems getting mysql to work with dev-cpp in the past. What = version of mysql should I download? |
|
From: Reid T. <jre...@ea...> - 2005-09-28 03:29:09
|
Terry Orgill wrote: > I am going to install dev-cpp and the mysql devpak on my laptop. I > have had problems getting mysql to work with dev-cpp in the past. > What version of mysql should I download? > none ;) Install PostgreSQL instead. The install using the windows installer takes only a couple of minutes. http://www.postgresql.org/ftp/binary/v8.0.3/win32/postgresql-8.0.3.zip http://www.postgresql.org/docs/8.0/interactive/libpq.html provides information on how to use the libpq library ( there are also libs for C++ and embedded sql, etc described). The below sample program works with Dev-Cpp(It's from the www.postgresql.org.docs site). Create a new project. Set the below as main.c. Add $POSTGRESQL_HOME/$VERSION/lib/libpq.a to Project/Project Options/Parameters/Add Library or Object. Add $POSTGRESQL_HOME/$VERSION/include to include directories. ( I also attacehd the Dev-Cpp .dev and Makefile.win and main.c files) The default connection and cursor will list info related to the default Postgresql db template, template1 and it's table pg_database. The commented out conninfo and DECLARE CURSOR lines assume you have created a DB called test and it contains a table called test_table. If you're unfamiliar with PostreSQL, the the included PGADMIN III is an intuitive interface. And the www.postgresql.org.docs site has very good documentation. /* * testlibpq.c * * Test the C version of LIBPQ, the POSTGRES frontend library. */ #include <stdio.h> #include <stdlib.h> #include "libpq-fe.h" static void exit_nicely(PGconn *conn) { PQfinish(conn); system("PAUSE");/* I added this for Dev-CPP */ exit(1); } int main(int argc, char **argv) { const char *conninfo; PGconn *conn; PGresult *res; int nFields; int i, j; /* * If the user supplies a parameter on the command line, use it as * the conninfo string; otherwise default to setting dbname=template1 * and using environment variables or defaults for all other connection * parameters. */ if (argc > 1) conninfo = argv[1]; else conninfo = "hostaddr = 127.0.0.1 dbname = template1 user = postgres password = postgres"; //conninfo = "hostaddr = 127.0.0.1 dbname = test user = postgres password = postgres"; /* Make a connection to the database */ conn = PQconnectdb(conninfo); /* Check to see that the backend connection was successfully made */ if (PQstatus(conn) != CONNECTION_OK) { fprintf(stderr, "Connection to database failed: %s", PQerrorMessage(conn)); exit_nicely(conn); } /* * Our test case here involves using a cursor, for which we must be * inside a transaction block. We could do the whole thing with a * single PQexec() of "select * from pg_database", but that's too * trivial to make a good example. */ /* Start a transaction block */ res = PQexec(conn, "BEGIN"); if (PQresultStatus(res) != PGRES_COMMAND_OK) { fprintf(stderr, "BEGIN command failed: %s", PQerrorMessage(conn)); PQclear(res); exit_nicely(conn); } /* * Should PQclear PGresult whenever it is no longer needed to avoid * memory leaks */ PQclear(res); /* * Fetch rows from pg_database, the system catalog of databases */ res = PQexec(conn, "DECLARE myportal CURSOR FOR select * from pg_database"); //res = PQexec(conn, "DECLARE myportal CURSOR FOR select * from test_table"); if (PQresultStatus(res) != PGRES_COMMAND_OK) { fprintf(stderr, "DECLARE CURSOR failed: %s", PQerrorMessage(conn)); PQclear(res); exit_nicely(conn); } PQclear(res); res = PQexec(conn, "FETCH ALL in myportal"); if (PQresultStatus(res) != PGRES_TUPLES_OK) { fprintf(stderr, "FETCH ALL failed: %s", PQerrorMessage(conn)); PQclear(res); exit_nicely(conn); } /* first, print out the attribute names */ nFields = PQnfields(res); for (i = 0; i < nFields; i++) printf("%-15s", PQfname(res, i)); printf("\n\n"); /* next, print out the rows */ for (i = 0; i < PQntuples(res); i++) { for (j = 0; j < nFields; j++) printf("%-15s", PQgetvalue(res, i, j)); printf("\n"); } PQclear(res); /* close the portal ... we don't bother to check for errors ... */ res = PQexec(conn, "CLOSE myportal"); PQclear(res); /* end the transaction */ res = PQexec(conn, "END"); PQclear(res); /* close the connection to the database and cleanup */ PQfinish(conn); system("PAUSE"); /* I added this for Dev-CPP */ return 0; } |
|
From: Reid T. <rei...@at...> - 2005-09-28 03:37:26
|
Reid Thompson wrote: Sorry,, I hosed up the link for the download http://www.postgresql.org/ftp/binary/v8.0.3/win32/ |
|
From: Reid T. <rei...@at...> - 2004-11-25 04:01:03
|
Terry Orgill wrote: > I have a freshly loaded XP pro machine. Just downloaded 4.1 mysql from=20 > the mysql website. Downloaded 4.9.9.0 Dev-cpp from sourceforge and=20 > downloaded the mysql devpak from planetmirror. I set up a test=20 > database with a simple table and can access it from the mysql client.=20 > When I compile and run the mysqlclienttest that loads with the devpak=20 > I get =91Error: Unable to select database=92. Any ideas? > my guess is that it pertains to the change mysql made with regard to=20 user login/password -- http://rucus.ru.ac.za/docs/mysql/Old-client.html |
|
From: Mark L. W. <ma...@al...> - 2004-11-26 15:58:33
|
Have you set up an ODBC datasource DSN on your XP box??? Mark -----Original Message----- From: dev...@li... [mailto:dev...@li...]On Behalf Of Terry Orgi= ll Sent: Wednesday, November 24, 2004 2:58 PM To: dev...@li... Subject: [Dev-C++] mysql I have a freshly loaded XP pro machine. Just downloaded 4.1 mysql from the mysql website. Downloaded 4.9.9.0 Dev-cpp from sourceforge and downloaded the mysql devpak from planetmirror. I set up a test database with a simple table and can access it from the mysql client. When I comp= ile and run the mysqlclienttest that loads with the devpak I get =91Error: Un= able to select database=92. Any ideas? |
|
From: <go...@li...> - 2004-11-26 20:40:05
|
I had the same problem with the same configuration (XP, DDevCpp 4990) and mysql; so I switched and now I use the sqlite devpack it works fine but the database is integrated with the application.... Kind regards, > Have you set up an ODBC datasource DSN on your XP box??? > > Mark > -----Original Message----- > From: dev...@li... > [mailto:dev...@li...]On Behalf Of Terry > Orgill > Sent: Wednesday, November 24, 2004 2:58 PM > To: dev...@li... > Subject: [Dev-C++] mysql > > > I have a freshly loaded XP pro machine. Just downloaded 4.1 mysql fr= om > the mysql website. Downloaded 4.9.9.0 Dev-cpp from sourceforge and > downloaded the mysql devpak from planetmirror. I set up a test databas= e > with a simple table and can access it from the mysql client. When I > compile > and run the mysqlclienttest that loads with the devpak I get =91Error: > Unable > to select database=92. Any ideas? > |
