Hi Forum.

we have a problem with the dbeng12.exe. Version: SQL Anywhere 12.0.1 build 3742 I try to explain with my 'perfekt' english: We want to start two programs, named ProgA and ProgB. Both programs has his own DSN entry, which was created with the ODBC-Admin. For ProgA in the DSN we start the dbeng12.exe with the ProgA.db For ProgB in the DSN we start the dbeng12.exe with the ProgB.db

Now the Problem: The start of ProgA and the ProgA.db were succesful. If we start now ProgB, we get the message that the connection to the ProgB.db database was not possible. If I shutdown the ProgA, than I could start ProgB. But not both together at the same time. But: If I starts ProgA and starts only the dbengine without opening the ProgB.db, after that I could start ProgB, because the engine is already running.

(I have the same Problem if I use the 'Test-Connection-Button in the ODBC-Admin instead of ProgB)

Any idea?

Thanks for all help.

Michael

asked 27 Oct '12, 14:48

Michael1965's gravatar image

Michael1965
46114
accept rate: 0%

edited 15 Mar '13, 21:08

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


I can't test this at the moment, so it's a guess, but I think that the server name (ENG parameter) may be causing the problem. You could try this:

DSN A: eng=C;dbf=full\path\to\ProgA.db;dbn=ProgA;uid=...;pwd=...
DSN B: eng=C;dbf=full\path\to\ProgB.db;dbn=ProgB;uid=...;pwd=...

The shared ENG parameter means that they both use the same engine. The full path to each database file ensures that the engine can find the file.

permanent link

answered 27 Oct '12, 19:01

Tom%20Slee's gravatar image

Tom Slee
1.3k21629
accept rate: 29%

Try to specify 2 different ports for each database.

permanent link

answered 27 Oct '12, 22:39

Zote's gravatar image

Zote
1.7k364051
accept rate: 43%

Hi.

Thanks for all ideas. It is solved. I installed the 'Express Bug Fix, Update of 12.0.1 to build 3769' and it works. My DSN were OK.

Thanks again...

permanent link

answered 28 Oct '12, 13:27

Michael1965's gravatar image

Michael1965
46114
accept rate: 0%

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:

×438
×159
×17

question asked: 27 Oct '12, 14:48

question was seen: 3,492 times

last updated: 15 Mar '13, 21:08