Advertisement

05.21.2008 at 08:38AM PDT, ID: 23421284
[x]
Attachment Details

Can't transfer big table from Access to SQL 2005

Asked by ErnestForman in Microsoft Access Database, Databases Miscellaneous, SQL Server 2005

Tags: Microsoft, SQL ODBC, 2005, ODBC

Hi guys,

I have a problem. We have application which try to transfer projects from Access to SQL.

Piece of code
SQL = String.Format("SELECT * INTO [ODBC;{0}].{1} FROM {1}", DestConnStringODBC, schemaTable.Rows(i)!TABLE_NAME.ToString)

When I tried to do this with small file - 10Kb it's working fine, when I try to work with "big" file - more then 200Kb. (I'm talking about zip files) - application provided error "ODBC failed". I look to SQL logs, but nothin special (I compare 2 cases - success and no-success). How I can setup ODBC for best perfomance with large files?

Thank you.Start Free Trial
[+][-]05.21.2008 at 08:23PM PDT, ID: 21620663

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, Databases Miscellaneous, SQL Server 2005
Tags: Microsoft, SQL ODBC, 2005, ODBC
Sign Up Now!
Solution Provided By: Dabas
Participating Experts: 1
Solution Grade: A
 
 
[+][-]06.02.2008 at 01:30PM PDT, ID: 21695400

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 07:47PM PDT, ID: 21706397

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.06.2008 at 02:50PM PDT, ID: 21732961

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.07.2008 at 07:03AM PDT, ID: 21735500

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.11.2008 at 05:05AM PDT, ID: 21759053

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628