What is error "SQLSTATE=08001"? Any resources?
Chet Boggs
Copyright © 2002-2006, iAnywhere Solutions, Inc.
Portions copyright © 1988-2006, Sybase, Inc.
All rights reserved. All unpublished rights reserved.
This software contains confidential and trade secret information of
iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and documentation
by the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and iAnywhere Solutions, Inc. or
other written agreement specifying the Government's rights to use the
software and any applicable FAR provisions, for example, FAR 52.227-19.
iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA
2 logical processor(s) on 1 physical processor(s) detected.
Networked Seat (per-seat) model. Access to the server is limited to 5
seat(s).
This server is licensed to:
J*** S***
***
Running Windows XP Build 2600 Service Pack 2 on X86
Server built for X86 processor architecture
8192K of memory used for caching
Minimum cache size: 8192K, maximum cache size: 932184K
Using a maximum page size of 4096 bytes
Starting database "sweet" (D:\SoftEssentials\Vending Essentials\sweet.db) at
Wed Dec 27 2006 15:49
Starting checkpoint of "sweet" (sweet.db) at Wed Dec 27 2006 15:49
Finished checkpoint of "sweet" (sweet.db) at Wed Dec 27 2006 15:49
Database "sweet" (sweet.db) started at Wed Dec 27 2006 15:49
Database server started at Wed Dec 27 2006 15:49
Trying to start SharedMemory link ...
SharedMemory link started successfully
Trying to start TCPIP link ...
Starting on port 2638
TCPIP link started successfully
Trying to start SPX link ...
SPX communication link not started
Now accepting requests
( ****************************************** End of Server Communication
************************************* )
(Using Interactive SQL) . workstation finds server:
Connection succeeded.
Wed Dec 27 2006 16:06:32
16:06:32 Attempting to connect using:
UID=vendor;PWD=********;DBF='\\Acer\ACERDATA (D)\SoftEssentials\Vending
Essentials\Sweet.db';ENG=sweet;CON=SQL_DBC_4304820;LOG=C:\DOCUME~1\OWNER~1.***\LOCALS~1\Temp\testcon27174.tmp;LINKS=all
16:06:32 Attempting to connect to a running server...
16:06:32 Trying to start SharedMemory link ...
16:06:32 SharedMemory link started successfully
16:06:32 Attempting SharedMemory connection (no sasrv.ini cached address)
16:06:32 Failed to connect over SharedMemory
16:06:32 Removing failed address from sasrv.ini cache
16:06:32 Trying to start TCPIP link ...
16:06:32 TCP using Winsock version 2.2
16:06:32 My IP address is ***.***.*.**
16:06:32 My IP address is ***.*.*.*
16:06:32 My IP address is ::1
16:06:32 TCPIP link started successfully
16:06:32 Trying to start SPX link ...
16:06:32 Loading wsock32.dll
16:06:32 Unable to open IPX socket
16:06:32 SPX communication link not started
16:06:32 Attempting TCPIP connection (no sasrv.ini cached address)
16:06:32 Looking for server with name sweet
16:06:32 Sending broadcast to find server
16:06:32 Using broadcast address of: ***.***.*.***:2638
16:06:32 Sending broadcast to find server
16:06:32 Using broadcast address of: ***.***.255:2638
16:06:32 Sending broadcast to find server
16:06:32 Using broadcast address of: (ff02::1):2638
16:06:32 Found database server at address ***.***.*.**:2638
16:06:32 Found database server sweet on TCPIP link
16:06:32 Connected using client address ***.***.*.**:2660
16:06:32 Connected to server over TCPIP at address ***.***.*.**:2638
16:06:32 Writing server address ***.***.*.**:2638 to sasrv.ini cache
16:06:32 Connected to SQL Anywhere Server version 10.0.0.2744
16:06:32 Application information:
16:06:32 IP=192.168.1.20;HOST=WS2;OS='Windows XP Build 2600 Service Pack
2';PID=0xaa4;THREAD=0xa0;EXE='C:\Program Files\SQL Anywhere
10\win32\dbisqlg.exe';VERSION=10.0.0.2465;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300
16:06:32 Connected to the server, attempting to connect to a running
database...
16:06:32 [ 7] Connected to database successfully
( ++++++++++++++ End of Workstation Communication +++++++++++++++++++++ )
When I attempt to start VE (an .exe file) from the workstation, I get the
following error message (every time):
The database returned an error of "SQLSTATE = 08001 [Sybase] [ODBC Driver]
[Adaptive Server Anywhere] unable to connect to database server: Database
server not found"
(Using Breck's advice - IP Addresses have been ommitted w/ ***)
Stephen Rice
through the database using ODBC failed. It's Microsoft's error message so I
won't apologize :)
So the problem is most likely in your ODBC DSN
- If you press test connection in the odbc administrator does the connection
work?
- if it doesn't then getting that working should solve your problem
- if it does then I would turn on odbc tracing to see the exact connect
string the application is generating. The application can override vales in
the DSN. I'd use these values in a test ODBC DSN to get them working
--
/steve
Stephen Rice
Technical Services Manager
iAnywhere (a Sybase Company)
email: sr...@ianywhere.com
"Chet Boggs" <eqv...@verizon.net> wrote in message
news:459439ac$1@forums-1-dub...
<snip>