Running the jds on a server?

[Magnus]

Hi,

I have an app that use jds and as it is setup now it is expected that
the jar, bat, properties and jds files are in the same directory.

Connection to jds is set to:
driver=com.borland.datastore.jdbc.DataStoreDriver
url=jdbc:borland:dslocal:

Can I place my jds-files on another computer and connect to that?

I have tried with MySQL and the url set to: url=jdbc:mysql://IP:portno/

It's a single user license of JData Store 7.

Thanks

[Lori M Olson [TeamB]]

url= jdbc:borland:dsremote://remotehost/path-to-jds-file

Of course, you have to actually START the JdsServer process on that
remotehost machine, so that it is listening on the default port (2508)
for connections.

The connection URL's, etc, are all detailed in JBuilder's help files.

--

Regards,

Lori Olson [TeamB]

------------

Save yourself, and everyone else, some time and search the
newsgroups and the FAQ-O-Matic before posting your next
question.

Google Advanced Newsgroup Search
http://www.google.ca/advanced_group_search
Other Newsgroup Searches:
http://www.borland.com/newsgroups/ngsearch.html
Joi Ellis's FAQ-O-Matic:
http://www.visi.com/~gyles19/fom-serve/cache/1.html

[Magnus]

>>
>> Connection to jds is set to:
>> driver=com.borland.datastore.jdbc.DataStoreDriver
>> url=jdbc:borland:dslocal:
>>
>

> url= jdbc:borland:dsremote://remotehost/path-to-jds-file
>
> Of course, you have to actually START the JdsServer process on that
> remotehost machine, so that it is listening on the default port (2508)
> for connections.
>
> The connection URL's, etc, are all detailed in JBuilder's help files.
>

Thanks Lori.

I have tried the following:

url= jdbc:borland:dsremote://OTHER_PC_NAME/c:/Program Files/MYPGM/mypgm.jds

and

url= jdbc:borland:dsremote://localhost/y:/Program Files/MYPGM/mypgm.jds
(when the OTHER_PC_NAME's C is mapped to Y).

I have shut down both firewalls but I always get:

connectNow-e:com.borland.datastore.driver.SqlState: Network Error:
Connection refused: connect

What can the problem be?

[Lori M Olson [TeamB]]

Magnus wrote:

> Thanks Lori.
>
> I have tried the following:
>
> url= jdbc:borland:dsremote://OTHER_PC_NAME/c:/Program Files/MYPGM/mypgm.jds
>
> and
>
> url= jdbc:borland:dsremote://localhost/y:/Program Files/MYPGM/mypgm.jds
> (when the OTHER_PC_NAME's C is mapped to Y).
>
> I have shut down both firewalls but I always get:
>
> connectNow-e:com.borland.datastore.driver.SqlState: Network Error:
> Connection refused: connect
>
> What can the problem be?

You didn't actually confirm that you started the JdsServer process on
OTHER_PC_NAME or localhost...

Assuming you have done this, the easiest way I know of confirming that
it is up and working, is using telnet -

telnet OTHER_PC_NAME 2508

Also, I would try to get this working with a path that HAS NO SPACES.

[David Orriss, Jr. [TeamB]]

On Tue, 18 Oct 2005 21:42:19 -0400, Magnus wrote:

> What can the problem be?

Can you verify that the JDataStore is actually running on the server you
are trying to connect to? How exactly are you starting it?

--
David Orriss Jr. TeamB
http://www.davenet.net/
* Please limit all responses to the newsgroups. Thanks! *
Got a JBuilder website? Join the JBuilder Netring! Check out
http://www.davenet.net/jbwebring/jbwebring.htm for more information!

My blog: http://mywebpages.comcast.net/daorriss/

Save yourself some time and check these sites:

Borland Newsgroup Search:
http://www.borland.com/newsgroups/ngsearch.html
Joi Ellis's Faq-O-Matic:
http://www.visi.com/~gyles19/fom-serve/cache/1.html

[Magnus]

>>
>> I have tried the following:
>>
>> url= jdbc:borland:dsremote://OTHER_PC_NAME/c:/Program
>> Files/MYPGM/mypgm.jds
>>
>> and
>>
>> url= jdbc:borland:dsremote://localhost/y:/Program Files/MYPGM/mypgm.jds
>> (when the OTHER_PC_NAME's C is mapped to Y).
>>
>> I have shut down both firewalls but I always get:
>>
>> connectNow-e:com.borland.datastore.driver.SqlState: Network Error:
>> Connection refused: connect
>>
>> What can the problem be?
>
>
> You didn't actually confirm that you started the JdsServer process on
> OTHER_PC_NAME or localhost...
>
> Assuming you have done this, the easiest way I know of confirming that
> it is up and working, is using telnet -
>
> telnet OTHER_PC_NAME 2508
>
> Also, I would try to get this working with a path that HAS NO SPACES.
>

When the db-files reside on the same PC as the app is running I don't
"start" anything. I just connect as described. This is the preferred way
for this application since the users would have no clue on how to have a
db-server up and running. What they want is just to have the db-files on
a PC with scheduled backup and power backup etc.

Question: If I start the jds server, as a test, wouldn't it be a
conflict with the number of users for the single user license? If I open
the db using jds Explorer I can't start my app because the db is already
open.

[Lori M Olson [TeamB]]

Magnus wrote:

> When the db-files reside on the same PC as the app is running I don't
> "start" anything. I just connect as described. This is the preferred way
> for this application since the users would have no clue on how to have a
> db-server up and running. What they want is just to have the db-files on
> a PC with scheduled backup and power backup etc.
>

If you are using jdbc:borland:dsremote as the URL protocol then you MUST
use JdsServer, whether the files live on the same machine or not. If
you don't want to use JdsServer, then you MUST use jdbc:borland:dslocal
as the URL protocol.

> Question: If I start the jds server, as a test, wouldn't it be a
> conflict with the number of users for the single user license? If I open
> the db using jds Explorer I can't start my app because the db is already
> open.

JdsServer allows remote access to your database. If you connect with
JdsExplorer, then that is one connection, and you can't start another.
If you connect with your application, then that is one connection and
you can't start another. If there is only one connection to JdsServer,
then ...

[Magnus]

Lori M Olson [TeamB] wrote:
>
> If you are using jdbc:borland:dsremote as the URL protocol then you MUST
> use JdsServer, whether the files live on the same machine or not. If
> you don't want to use JdsServer, then you MUST use jdbc:borland:dslocal
> as the URL protocol.
>

Thanks Lori,

After your and others help I did some testing and it turned out to be so
simple as to map the network drive and give the path after dslocal (i.e
...:dslocal:z/dbdir/). Somehow I thought it had to be a remote connection.