S
Seisbye
Guest
I have an ODBC source. And if i do a simple query from Excel. Get data - other sources - from ODBC. Advanced editor and use the script select * from Filemaker_Fields I get all 111.000 rows, without anyproblems at all.
If I on the other hand tries to do the same in Visual studio. i'm not as succesfull. I have tried both Ado .NET & Ole DB. I can see excel uses OleDB, so I reverted back to that, since i can see it can work.
I have created a table in SSMS based on all tables from the ODBC source(i used the visual function new table to create it). I use the same SQL command in the ODBC source. Im mapping all columns, not removing anything at all. Basicly the "same" as in excel.
I tells me there are LOB columns(but there aren't in the one table, there are in some of the others.) So it will force Row by Row. I can then just change the fetchmetode to 0, this removes the warning. I then come to the 2nd issue, if i run it. It will cause an error about not being able to validate metadata. So i have set that option to false. Then come the last problem
I will now run until is has loaded 29.748 rows. I looked through the output in excel. There are no special caracters or anyhing which should affect it. All rows contain same type of info. But since it's failing 1/3 unto the load, it has to be some kind og data validation right`?
I create an on Error redirect. It will load all 111.000 lines, but 40k. will be pushed over to the error list.
Which options should i look at? I'm assuming there are some defualt setting which aren't the same as in Excel? I really don't understand how it will just fly with no problems at all. But not in VS. I'm assuming it's the advanced settings options, which then has an default setting not set in excel?
Continue reading...
If I on the other hand tries to do the same in Visual studio. i'm not as succesfull. I have tried both Ado .NET & Ole DB. I can see excel uses OleDB, so I reverted back to that, since i can see it can work.
I have created a table in SSMS based on all tables from the ODBC source(i used the visual function new table to create it). I use the same SQL command in the ODBC source. Im mapping all columns, not removing anything at all. Basicly the "same" as in excel.
I tells me there are LOB columns(but there aren't in the one table, there are in some of the others.) So it will force Row by Row. I can then just change the fetchmetode to 0, this removes the warning. I then come to the 2nd issue, if i run it. It will cause an error about not being able to validate metadata. So i have set that option to false. Then come the last problem
I will now run until is has loaded 29.748 rows. I looked through the output in excel. There are no special caracters or anyhing which should affect it. All rows contain same type of info. But since it's failing 1/3 unto the load, it has to be some kind og data validation right`?
I create an on Error redirect. It will load all 111.000 lines, but 40k. will be pushed over to the error list.
Which options should i look at? I'm assuming there are some defualt setting which aren't the same as in Excel? I really don't understand how it will just fly with no problems at all. But not in VS. I'm assuming it's the advanced settings options, which then has an default setting not set in excel?
Continue reading...