Is it possible to have Sybase ASA 9 and Sybase ASA 12 coexisting on the same physical server.

asked 06 May '13, 22:15

Datagaard's gravatar image

Datagaard
2658919
accept rate: 0%

edited 13 May '13, 14:22

Mark%20Culp's gravatar image

Mark Culp
22.9k9129269

Thanks for the comments. Are there any issues with ODBC connectivity due to Sybase 12 drivers overwriting Sybase 9 drivers?

(07 May '13, 20:45) Datagaard
Replies hidden

No - ODBC drivers are registered underneath individual "ODBC Drivers" entries in the HKLM\Software\ODBC\ODBCINST.INI registry key ("Adaptive Server Anywhere 9" and "SQL Anywhere 12") on Windows, and separate ODBC.INI driver entries on Linux/UNIX.

(13 May '13, 13:37) Jeff Albion

Absolutely, even v9, v10, v11, v12 and v16 at the same time. They all install into different directory, by default of course, C:\ProgFiles\SQL Anywhere X, and also they all have different env. variables: SQLANY10, SQLANY11 etc.. which makes this happen pretty easily ;)

Just make sure when using utilities like dbinit, that you use the whole path to the correct version of the utility, as they dont include numeric suffix of the version, when compared with i.e. dbsrv12 or dbeng12..

cheers.

permanent link

answered 07 May '13, 02:27

marchello's gravatar image

marchello
3702614
accept rate: 14%

edited 07 May '13, 08:47

Mark%20Culp's gravatar image

Mark Culp
22.9k9129269

1

Thanks for the comments. Are there any issues with ODBC connectivity due to Sybase 12 drivers overwriting Sybase 9 drivers?

(07 May '13, 20:45) Datagaard
Replies hidden
1

No, SQL Anywhere ODBC drivers do not overwrite each other (they are installed in different folders by default and are listed as separate drivers in the ODBC settings). When you define an ODBC DSN, you explicitly choose which driver version you use.

(09 May '13, 06:19) Volker Barth

I have used this many times with different versions of ASA. When we upgarde our server we install the new version side by side with the existing one. That way we can run test with the new engine.

What you should be aware of is that some Environment Variables are not version specific. And that when you have batch files the win32 folder is bin32 in ASA 12

Also when you define the services in Sybase Central you will see all Services of all installed ASA Instances.

Otherwise no problem at all.

permanent link

answered 07 May '13, 02:29

Thomas%20Duemesnil's gravatar image

Thomas Dueme...
2.5k233560
accept rate: 15%

some Environment Variables are not version specific

Which ones do you refer to? SQLCONNECT, SQLREMOTE, ...? (These must be set manually, so won't be messed up by an installation, methinks...)

(07 May '13, 03:38) Volker Barth
1

Volker you are right that these variables are not set by Installation. But if you use them they are used for all Instance. SATMP (ASTMP), SQLPATH.

I use SATMP and have not expierienced any problems when to different Server instances use the same temporary directory.

(07 May '13, 04:59) Thomas Dueme...
Replies hidden

Good catch, Thomas!

I had the same reaction Volker did ("what the $%@# is he talking about?") but it's true, there are a SACKLOAD of colliding environment variables.

For example, suppose you run SQL Anywhere 12 and 16 side-by-side. Most of the SQL Anywhere environment variables for Version 12 are the same as those for Version 16.

(07 May '13, 05:28) Breck Carter

@Breck: Personally, I can't remember that "what the $%@# is he talking about?" reaction... Nevertheless, the topic may be more subtle and error-prone than expected (by myself) - "WTF":)

(07 May '13, 09:12) Volker Barth

OK, then it was just ME thinking "what the ... " :)

(07 May '13, 14:05) Breck Carter

As part of Foxhound testing, I regularly have V5.5, 6, 7, 8, 9, 10, 11, 12 and 16 running on the same Windows 7 box at the same time.

Volker and Thomas have noted the issues, with "dbinit.exe has the same name in all versions" being the only one that has ever affected me.

FWIW V5.5 doesn't like running on Windows 7 very much...

...kind of like running a lawnmower on nitromethane, it runs really FAST for a while and then explodes :)

Or...

alt text

permanent link

answered 07 May '13, 05:41

Breck%20Carter's gravatar image

Breck Carter
25.6k427586844
accept rate: 20%

edited 07 May '13, 06:07

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:

×409
×11
×6

question asked: 06 May '13, 22:15

question was seen: 1,266 times

last updated: 13 May '13, 14:22