dbTalk Databases Forums  

SQLA 9.0.2 on 64-bit Windows 7

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss SQLA 9.0.2 on 64-bit Windows 7 in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ALF
 
Posts: n/a

Default SQLA 9.0.2 on 64-bit Windows 7 - 12-03-2009 , 05:30 PM






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?

Reply With Quote
  #2  
Old   
R. Pods
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-04-2009 , 03:28 AM






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

ALF wrote:
Quote:
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?

Reply With Quote
  #3  
Old   
Jeff Albion [Sybase iAnywhere]
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-04-2009 , 09:40 AM



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/w...ndows-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/p...9/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,

ALF wrote:
Quote:
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?
--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Reply With Quote
  #4  
Old   
Robert Paresi
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-17-2009 , 04:32 PM



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\roomm aster.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.lastname (AT) ianywhere (DOT) com> wrote in
message news:4b191f67$1 (AT) forums-1-dub (DOT) ..
Quote:
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/w...ndows-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/p...9/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,

ALF wrote:
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?

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Reply With Quote
  #5  
Old   
Chris Keating (Sybase iAnywhere)
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-17-2009 , 07:12 PM



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


Robert Paresi wrote:
Quote:
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\roomm aster.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.lastname (AT) ianywhere (DOT) com
wrote

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/w...ndows-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/p...9/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,

ALF wrote:
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?

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0

Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Reply With Quote
  #6  
Old   
Reg Domaratzki [Sybase iAnywhere]
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-18-2009 , 09:36 AM



Chris Keating (Sybase iAnywhere) wrote:
Quote:
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"

Reply With Quote
  #7  
Old   
Robert Paresi
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-18-2009 , 10:18 AM



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.lastname (AT) ianywhere (DOT) com> wrote
in message news:4b2b9358$1 (AT) forums-1-dub (DOT) ..
Quote:
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"

Reply With Quote
  #8  
Old   
Chris Keating (Sybase iAnywhere)
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-18-2009 , 10:31 AM



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

-chris


Robert Paresi wrote:
Quote:
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.lastname (AT) ianywhere (DOT) com
wrote

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"

Reply With Quote
  #9  
Old   
Robert Paresi
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-18-2009 , 10:41 AM



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_nospam (AT) sybase (DOT) com> wrote in
message news:4b2ba059$1 (AT) forums-1-dub (DOT) ..
Quote:
Again, you need the 32 bit version. You copied the 64 bit version. You
might need to reinstall the 32bit components.

-chris


Robert Paresi wrote:
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.lastname (AT) ianywhere (DOT) com
wrote

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"

Reply With Quote
  #10  
Old   
Robert Paresi
 
Posts: n/a

Default Re: SQLA 9.0.2 on 64-bit Windows 7 - 12-18-2009 , 10:43 AM



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" <firstname (AT) lastname (DOT) net> wrote

Quote:
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_nospam (AT) sybase (DOT) com> wrote in
message news:4b2ba059$1 (AT) forums-1-dub (DOT) ..
Again, you need the 32 bit version. You copied the 64 bit version. You
might need to reinstall the 32bit components.

-chris


Robert Paresi wrote:
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.lastname (AT) ianywhere (DOT) com
wrote

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"

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.