Hi Guys, I am having SQL Anywhere 12 installed on one computer, and I need to make an ODBC connection with another. Do I need to install SQLAnywhere 12 on the second computer or do I just need to have SQL Anywhere 12 ODBC driver in that. I want to transfer data from a SQL Anywhere database to a Microsoft SQL Server database on a second computer. The second computer is running Windows Server 2008R2 and the only application installed on it is Microsoft SQL Server 2008. I believe I could do this if I had on ODBC driver for SQL Anywhere installed on the second computer. Hi @all I've a Sybase SQL Anywhere 9 Server on a Windows server. I've a client with Windows 7. I want install only the ODBC driver for access to the server. But, how find I the ODBC driver? Previously, I have managed to get open the remember.db database file via either an SQL Anywhere 10 or 11 ODBC driver I managed to get by downloading trial version sof SQL Anywhere 10 and 11. Installing those gave me the needed ODBC drivers, and I was able to access the database and extract the raw tables for use in migrating to our database schema.
SAP can call you to discuss any questions you have.
Chat NowChat Offline
Get live help and chat with an SAP representative.
<>
Enable secure, reliable data management for servers where no DBA is available and synchronization for tens of thousands of mobile devices, Internet of Things (IoT) systems, and remote environments.
SAP SQL Anywhere
Run your business from anywhere with relational database management system (RDBMS) solutions from SAP SQL Anywhere. Capture, manage, and synchronize data in real-world conditions – even without connectivity or IT support.
On-premise and cloud deployment
Secure synchronization with improved encryption
Embedded data management in critical applications
Streamlined collection and analysis of IoT data
PreviousNext
Optimize data management
Deliver critical business data to remote offices and mobile devices for more accurate, real-time decision-making at the front lines of your business.
Empower greater mobility
Run mobile applications reliably and efficiently without on-site technical staff, giving mobile and remote workers an always on experience, even when they are offline.
Simplify service
Streamline data maintenance tasks with built-in self-managing features that help users resolve issues quickly and efficiently.
PreviousNext
Strong encryption
Protect and secure your data, even during data transmission and exchange, with powerful encryption features.
Data synchronization
Replicate transactions between the enterprise and tens of thousands of remote devices, executing complex, scalable operations consistently with no data loss.
Instant insight
Transport insights anytime, anywhere from SAP HANA to satellite locations, giving mobile and remote users access to deep intelligence.
PreviousNext
SAP SQL Anywhere Cockpit
Gain a current view of the availability, capacity, and performance of your database server.
Profiler tool
Tune and troubleshoot your database applications with this development tool.
OData support
Configure SAP SQL Anywhere to act as an OData server.
PreviousNext
Data Security
Focus on your business and customer relationships, while knowing that your data is safe and reliable. With a proactive, predictive approach, SAP helps ensure compliance and data security in the cloud and within an on-premise data center.
Data Privacy and Protection
SAP protects the rights of employees, applicants, customers, suppliers, partners, and all other persons by preserving data ownership, protection, and privacy throughout the processing and use of information.
Compliance
Get the assurance you need to know that our cloud offerings meet the latest compliance and security standards. We regularly check compliance through external reviews and audits and follow one common framework, including data security and privacy regulations, worldwide.
Evolve your business with SAP Digital Business Services – your trusted adviser for digital transformation strategy and execution.
PreviousNext
Simplify and accelerate your digital transformation
Secure critical business processes on your path to innovation and digital transformation with holistic, end-to-end service support that reflects over 40 years of unparalleled knowledge, experience, and innovation.
Transform your business with unparalleled service support
Close the gap between your digital transformation strategy and execution with innovation discovery, digital strategy, and business transformation services from a trusted adviser that knows SAP software best.
PreviousNext
Affordable relational database management system
Learn how ND Software provides ERP applications that meet the special needs of eldercare facilities simply and cost-effectively.
Looking for more data management products to meet your business needs?
Hi, I work for a software company that provides membership and member data management software. When we get new clients, I take what ever data sources they have, be they simple excel documents or CSV files or a completely unheard of yet comprehensive database solution, and then convert/migrate the data into our web based database. One database solution that rarely comes up, ReMEMBER, uses a Sybase database for the data backend. Previously, I have managed to get open the remember.db database file via either an SQL Anywhere 10 or 11 ODBC driver I managed to get by downloading trial version sof SQL Anywhere 10 and 11. Installing those gave me the needed ODBC drivers, and I was able to access the database and extract the raw tables for use in migrating to our database schema. The problem now, is that neither the SQL Anywhere 10 or 11 ODBC drivers work for this current remember.db database file; both ODBC drivers fail on the Test Connection while setting up the new User Data Source in the Data Sources (ODBC) tool. (I am using XP Pro) The only error message I have to go off of simply tells me it can't access the data source because it was made with another version of the software. On the few other times I have had to rip raw data from ReMEMBER datafiles, sometimes SQL Anywhere 10 would work, sometimes SQL Anywhere 11 would. Now both tell me the database file was made with a different version of the software.
Sql Anywhere 12 Odbc Driver 32 Bit
So I guess my question is, is there any easy way to tell, or any easy tool to tell what version of ODBC driver I would need to use given the remember.db file? Any idea where I might be able to find bundled group of ODBC drivers for the various versions and flavors of Sybase products?