I know how to use the output feature of interactive SQL to export the results of a query to an excel formated file - how could I do the same thing within a stored procedure?
We have a Windows Server envirnoment with one Server VM running the Database and another Server VM In the network as the Client App machine.
We have no problem accessing a single Database Service from the Client to the first Databse Service. This us...
We have a large application written primarily in PowerBuilder which we want to move from SQL Anywhere 16 to SQL ANywhere 17. we are using the ODBC interface.
What problems or issues might we run into?
Are there any helpful sources about migration?
We have an app that's been around since the very early days of SQL Anywhere. It is currently under the default collation 1252Latin1. Although the primary language for users is English - there are some cases where they need to store names and descript...
We have an app that's been around since the very early days of SQL Anywhere. It is currently under the default collation 1282Latin1. Although the primary language for users is English - there are some cases where they need to store names and descript...
One of the issues we have with our OEM agreement 0 is although we pay for the OEM rights and separately for support for our in-house installation - we are told that our support will end when the OEM agreement ends. Patently unfair business practice.....
Thanks Volker - while csv's are great for us developers, they create difficulties for users - and probably the most valuable utility would be a way to to the excel export similarly to how it could be done in interactive SQL.
Apparently such a utility...
Thanks - we were curious if SQLAnywhare could share ports - I guess not
is the -x tcpip (ServerPost=xxxx) the correct parameter to add to the Configuration Service properties?
Yes - when we turned off the firewall - we could connect to the second database.
So it appears that when the service starts up it sees the default port being used and switches to another.
So we need to designate the port for each server to avoid the ...