JDBC Question [Using Multiple databases]

2003-03-19 Thread Mark C. Roduner, Jr.
t my method obviously fails, is there any way to make the MySQL JDBC driver allow SQL queries to use a database other than the current one? (Other than using 'USE [DATABASE]') Any tips or workarounds would be greatly appreciated. Thank you in Advance: Mark C. Roduner, Jr. (

Quick Question about Authentication

2003-03-20 Thread Mark C. Roduner, Jr.
for moving the databases to other servers, ect. I'm using JDBC as my connectivity API, and I can't find a description for functionality of this type... Thanks in Advance, Mark C. Roduner, Jr. (Again, I Apologize for the Idiot Bug in my last post, Really do feel bad

RE: Your professional opinion Please...

2003-03-25 Thread Mark C. Roduner, Jr.
ular expressions, and PHP (v4.x) for the search program (easier UI). Mark C. Roduner, Jr. Medical Systematics Research -Original Message- From: Brian [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 3:12 PM To: Peter L. Berghold Cc: MySQL Subject: Re: Your professional opinion Please

RE: JDBC can't connect, but command line can...

2003-04-02 Thread Mark C. Roduner, Jr.
Here's The Deal :) To Pass a username and Password via JDBC, you should pass it in the 'url' string... Try this : DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=[user ]&password=[pass]"); I Find it's about the most reliable Way to go :) _/_/_/_/ _/_/_/_/ +---Research Progra