The connection is dead

  • Thread starter Thread starter cj
  • Start date Start date
Configuring OLEDB access to the Informix Server would require additional
setup on the Informix Server. Corporate politics, is the short answer
as to why that will not happen.

If I can read 10 records, I should be able to read 3 million. I tried
last night reading 1000 at a time. The connection closed between each
fill. at 17000 records I got "Connection Dead".
 
I've added my own looping around the try catch structure. I give it 50
trys with a 4 second break between trys. To keep speed high I batch
50,000 records at a time. I am hopefull by tomorrow at this time the
entire 3 million will have been moved.
 
Hi

If you just want to migrate the data from informix to SQL server, you can
use SQL server's DTS feature. The DTS package is running at SQL server side.
DTS Import/Export Wizard
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_
tools_wiz_8vsj.asp

For detailed information about SQL DTS, you can post in the newsgroup below.
microsoft.public.sqlserver.dts

Thanks for your understanding!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
I'm sorry I think your getting confused. THIS PROGRAM IS BEING USED TO
MIGRATE THE DATA from Informix to SQL Server. And before you suggest it,
I can NOT use any informix db tools or any other tool that would require
loading something or running something on the informix server, and I don't
have time to explain why.
Click to expand...

Dump Informix data to an ASCII text file. Use QBasic to rewrite that file to
one that is compatible with SQL Server. Import.

I've made money many times doing just that. You'll save more time by using
QBasic than by trying to get a working program running using VB.
 
Configuring OLEDB access to the Informix Server would require additional
setup on the Informix Server. Corporate politics, is the short answer as
to why that will not happen.

If I can read 10 records, I should be able to read 3 million. I tried
last night reading 1000 at a time. The connection closed between each
fill. at 17000 records I got "Connection Dead".
Click to expand...

Dump 15000 at a time. Repeat.
 
I do not have access to the informix db software to do anything like that.
Click to expand...

You only need access to the data, not the code. If you have no access to the
data, how can you migrate it?
 
Hi ,

I appreciate your prompt response. : )

I understand your situation and please take your time to perform the steps
that I have provided you. If there is anything unclear, please feel free to
post back. I am always very happy to be of assistance.

Happy New Year!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Perhaps I'm missing something, how do I dump the tables into an ascii file?
 
I didn't get your message till now. I left it Friday requesting 10,000
records at a time. Given my loop code if any .fill failed the program
pauses for 10 seconds and then requests runs .fill again. If it tries
more than 500 times with out success the program aborts. I keep a
cumulative counter of times the program had to retry a fill. This AM I
had only gotten 320,000 records and the looping had to execute 20 times.
This is ultra slow retrieval and has lead me to wonder about something
I'd seen in a test Friday. Take right now for instance. The program is
requesting .Fill(MyDs, 320000, 10000, currentTable). It seems to take
it much, much longer to get this than if it requested .Fill(MyDs, 0,
10000, currentTable). Do you suppose it is reading through the database
sequentially up to 320000 in order to start? Is the fill getting
incrementally slower each time? I'm at a loss to explain how I can get
the first 60,000 records in one fill statement in 20 minutes but it's
taken almost 4 days to retrieve 320,000 records with my 10,000 at a time
filling (even given it had to retry blocks of 10,000 some 20 times over
that time.)
 
Hi

Yes, it is shipped with SQL Server 2000 but not with the MSDE version.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Peter,

I have the msdn cd that says it has: SQL Server 2000 Developer Edition
and SQL Server 2000 SP4 on it. MSDE = the Developer Edition, Correct?
Do you think the SQL Server 2000 SP4 is just a patched Developer Edition
or is it the full SQL Server?

I currently have SQL Express installed on my PC but I am sending this
data to a SQL Server machine that someone else here administers.
 
Hi

Based on my knowledge, SQL Server 2000 Developer Edition is not equal to
MSDE, it should have a dts inside.
And the SQL Server sp4 is just a patch.

Because I am not expert on SQL server, so I suggest post in the SQL server
newsgroup. So that many SQL expert will help you/
e.g.
microsoft.public.sqlserver.dts

Thanks for your understanding!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The PC is dead? 9
large values from database 1
Overriding dataset connection 3
internal connection error 1
connection close problem 1
Games you've not finished? 8
What is a Byte? 4
My Xbox 1 catalogue 5

Back
Top