The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

So I've got ASA8 running on a server and it has 2 databases - dmcc and rtm

If I try to connect from ISQL client or from a PHP app to either one, it's fine.

However, if I try connecting from ColdFusion (which connects via JDBC) I am suddenly getting dmcc, whichever datasource I try to connect to. If I shutdown dmcc, then I can connect to rtm, but if I have them both running, then I seem to get no say in which database the connection is to!

I think this is a fairly recent behaviour change. Any ideas what might be going on, and how I might deal with it?

asked 13 Mar, 11:17

alexlake's gravatar image

alexlake
1162615
accept rate: 12%

3

It is always best practice to specify both server and database name in connections. Otherwise, connections are being made to the default server and database - which can vary depending on the start order. We certainly have not made changes to ASA8 recently nor do I recall changes in our approach to resolving connections.

If you are not providing both the server and database name in your connection, I would start there. If you continue to have problems, please

1) Describe how you start the database server. Provide any command lines used (masking any sensitive info) 2) Provide the connection string used in Cold Fusion (if this is the only application having problems) 3) Ideally add LOG= to your connection parameters so that a debug log for the connection is created:

 LOG=<file_name_and_path>
(13 Mar, 11:35) Chris Keating

Thanks Chris.

I'm assuming that this is me not using JDBC quite correctly. The JDBC connection string from the client is jdbc:sybase:Tds:<serveraddress>:2638/rtm6000_m1011

The database name is "rtm6000_m1011" And the server name is "m1011" (although I guess not used, as it's the only one on <serveraddress>)

Does that look correct?

Alex

(14 Mar, 07:36) alexlake

OK - that was it! Thanks for focussing my thinking there. It's supposed to be jdbc:sybase:Tds:<serveraddress>:2638?ServiceName=rtm6000_m1011

How silly am I?

permanent link

answered 14 Mar, 07:42

alexlake's gravatar image

alexlake
1162615
accept rate: 12%

converted 14 Mar, 08:51

Chris%20Keating's gravatar image

Chris Keating
3.9k2268

I converted your response to an answer.

This is one of several differences in jConnnect behaviour depending on if you are using ASE based and SQL Anywhere based environments. jConnect was designed for use with ASE and required some changes in dealing with some aspects of SQL Anywhere. This is one example. Another relates to autostarting databases which applies only to SQL Anywhere. This uses the RemotePwd mechanism to pass connection parameters to SQL Anywhere.

(14 Mar, 08:58) Chris Keating
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×33

question asked: 13 Mar, 11:17

question was seen: 120 times

last updated: 14 Mar, 08:58