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"); > > > > > > > > > > > Has anyone tried this. I'm using the 4.0.4 beta > > source tree. > > > > __________________________________________________ > > Do you Yahoo!? > > Y! Web Hosting - Let the expert host your web site > > http://webhosting.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 > > > > > __________________________________________________ > 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 __________________________________________________ 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