Прошу помощи, т.к. 3 неделю никак не могу соединиться с SA11 хотя:
- БД полностью пересоздана скриптами под сервером SA11;
- создан источник ODBC;
- Central соединяется, но валиться при попытке открыть события (события изьяты из БД);
- оболочка PB 10.5 соединяется нормально с этим источником со следующим протоколом ODBC
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
Fri Apr 03 2009 19 : 49 : 50
19 : 49 : 50 Attempting to connect using:
UID=tnd;PWD=********;DBF=D:\Database\elix\elixir.db;CON=SQL_DBC_19f5040;ASTOP=YES;INT=NO;DBG=YES;LOG=d:\log11;DMRF=NO;COMP=NO;NEWPWD=********
19 : 49 : 50 Attempting to connect to a running server...
19 : 49 : 50 Attempting SharedMemory connection (no sasrv.ini cached address)
19 : 49 : 50 Failed to connect over SharedMemory
19 : 49 : 50 No server found, attempting to start a personal server...
19 : 49 : 50 Autostarted server, attempting to connect using:
UID=tnd;PWD=********;DBF=D:\Database\elix\elixir.db;CON=SQL_DBC_19f5040;ASTOP=YES;INT=NO;DBG=YES;LOG=d:\log11;DMRF=NO;COMP=NO;NEWPWD=********
19 : 49 : 50 Attempting SharedMemory connection (no sasrv.ini cached address)
19 : 49 : 50 Connected to server over SharedMemory
19 : 49 : 50 Connected to SQL Anywhere Server version 11 . 0 . 0 . 1526
19 : 49 : 50 Application information:
19 : 49 : 50 IP= 192 . 168 . 1 . 8 ;HOST=SERGE;OSUSER=Serg;OS='Windows XP Build 2600 Service Pack 2';EXE='C:\Program Files\Sybase\PowerBuilder 10.5\PB105.EXE';PID=0xa18;THREAD=0x98c;VERSION= 11 . 0 . 0 . 1526 ;API=ODBC;TIMEZONEADJUSTMENT= 180
19 : 49 : 50 Connected to the server, attempting to connect to a running database...
19 : 49 : 51 [ 1 ] Connected to database successfully
- моё приложение по прежнему при соединении вызывает "dbeng11 has encountered a serious error" (crash файлы я уже отсылал в Sybase), при этом в окне сервера имеем:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
SQL Anywhere Personal Server Version 11 . 0 . 0 . 1526
Copyright © 2001 - 2008 , iAnywhere Solutions, Inc.
Portions copyright © 1988 - 2008 , Sybase, Inc. All rights reserved.
Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses
SQL Anywhere Developer Edition
2 logical processor(s) on 1 physical processor(s) detected.
This server is licensed to:
Developer Edition
Restricted Use
Running Windows XP Build 2600 Service Pack 2 on X86
Server built for X86 processor architecture
4776K of memory used for caching
Minimum cache size: 2048K, maximum cache size: 939324K
Using a maximum page size of 2048 bytes
Database server started at Mon Apr 06 2009 10 : 07
Trying to start SharedMemory link ...
SharedMemory link started successfully
Trying to start TDS (TCPIP) link ...
Starting on port 2638
TDS (TCPIP) link started successfully
Now accepting requests
Starting database "elixir" (D:\Database\elix\elixir.db) at Mon Apr 06 2009 10 : 07
Database recovery in progress
Last checkpoint at Fri Apr 03 2009 19 : 52
Transaction log: elixir.log...
Rollback log...
Checkpointing...
Starting checkpoint of "elixir" (elixir.db) at Mon Apr 06 2009 10 : 07
Finished checkpoint of "elixir" (elixir.db) at Mon Apr 06 2009 10 : 07
Recovery complete
Database "elixir" (elixir.db) started at Mon Apr 06 2009 10 : 07
а протокол ODBC содержит два вариата сообщений :
Вариатн 1 (запуск приложения автономно)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
Mon Apr 06 2009 10 : 07 : 06
10 : 07 : 06 Attempting to connect using:
UID=бухгалтер;PWD=********;DBF=D:\Database\elix\elixir.db;CON=SQL_DBC_15d5008;ASTOP=YES;INT=NO;DBG=YES;LOG=d:\log11;DMRF=NO;COMP=NO;NEWPWD=********
10 : 07 : 06 Attempting to connect to a running server...
10 : 07 : 06 Trying to start SharedMemory link ...
10 : 07 : 06 SharedMemory link started successfully
10 : 07 : 06 Attempting SharedMemory connection (no sasrv.ini cached address)
10 : 07 : 06 Failed to connect over SharedMemory
10 : 07 : 06 No server found, attempting to start a personal server...
10 : 07 : 08 Autostarted server, attempting to connect using:
UID=бухгалтер;PWD=********;DBF=D:\Database\elix\elixir.db;CON=SQL_DBC_15d5008;ASTOP=YES;INT=NO;DBG=YES;LOG=d:\log11;DMRF=NO;COMP=NO;NEWPWD=********
10 : 07 : 08 Attempting SharedMemory connection (no sasrv.ini cached address)
10 : 07 : 08 Connected to server over SharedMemory
10 : 07 : 08 Connected to SQL Anywhere Server version 11 . 0 . 0 . 1526
10 : 07 : 08 Application information:
10 : 07 : 08 IP= 192 . 168 . 1 . 8 ;HOST=SERGE;OSUSER=Serg;OS='Windows XP Build 2600 Service Pack 2';EXE=d:\2C\BAKS.exe;PID=0xff4;THREAD=0xddc;VERSION= 11 . 0 . 0 . 1526 ;API=ODBC;TIMEZONEADJUSTMENT= 180
10 : 07 : 08 Connected to the server, attempting to connect to a running database...
Вариатн 2 (запуск из оболочки PB)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
Fri Apr 03 2009 19 : 52 : 29
19 : 52 : 29 Attempting to connect using:
UID=бухгалтер;PWD=********;DBF=D:\Database\elix\elixir.db;CON=SQL_DBC_15c5008;ASTOP=YES;INT=NO;DBG=YES;LOG=d:\log11;DMRF=NO;COMP=NO;NEWPWD=********
19 : 52 : 29 Attempting to connect to a running server...
19 : 52 : 29 Trying to start SharedMemory link ...
19 : 52 : 29 SharedMemory link started successfully
19 : 52 : 29 Attempting SharedMemory connection (no sasrv.ini cached address)
19 : 52 : 29 Failed to connect over SharedMemory
19 : 52 : 29 No server found, attempting to start a personal server...
19 : 52 : 29 Autostarted server, attempting to connect using:
UID=бухгалтер;PWD=********;DBF=D:\Database\elix\elixir.db;CON=SQL_DBC_15c5008;ASTOP=YES;INT=NO;DBG=YES;LOG=d:\log11;DMRF=NO;COMP=NO;NEWPWD=********
19 : 52 : 29 Attempting SharedMemory connection (no sasrv.ini cached address)
19 : 52 : 29 Connected to server over SharedMemory
19 : 52 : 29 Connected to SQL Anywhere Server version 11 . 0 . 0 . 1526
19 : 52 : 29 Application information:
19 : 52 : 29 IP= 192 . 168 . 1 . 8 ;HOST=SERGE;OSUSER=Serg;OS='Windows XP Build 2600 Service Pack 2';EXE=d:\2C\BAKS.exe;PID=0x8f0;THREAD=0x8e0;VERSION= 11 . 0 . 0 . 1526 ;API=ODBC;TIMEZONEADJUSTMENT= 180
19 : 52 : 29 Connected to the server, attempting to connect to a running database...
19 : 52 : 40 Disconnecting shared memory client, process id not found
19 : 52 : 40 Communication function i_cs_HandleSQLPresError code 5
19 : 52 : 40 Communication function StrmGetInd code 6
19 : 52 : 40 Database is running, but could not connect to it
