Does that URL work if you carefully delete the IP address and use localhost? Don't paste in the other URL, just edit the one that does not work. Yes, I am wondering you have a typing mistake we are not seeing. :-)

My understanding of how JDBC works is that it instantiates the driver on the local machine and then connects to the database on the remote machine. So, regardless of whether the server is identified as localhost or 1.2.3.4, it should find and load the same jar from the same place.

I also wonder if EOModeler is mis-reporting this exception. Have you tried running your app with this URL? What do you get out of it? There is a JDBC connection analyzer class in Practical WebObjects. I'd put that in my app, use the IP address URL, and see what it says is wrong. It is pretty good at pinpointing where things go astray.

Can you connect to 192.168.1.101 from FrontBase Manager? Try to monitor databases on that address.


Chuck



On Aug 23, 2007, at 6:59 PM, Baiss Eric Magnusson wrote:

Ken, I tried the name initially.

The message EOModeler throws: <No suitable driver> seems to say to me that it is looking and can't find the <system> call it wants to invoke. What kind of call is that?

I'll be steamed if I wander into the same mess that non-Direct Connect got me into, after a month of trying with lots of help from Art Isbell we both gave up and I run in Direct Connect mode only.

How is that URL decomposed that starts with <jdbc:FrontBase://...>?

On Aug 23, 2007, at 11:42 AM, Ken Anderson wrote:

You might have to use a hostname instead of an IP address, depending on how smart it is... Try defining a hostname with that IP and using the name instead.

On Aug 23, 2007, at 2:38 PM, Chuck Hill wrote:

On Aug 23, 2007, at 11:07 AM, Baiss Eric Magnusson wrote:

What does the URL look like for the <JDBC Connection> of EOModeler for connecting to a different computer on the same sub- net? I want to run my WebObjects application server on one computer and have the database be on a different computer. This is for development initially but, of course, I need to do it for deployment eventually.

Normally URL is
<jdbc:FrontBase://localhost/DB_Name/user=_SYSTEM/ dbpasswd=************>

I tried
<jdbc:FrontBase://192.168.1.101/DB_Name/user=_SYSTEM/ dbpasswd=**********>
but that gives
        <No suitable driver>.

That format looks correct to me.

Chuck
----
Baiss Eric Magnusson
<http://www.Track-Your-Finances.com>
<http://www.CascadeWebDesign.com>




--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects





_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to