The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

I have installed a Sybase 12 DB Server Application 64Bit on a Win7 64Bit System and a old Sybase 7 DB. I created a 32Bit Sybase 7 ODBC Connection. I want to use this connection to link this DB to the Sybase 12 DB as a Proxy Server/Table. In Sybase Central I can create the Proxy Server but I can't connect to the Sybase 7 DB. I got an error message.

[Sybase][ODBC Driver][SQL Anywhere]Verbindung mit dem Server 'Kakom7Remote' konnte nicht aufgenommen werden: [Microsoft][ODBC Driver Manager] Der angegebene DSN weist eine nicht ├╝bereinstimmende Architektur von Treiber und Anwendung auf.

Are there any Sybase 7 ODBC driver for 64Bit or some other solution for this problem?

If I use a 32Bit System everything runs as desired...

asked 27 Sep '12, 01:50

ategeler's gravatar image

ategeler
75448
accept rate: 0%

edited 27 Sep '12, 03:38

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646


When using remote data access (aka proy tables) via ODBC, the database server requires an ODBC driver that has the same bitness as the database server, i.e. when running a 64-bit database server, it requires a 64-bit ODBC driver for the connection to the remote server. (Note: The bitness of the remote server itself doesn't matter at all.)

As there is no 64-bit SQL Anywhere v7 driver, I would think you can use the 64-bit SQL Anywhere 12 driver to connect to your v7 database. - AFAIK, SQL Anywhere is quite good at using different versions for server and client, and here the v12 server just acts as a database client for the v7 server.

More on the bitness requirements for remote data access can be found in Karim's answer in this FAQ.

permanent link

answered 27 Sep '12, 03:37

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646
accept rate: 32%

edited 27 Sep '12, 05:16

I have just created a test environment. I use the Sybase 12 ODBC 64 bit driver (dbodbc12.dll) to connect to my sybase 7 DB. Till now everything runs pretty well...

(27 Sep '12, 07:04) ategeler
Replies hidden
1

@ategeler: I've just turned your answer into a comment, as I think it is more of a comment - I hope you agree. (If you want to comment on a question/answer, there's the "add new comment" button under each question/answer...)

Glad you got it working:)

(27 Sep '12, 07:14) Volker Barth

I had the same Problem with a IBM DB2 Connection where the 64bit ODBC driver would not run stable in my environment.

A pragmatic solution was to have a second ASA 12 instance running in 32 bit. Create a proxy table in this instance to access the ASA7 Data by the 32bit ODBC driver. I mirror the data in a normal table in the 32bit instance.

As you have ASA 12 ODBC Driver in 64 bit you can access the ASA 12 32bit server engine by a proxy table in the 64bit engine.

I hope you can follow my thoughts. It is a pain but it works stable for me.

HTH

permanent link

answered 27 Sep '12, 06:23

Thomas%20Duemesnil's gravatar image

Thomas Dueme...
2.5k213458
accept rate: 16%

You are mixing a 64 Bit app with a 32 bit ODBC driver or vice versa. As you say, that you are using 32 bit ODBC it must be the program, so ensure that the program is compiled as 32 bit too.

permanent link

answered 27 Sep '12, 02:36

Martin's gravatar image

Martin
8.6k114149237
accept rate: 14%

I don't use any self developed applications, I just use the 64 Bit dbsrv.exe etc. to run the sybase 12 database and dbodbc7.dll etc. for the ODBC connection.

(27 Sep '12, 02:43) ategeler
Replies hidden
1

I meant the client process for the ODBC driver the client is the relevant application. So your 32 driver is called from a 64 bit dbsrv. See also Volkers answer, he has more elaborated on this situation.

(27 Sep '12, 06:48) Martin
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:

×405
×124
×62
×26
×13

question asked: 27 Sep '12, 01:50

question was seen: 3,636 times

last updated: 27 Sep '12, 07:14