SQLA 9.0.2 on 64-bit Windows 7

[ALF]

Hello all - I've installed the 32 bit client of SQLA 9.0.2 on 64-bit
Windows 7 and the Sybase client can't find the server (which is
running on a 32-bit Windows XP Professional PC) - even with a
dblocate.exe 1.1.1.1 (using IP address of server). "No servers
found." is the result.

This configuration works at my office - just not at a client's. And
other PCs running this client on other Windows XP PCs can see the
server just fine. Any ideas?

[R. Pods]

We've had a similar problem with Windows 7. First thing would be to
check the firewall settings, even temporarily disabling it. What solved
the issue for us was setting HOST=<Server IP> in the ODBC TCP/IP
configuration.

HTH
Reimer

[Jeff Albion [Sybase iAnywhere]]

Hi ALF,

The database server location mechanism relies on UDP broadcasts working
between machines. (i.e. The client sends out a UDP broadcast looking for
a server, the server listening on its own UDP port, responds via UDP
back to the client).

If this mechanism isn't working specifically for clients on Windows 7,
I'd try looking for reasons that mechanism might be not working at the
OS level (including UAC security settings, and as Reimer suggested, the
Windows Firewall settings -
http://windows.microsoft.com/en-US/windows7/products/features/windows-firewall

).

---

If you can't locate the server via UDP, you might be able to still
connect via TCP. This can be specified on the client's connection
string, by using the LINKS connection parameter:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbdaen9/00000235.htm

LINKS=TCPIP(HOST=1.1.1.1;PORT=2638;DOBROAD=NONE)

---

A final note, we still have not announced official support for 9.0.2 on
Windows 7: http://www.sybase.com/detail?id=1002288

This support is still currently being evaluated by engineering.

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

[Robert Paresi]

Jeff,

I am sorry it took this long to get back to you.

There is nothing at all in the EVENT VIEWER.

This is what we see:

dbunload -v -c
"UID=dba;PWD=***;DBF=C:\Databases\christyv13\roommaster.db;DBKEY=ZQWUPHGI5380"
-an "C:\DB\roommaster.db" -ap 4096 -ea None -ii -sa -so _sc638416845

An error occurred while attempting to unload the database
'C:\Databases\christyv13\roommaster.db'.

But, the exact thing works just fine on my WIN7 32-BIT machine with the
exact same version loaded.

-Robert

"Jeff Albion [Sybase iAnywhere]" <firstname...@ianywhere.com> wrote in
message news:4b191f67$1@forums-1-dub...

[Chris Keating (Sybase iAnywhere)]

Check for the dll dbtools11.dll in your BIN32 directory and if it is it
, make sure that it can be loaded by Sybase Central i.e., no Windows 7
security issues that impede its use.

BTW I have tested this and can only reproduce this problem when
components of the BIN32 are missing - recall that SC is a 32 bit
application and needs 32 bit libraries to run.

-chris

[Reg Domaratzki [Sybase iAnywhere]]

Chris Keating (Sybase iAnywhere) wrote:
> Check for the dll dbtools11.dll in your BIN32 directory

Chris had a minor typo in the DLL name. It's actually called
"dbtool11.dll".

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"

[Robert Paresi]

The dbtool11.dll was not in my BIN32 directory. It was in the BIN64
directory.

I copied the dbtool11.dll into the BIN32 directory (did not remove it from
BIN64, so it is currently in both places) and I still receive the same error
when attempting to unload.

-Robert

"Reg Domaratzki [Sybase iAnywhere]" <firstname...@ianywhere.com> wrote
in message news:4b2b9358$1@forums-1-dub...

[Chris Keating (Sybase iAnywhere)]

Again, you need the 32 bit version. You copied the 64 bit version. You
might need to reinstall the 32bit components.

-chris

[Robert Paresi]

Besides...what do you mean "reinstall the 32-bit components".

This is a 64-bit OP system, and I downloaded the 64-bit Installation from
Sybase and installed it, and EBF'ed it.

Why am I having to do now a 32-bit installation on this machine too? or why
are we talking about 32-bit to make the UNLOAD work?

What am I missing here?

-Robert

"Robert Paresi" <firs...@lastname.net> wrote in message
news:4b2ba291$1@forums-1-dub...
> Hi,
>
> I'm lost - why am I copying in the 32-bit components??
>
> Isn't this the 64-bit version of Sybase SQL Anywhere?
>
> Why am I using 32-bit components to make this work? I guess it's not
> really 64-bit or something?
>
> I'm confused. Is this not a 64-bit application?
>
> -Robert
>
> "Chris Keating (Sybase iAnywhere)" <keating...@sybase.com> wrote in
> message news:4b2ba059$1@forums-1-dub...

[Robert Paresi]

Hi,

I'm lost - why am I copying in the 32-bit components??

Isn't this the 64-bit version of Sybase SQL Anywhere?

Why am I using 32-bit components to make this work? I guess it's not really
64-bit or something?

I'm confused. Is this not a 64-bit application?

-Robert

"Chris Keating (Sybase iAnywhere)" <keating...@sybase.com> wrote in
message news:4b2ba059$1@forums-1-dub...

[Chris Keating (Sybase iAnywhere)]

Sybase Central is a 32 bit application and therefore needs 32 bit
components for any libraries that it needs to access. These files should
have been installed and I cannot tell you why those were not.

[Jeff Albion [Sybase iAnywhere]]

Robert,

The JRE (Java Runtime Environment) used by Sybase Central is only
32-bit, making both Sybase Central and Interactive SQL both 32-bit
applications. (Noted under this footnote:
http://www.sybase.com/detail?id=1026234#footnotes_6 ). This is true for
all platforms on version 9, 10 and 11, except on SA 11 for Mac where
there was no 32-bit JRE, so we had to move to a 64-bit JRE. (Noted here:
http://www.sybase.com/detail?id=1062080#SA )

So, when Sybase Central calls "dbunload", it can only call the 32-bit
version of dbunload. If you copied the dbtool11.dll from the \bin64
directory, this is the 64-bit version and cannot be loaded by the 32-bit
Sybase Central application. You'll need the original \bin32\dbtool11.dll
file in-place before the unload from Sybase Central will work.

The server components, client libraries, and command-line utilities are
all compiled for 64-bit.

Regards,

Robert Paresi wrote:
> I'm lost - why am I copying in the 32-bit components??
>
> Isn't this the 64-bit version of Sybase SQL Anywhere?
>
> Why am I using 32-bit components to make this work? I guess it's not
> really 64-bit or something?
>
> I'm confused. Is this not a 64-bit application?

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals

SQL Anywhere Patches and EBFs :

[Robert Paresi]

Ok,

So I took that DLL from my 32-bit machine, copied it in, and it worked.

So --- from the looks of it, the 64-bit installation did not put that dll in
the 32-bit directory, nor did the EBF.

The only way to do that was to take that DLL from my 32-bit machine and
manually put it there.

Shouldn't the installation have done that for me?

-Robert

"Chris Keating (Sybase iAnywhere)" <keating...@sybase.com> wrote in

message news:4b2ba455@forums-1-dub...

[Chris Keating (Sybase iAnywhere)]

Please read my previous post which stated:

"These files should have been installed and I cannot tell you why those
were not."

For me, the install of 11.0.1 x64 put down all the files as expected
(32bit and 64bit). The only way I could reproduce the error that you
posted was by deleting the file dbtool11.dll from bin32.

Can you walk us through your install process in case it is different
from the steps that I did.

-chris

[Robert Paresi]

Hi,

First ... I downloaded the installation file from OEM webpage (11.01) and
installed it. I then put any EBF in. It's that simple.

I didn't delete any file - that's for sure.

This is a brand new box (brand new) that came with Windows 7 installed on
it. I then installed the 11.01 from the Sybase downloads page using our OEM
license.

-Robert

"Chris Keating (Sybase iAnywhere)" <keating...@sybase.com> wrote in

message news:4b2ba8ef@forums-1-dub...

[Chris Keating (Sybase iAnywhere)]

That is what I did also.

If you continue to have problems with this install, you will likely need
to work with support to troubleshoot.

-chris

[Chris Keating (Sybase iAnywhere)]

I guess one thing that could be different is the registration key used
to install initially. If that is the difference, best to work directly
with someone since the key should not be posted here.

-chris