Recent content by primosteve

  1. P

    Question Reading data from a progress database

    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
  2. P

    Question Reading data from a progress database

    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...
  3. P

    Question Reading data from a progress database

    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...
  4. P

    Question Reading data from a progress database

    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...
  5. P

    Question Reading data from a progress database

    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...
Top Bottom