>From the mysql docs on the website (URL: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect)
The proto is: MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned int client_flag); I'm calling it as: mysql_real_connect(db, host, user, passwd, dbname, 0, NULL, CLIENT_COMPRESS); That should work, yes? My code is almost the exact same as the libmysqld example source here (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld_example) except after making the local connection, I try a remote connection afterwards. I can send code to anyone if they want, but the mailing list bounced my attachment when I tried to send the code to the list. - Steve - Steve --- Luc Foisy <[EMAIL PROTECTED]> wrote: > not sure if this applies here, its from the c++ api > docs (but why switch it around) > Do you have the parameters sent in the right order? > > // The full format for the Connection constructor > is > // Connection(cchar *db, cchar *host="", > // cchar *user="", cchar *passwd="") > > I really know nothing about the c, c++ api's, just > trying to help > > > -----Original Message----- > > From: Steven Webb [mailto:scumola@;yahoo.com] > > Sent: Tuesday, November 05, 2002 3:58 PM > > To: Black, Kelly W [PCS]; Mysql list > > Subject: RE: using libmysqld - can't connect to > remote DB as client. > > > > > > I am. See the original post: > > > > > > // Here's the remote connection - it > connects to > > > > the > > > > same local machine, not the remote machine. > > > > two = db_remote_connect > > > > ("remote_machine","remote","remote","dbname"); > > > > db_do_query(two, "SHOW DATABASES"); > > > > --- "Black, Kelly W [PCS]" > > <[EMAIL PROTECTED]> wrote: > > > So use the C syntx instead. > > > > > > :) > > > > > > -----Original Message----- > > > From: Steven Webb [mailto:scumola@;yahoo.com] > > > Sent: Tuesday, November 05, 2002 12:21 PM > > > To: Black, Kelly W [PCS]; Mysql list > > > Subject: RE: using libmysqld - can't connect to > > > remote DB as client. > > > > > > > > > Ok, but I'm writing this in C, not perl. > > > > > > - Steve > > > > > > --- "Black, Kelly W [PCS]" > > > <[EMAIL PROTECTED]> wrote: > > > > I think your problem might be here -> > > > > > > > > you have db_connect("my_blah_database"); > > > > Try using something like > > > > > > > > my $dbh = > > > DBI->connect("DBI:mysql:$dbname:hostname", > > > > $dbuser, $dbpasswd) || > > > > die "can't connect: $DBI::errstr\n"; > > > > > > > > Also make sure you include the || die "can't > > > > connect: $DBI::errstr\n"; > > > > as in this way you can get some useful error > > > output > > > > about the connect. > > > > > > > > Not certain but at least I am trying to help > :) > > > > > > > > Oh and don't forget sql query! :) > > > > > > > > ~Kelly W. Black > > > > > > > > > > > > -----Original Message----- > > > > From: Steven Webb [mailto:scumola@;yahoo.com] > > > > Sent: Tuesday, November 05, 2002 11:20 AM > > > > To: Mysql list > > > > Subject: Re: using libmysqld - can't connect > to > > > > remote DB as client. > > > > > > > > > > > > Still nobody has answered my question. > > > > > > > > Has anyone here even tried linking with > > > libmysqld.a > > > > before? > > > > > > > > - Steve > > > > > > > > --- Steven Webb <[EMAIL PROTECTED]> wrote: > > > > > Nobody answered my question, so I felt like > I > > > > should > > > > > ask again ... > > > > > > > > > > I'm using libmysqld to embed a mysql server > in > > > my > > > > C > > > > > app. However, I'd also like to connect to > other > > > > > remote mysql databases as well, but the > > > > > "mysql_real_connect" command doesn't seem to > be > > > > > working when trying to connect to a remote > > > > database > > > > > in > > > > > the same app as the libmysqld stuff. The > > > connect > > > > > works, but I think that it's connecting to > my > > > > local > > > > > database and not the remote one. Here's a > > > little > > > > > code: > > > > > > > > > > mysql_server_init(sizeof(server_args) / > > > > > sizeof(char > > > > > *), server_args, server_groups); > > > > > > > > > > // Here's the embedded database. This > works. > > > > > one = db_connect(NULL); > > > > > db_do_query(one, "CREATE DATABASE > > > > > my_blah_database"); > > > > > mysql_close(one); > > > > > one = db_connect("my_blah_database"); > > > > > db_do_query(one, "create table blank (num > > > > int)"); > > > > > mysql_close(one); > > > > > > > > > > /* This must be called after all other > mysql > > > > > functions */ > > > > > mysql_server_end(); > > > > > > > > > > // Here's the remote connection - it > connects > > > to > > > > > the > > > > > same local machine, not the remote machine. > > > > > > two = db_remote_connect > > > > > > ("remote_machine","remote","remote","dbname"); > > > > > db_do_query(two, "SHOW DATABASES"); > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
