MOZ
Reputation: 758
Why am i getting memory allocation error?
I've successfully connected to MySQL database through MySQL Connector/ODBC, please see the image below.
Also I've successfully created SQL Server 2005 "Linked Server to MySQL".
Unfortunately i am getting "Memory Allocation Error", as shown in image below. I am unable to identify the cause of it.
Upvotes: 0
Views: 1021
Answers (1)
OZIE
Reputation: 157
You can use SSIS with MySQL:
- http://dbperf.wordpress.com/2010/07/23/sql-server-integration-services-2008-ssis-and-mysql/
- http://blogs.msdn.com/b/mattm/archive/2008/03/04/connecting-to-mysql-from-ssis.aspx
- http://sqlmag.com/business-intelligence/integrate-mysql-and-sql-server
- http://www.ideaexcursion.com/2009/06/04/howto-connect-to-mysql-in-ssis/
Upvotes: 1
Related Questions
- Fatal error: Allowed memory size exceeded on mysql query
- MySQL - Out of Memory
- Has anyone faced this error -- Out of memory (Needed 48984 bytes)?
- Allowed memory size of 134217728 bytes exhausted (tried to allocate 4294967296 bytes)
- PHP/MySQL Fatal memory allocation error
- MySQL not releasing memory
- Out of memory (allocated 50855936) (tried to allocate 50331646 bytes)
- SQL Server isn't allocating memory
- sql server 2005 sp3 insufficient memory to run query problem
- SQL Server 2005 Error 701 - out of memory