Search results for query: *

Sir You are correct and damn my ignorance. I was so focused on the bloody connection that i couldnt see the woods for the trees Many many thanks for your help withth is it is greatly appreciated and all is working well Steve

Hello jmcilhinney Thank you for taking the time to read and help. I know your pointing me at somthing but i just cant see it. As far as i can see i am closing the connection after finishing reading my main query/loop . My problem relates to reading to much data in one go. If i move where i call...

Hello jmcilhinney Thanks for your reply I would normally close the connection at the end of the read while procedure as shown.(Start line 16, end Line 83) . If i close it elsewhere i get the "cannot read while connection closed" error message on the next iteration. This will read, eventually...

code in a nicer/easier format i hope 'Pecas connection string Public strPECAScon As String = ("DRIVER={Progress OpenEdge 10.2B Driver};HOST=10.0.11.4;PORT=4500;DB=vision;UID=vision;PWD=;DIL=READ UNCOMMITTED;") Public CONcompanyPECAS As New OdbcConnection(strPECAScon) 'SQl connection...

Hello all I am using vb.net 201 2and i need to connect to a progress database via an odbc connection, read data and then save that data to a SQL database. I have suprised myself by being able to do this but i can only read a few records into the app then onto SQL before i get an error message...