Viewing 15 posts - 31 through 45 (of 54 total)
We're still working on this...
We've been back through the basic's. Still no success.
June 16, 2009 at 7:03 pm
Gift Peddie (6/3/2009)
June 3, 2009 at 6:59 pm
Mayank Khatri (6/3/2009)
1)N/W bottleneck: Do you see ASYNC_NETWORK_IO when transfer is between servers when u use sysprocesses.
2)constraints enabled in...
June 3, 2009 at 5:50 pm
Dugi (6/3/2009)
Yea the length func returns the number of chars, but little bit confused how to use it as filter for example give me all records from a table where...
June 3, 2009 at 12:19 am
Oracle length() function will count the number of chaarcters in a field.
select id, name, length(name) from test_table;
ID NAME LENGTH(NAME) Notes.
--- ----------...
June 3, 2009 at 12:06 am
I'm working with SQL Server connecting to Oracle databases also.
Loweell is correct, you need to install an oracle client on your SQL server machine to provide drivers/libraries as well...
May 14, 2009 at 1:25 am
More dramas... :doze:
After much un-installing and re-installing... I had both MSDAORA and OraOLEDB working side by side... and then it broke again... :crying:
Started getting:
Msg 7399, Level 16, State 1,...
October 9, 2008 at 11:24 pm
I spent 12 hours yesterday trygin to install Oracle provider for OLE. I got there in the end. :doze:
(I had lots of complications caused by having both 9i & 10g...
October 8, 2008 at 5:25 pm
Well i've been working on this for several days and learend some interesting things.
We discovered that the delay is definitely related to the transport of the records. Oracle completes...
October 7, 2008 at 6:01 pm
I'm still working on this.
I just tried selecting from a testing environment, and I get three times better throughput from a smaller machine.
I get 475 records per second...
October 2, 2008 at 12:16 am
thepotplants (9/30/2008)
I'm going to start looking into the OLE drivers and see if there are any patches or updates.
damnit.. I have the latest version... MDAC 2.8 SP1.
September 30, 2008 at 7:07 pm
bcronce (9/30/2008)
800MB of data should transfer accross a 100mbit conenction in...
September 30, 2008 at 4:55 pm
gnana krishnan (8/5/2008)
August 7, 2008 at 7:35 pm
Linda Johanning (8/6/2008)
August 7, 2008 at 7:33 pm
Viewing 15 posts - 31 through 45 (of 54 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy