The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

SQL Anywhere Version 12 Build 3873

I have a database with ASA proxy tables in it. When my app starts up the connection to the remote server does not immediately start up (This is good).. When I execute the 1st query that uses the proxy table the remote server connects(This is good)... The question I have is that after these queries on the proxy table are finished I need to have the connection the remote server closed via a function call in my app.

I am copy data to the remote server database (insert .. select) , once this copy is done my application packages the db file up for delivery. With the connection still active the file is locked down so I can not do the additional processing.

All connections are using ODBC via a C++ application.

Thanks TPS

asked 19 Jul '13, 18:36

TPS's gravatar image

TPS
196131320
accept rate: 0%


I believe the statement that you are looking for is

alter server server_name connection close

Documentation is here.

permanent link

answered 19 Jul '13, 19:23

Mark%20Culp's gravatar image

Mark Culp
23.2k9132273
accept rate: 40%

Yes, I just found the syntax. I was tripped up a little to begin with because when I ran it in ISQL while my app was at a breakpoint it did not indicate that the connection was closed. But placing it in code everything appears to work.

(19 Jul '13, 19:25) TPS
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×63

question asked: 19 Jul '13, 18:36

question was seen: 777 times

last updated: 19 Jul '13, 21:52