Sybase connection issues
I am trying to retrieve data from Sybase. I am getting this data into an array using GetRow method. Problem is that it is working for 20-30K rows , however if datatable has rows in tunes of 1lakh I am getting an error which says DriverProtocol error. Is it related with driver configuration.
I am using the below mentioned code for this.
Set cn = CreateObject("ADODB.Connection")
Set rsTrade = CreateObject("ADODB.recordset")
Set rsTrade = cn.Execute("Select * from tempdb..testingtemptable") ' Firing the Query to retrieve data from the database
strDatabaseData = rsTrade.GetRows() ' Getting recordset into a 2-D Array
Re: Sybase connection issues
You should not get all 100k rows in a go. Take it few rows at a time.