Toad World® Forums

Connecting to local SQL Anyware Version 12

I can connect to the server SQL Anywhere but on my local pc - C drive CAN NOT. Try many many option unsuccessful. It is always the server name error. I believe TOAD can not connect directly without ODBC.

Hello luiso_26879,

Could you please provide us more info how you try to connect to the local database? Do you use TCP port on localhost? The images in your post are unfortunately not visible.

Regards,

Libor

Hi luiso_26879,

Best is to connect direct. it’s the fastest way.

make sure you have access to the database from your laptop, by pinging or telnet then make sure you’re entering correct data in the correct fields.

Libor,

I work with Luis and would like to give some additional details on the issue.

We have a production SQL Anywhere database which we are able to connect to using Toad for SAP 3.0. Each developer also has a “local” copy of the database for development purposes. We are NOT able to connect Toad for SAP to our local SQL Anywhere databases. We just get the error “Database server not found”.

Our local databases are on the C drive (ex. C:\DB\dev\DevDB.db). We are able to connect to and use our local database using other applications, so we know it works, we just don’t know how to configure the connection from within Toad for SAP.

We are using the following connection settings:

  • Broadcast: Direct (but have also tried ‘None’)
  • Host: localhost
  • Port: 2638
  • Server: C:\DB\dev\DevDB.db
  • Database:
  • Kerberos: No

Any suggestions?

Thanks for your time,

WTBryant

Hello,

I guess you start the database as a personal database server and unfortunately this is not currently supported in Toad. The personal database server communicates via shared memory, but we support only TCP/IP.

If you want to be able to connect from Toad you should start the database as a network database server, i.e. to use dbsrv12 instead of dbeng12:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-dbserver.html

https://www.youtube.com/watch?v=8hm0JfEtV9o

Libor

Hello,

Thanks very much for the information. Sometimes is better to ask than trying to find out for your self.

Regards,

Luis

From: Libor.Witasek [mailto:bounce-LiborWitasek@toadworld.com]

Sent: Wednesday, July 27, 2016 6:31 AM

To: toadsybase@toadworld.com

Subject: RE: [Toad for SAP Solutions - Discussion Forum] Connecting to local SQL Anyware Version 12

RE: Connecting to local SQL Anyware Version 12

Reply by Libor.Witasek

Hello,

I guess you start the database as a personal database server and unfortunately this is not currently supported in Toad. The personal database server communicates via shared memory, but we support only TCP/IP.

If you want to be able to connect from Toad you should start the database as a network database server, i.e. to use dbsrv12 instead of dbeng12:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-dbserver.html

https://www.youtube.com/watch?v=8hm0JfEtV9o

Libor

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for SAP Solutions - General Forum
notifications altogether.

Toad for SAP Solutions - Discussion Forum

Flag
this post as spam/abuse.