About glenn_barber

glenn_barber

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?

glenn_barber

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...

glenn_barber

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?

glenn_barber

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...

glenn_barber

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...

glenn_barber

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...

glenn_barber

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?

glenn_barber

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 ...

glenn_barber

Productivity differences???

glenn_barber

I had tried to do a similar activity using the Sybase Central to do the unload and using the load script in the new UCA database to do the load - where I ran into problems what the truncation of data which caused many of the tables to fail to load. H...

User Statistics

User Activity

How do I output query results to excel file from stored procedure

Cant Make Second ODBC Connection to Database Server on another Server

Moving from SQL Anywhere 16 to 17

Do we need to Upgrade to UCA Support for International Character Storage?

Do we need to Upgrade to UCA Support for International Character Storage - and How?

Re: How do I output query results to excel file from stored procedure

Re: Cant Make Second ODBC Connection to Database Server on another Server

Re: Cant Make Second ODBC Connection to Database Server on another Server

Re: Moving from SQL Anywhere 16 to 17

Re: Do we need to Upgrade to UCA Support for International Character Storage - and How?