|
Home > Archive > SQL Anywhere for Linux > June 2005 > DB Connection issue
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DB Connection issue
|
|
|
| I am new to sybase, ianywhere, we are in the process of testing migration
from MySQL...
Well here is what I have done so far...
Migrate my Linux MySQL DB to local Xp machine, then I migrated the DB to asa
locally and then ftp'd the db to the RHEL server, I can successfully start
the server, in ssh, but I cannot remotely connect to the DB, I can remotely
connect to the remote asa server but cannot access the db. what steps should
I do, to try and complete this remote connection? Thanks for any help in
advance.
| |
| Chris Keating \(iAnywhere Solutions\) 2005-06-09, 1:23 pm |
| Can you provide more specifics about how you start the engine and your
connection parameters?
Thanks
"Aaron" < aaron@idealernetwork
.com> wrote in message
news:42a885bc$1@foru
ms-2-dub...
>I am new to sybase, ianywhere, we are in the process of testing migration
>from MySQL...
>
> Well here is what I have done so far...
>
> Migrate my Linux MySQL DB to local Xp machine, then I migrated the DB to
> asa locally and then ftp'd the db to the RHEL server, I can successfully
> start the server, in ssh, but I cannot remotely connect to the DB, I can
> remotely connect to the remote asa server but cannot access the db. what
> steps should I do, to try and complete this remote connection? Thanks for
> any help in advance.
>
| |
|
| Thanks in advance for your help.
[root@idealer1 bin]# . asa_config.sh
iAnywhere Solutions, Inc. One Sybase Drive, Dublin, CA 94568, USA
Copyright 1988-2003 Sybase Inc. Portions Copyrighted 2003, iAnywhere
Solutions,
Inc. All rights preserved. All unpublished rights reserved.
[root@idealer1 bin]# dbsrv9 -n asademo9 ../vehicle_data.db
Adaptive Server Anywhere Network Server Version 9.0.2.2452
Copyright (c) 1988-2004 Sybase, Inc. Portions Copyright (c) 2002-2004,
iAnywhere Solutions, Inc.
All rights reserved. All unpublished rights reserved.
Developer edition, not licensed for deployment.
Please confirm your acceptance of these license terms:
I accept and agree to abide by the terms and conditions of the
"IANYWHERE NO-CHARGE DEVELOPER EDITION LICENSE AGREEMENT".
Enter 'Y' for Yes and 'N' for No:
Adaptive Server Anywhere Network Server Version 9.0.2.2452
Copyright (c) 1989-2004 Sybase, Inc.
Portions Copyright (c) 2002-2004, iAnywhere Solutions, 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
Adaptive Server Anywhere Developer Edition
Networked Seat (per-seat) model. Access to the server is limited to 3
seat(s).
This server is licensed to:
Developer Edition
Restricted Use
Running on Linux 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT 2003
199588K of memory used for caching
Minimum cache size: 8192K, maximum cache size: 262016K
Using a maximum page size of 2048 bytes
Starting database "vehicle_data" (/opt/sybase/SYBSsa9/vehicle_data.db) at
Fri Jun 10 2005 13:58
Transaction log: vehicle_data.log
Starting checkpoint of "vehicle_data" (vehicle_data.db) at Fri Jun 10 2005
13:58
Finished checkpoint of "vehicle_data" (vehicle_data.db) at Fri Jun 10 2005
13:58
Database "vehicle_data" (vehicle_data.db) started at Fri Jun 10 2005 13:58
Performance warning: Page size too small for database "vehicle_data"
Database server started at Fri Jun 10 2005 13:58
Trying to start SharedMemory link ...
SharedMemory link started successfully
Trying to start TCPIP link ...
Starting on port 2638
TCPIP link started successfully
Now accepting requests
"Aaron" < aaron@idealernetwork
.com> wrote in message
news:42a885bc$1@foru
ms-2-dub...
>I am new to sybase, ianywhere, we are in the process of testing migration
>from MySQL...
>
> Well here is what I have done so far...
>
> Migrate my Linux MySQL DB to local Xp machine, then I migrated the DB to
> asa locally and then ftp'd the db to the RHEL server, I can successfully
> start the server, in ssh, but I cannot remotely connect to the DB, I can
> remotely connect to the remote asa server but cannot access the db. what
> steps should I do, to try and complete this remote connection? Thanks for
> any help in advance.
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-06-10, 1:23 pm |
| You did not provide any of your connection parameters?
Anyways, your connection should use
1) ServerName is "asademo9"
2) DatabaseName is "vehicle_data.db"
3) Ensure that you set links=tcpip (how to do this will depend somewhat on
the tool/driver that you are using to attempt the connection).
You may need to add additional settings to the TCPIP option. For example,
links=TCPIP(Host=< ip_of_machine_runnin
g_the_database_serve
r_engine> )
"Aaron" < aaron@idealernetwork
.com> wrote in message
news:42a9d972$1@foru
ms-1-dub...
> Thanks in advance for your help.
>
> [root@idealer1 bin]# . asa_config.sh
> iAnywhere Solutions, Inc. One Sybase Drive, Dublin, CA 94568, USA
> Copyright 1988-2003 Sybase Inc. Portions Copyrighted 2003, iAnywhere
> Solutions,
> Inc. All rights preserved. All unpublished rights reserved.
>
> [root@idealer1 bin]# dbsrv9 -n asademo9 ../vehicle_data.db
> Adaptive Server Anywhere Network Server Version 9.0.2.2452
>
> Copyright (c) 1988-2004 Sybase, Inc. Portions Copyright (c) 2002-2004,
> iAnywhere Solutions, Inc.
> All rights reserved. All unpublished rights reserved.
>
> Developer edition, not licensed for deployment.
> Please confirm your acceptance of these license terms:
> I accept and agree to abide by the terms and conditions of the
> "IANYWHERE NO-CHARGE DEVELOPER EDITION LICENSE AGREEMENT".
> Enter 'Y' for Yes and 'N' for No:
> Adaptive Server Anywhere Network Server Version 9.0.2.2452
>
> Copyright (c) 1989-2004 Sybase, Inc.
> Portions Copyright (c) 2002-2004, iAnywhere Solutions, 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
> Adaptive Server Anywhere Developer Edition
>
> Networked Seat (per-seat) model. Access to the server is limited to 3
> seat(s).
> This server is licensed to:
> Developer Edition
> Restricted Use
> Running on Linux 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT 2003
> 199588K of memory used for caching
> Minimum cache size: 8192K, maximum cache size: 262016K
> Using a maximum page size of 2048 bytes
> Starting database "vehicle_data" (/opt/sybase/SYBSsa9/vehicle_data.db) at
> Fri Jun 10 2005 13:58
> Transaction log: vehicle_data.log
> Starting checkpoint of "vehicle_data" (vehicle_data.db) at Fri Jun 10 2005
> 13:58
> Finished checkpoint of "vehicle_data" (vehicle_data.db) at Fri Jun 10 2005
> 13:58
> Database "vehicle_data" (vehicle_data.db) started at Fri Jun 10 2005 13:58
> Performance warning: Page size too small for database "vehicle_data"
> Database server started at Fri Jun 10 2005 13:58
> Trying to start SharedMemory link ...
> SharedMemory link started successfully
> Trying to start TCPIP link ...
> Starting on port 2638
> TCPIP link started successfully
> Now accepting requests
>
>
> "Aaron" < aaron@idealernetwork
.com> wrote in message
> news:42a885bc$1@foru
ms-2-dub...
>
>
| |
|
| I am trying to connect from Sybase Central on my local machine. Here is the
erro I get.
[Sybase][ODBC Driver][Adaptive Server Anywhere]Request to start/stop
database denied
Error code=-75
SQL state=42000
Connection parameters:
User=***
Password=***
ENG=asademo9
DBN=vehicle_data.db
links=TCPIP(Host=***
.***.***.***)
"Chris Keating (iAnywhere Solutions)" < Spam_NoThanks_keatin
g@iAnywhere.com>
wrote in message news:42a9dabc$1@foru
ms-1-dub...
> You did not provide any of your connection parameters?
>
>
> Anyways, your connection should use
> 1) ServerName is "asademo9"
> 2) DatabaseName is "vehicle_data.db"
> 3) Ensure that you set links=tcpip (how to do this will depend somewhat on
> the tool/driver that you are using to attempt the connection).
>
> You may need to add additional settings to the TCPIP option. For example,
> links=TCPIP(Host=< ip_of_machine_runnin
g_the_database_serve
r_engine> )
>
>
> "Aaron" < aaron@idealernetwork
.com> wrote in message
> news:42a9d972$1@foru
ms-1-dub...
>
>
| |
| Graeme Perrow 2005-06-10, 8:23 pm |
| Aaron wrote:
> I am trying to connect from Sybase Central on my local machine. Here is the
> erro I get.
>
> [Sybase][ODBC Driver][Adaptive Server Anywhere]Request to start/stop
> database denied
>
> Error code=-75
>
> SQL state=42000
>
>
> Connection parameters:
>
> User=***
>
> Password=***
>
> ENG=asademo9
>
> DBN=vehicle_data.db
>
> links=TCPIP(Host=***
.***.***.***)
>
Take the .db off of the DBN. It should be "DBN=vehicle_data".
--
Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
iAnywhere Solutions Inc.
A Sybase company
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/
| |
|
| Thanks that was all it was...
"Graeme Perrow" < gperrowNO@SPAMianywh
ere.PLEASEcom> wrote in message
news:42a9ff43$1@foru
ms-2-dub...
> Aaron wrote:
>
> Take the .db off of the DBN. It should be "DBN=vehicle_data".
>
> --
> Graeme Perrow
> Senior Software Developer
> gperrow _at_ ianywhere _dot_ com
> iAnywhere Solutions Inc.
> A Sybase company
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer/
|
|
|
|
|