Click here to Skip to main content
16,008,010 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: error while trying to create an object for excel sheet Pin
Tom Deketelaere21-Oct-08 2:05
professionalTom Deketelaere21-Oct-08 2:05 
AnswerRe: error while trying to create an object for excel sheet Pin
Paddy Boyd21-Oct-08 3:25
Paddy Boyd21-Oct-08 3:25 
AnswerRe: error while trying to create an object for excel sheet Pin
Dave Kreskowiak21-Oct-08 4:00
mveDave Kreskowiak21-Oct-08 4:00 
Questionplz help.i want export datagridview data in excel sheet in vb.net winforms Pin
dilipmca0421-Oct-08 1:26
dilipmca0421-Oct-08 1:26 
AnswerRe: plz help.i want export datagridview data in excel sheet in vb.net winforms Pin
Dave Kreskowiak21-Oct-08 3:58
mveDave Kreskowiak21-Oct-08 3:58 
Questioncv or resume loader Pin
jhyn21-Oct-08 1:02
jhyn21-Oct-08 1:02 
GeneralRe: cv or resume loader Pin
Guffa21-Oct-08 1:28
Guffa21-Oct-08 1:28 
QuestionError occurs when using OdbcDataAdapter FILL command Pin
John Wadleigh20-Oct-08 22:58
John Wadleigh20-Oct-08 22:58 
Below is the custom function I call to get data and fill it into a
DataTable. It seems to fail when the FILL command is called, but it
does not fail all the time. It appears to possibly be a length issue
but I am not sure and not sure how to resolve this... your help is
appreciated! Included is the stack trace information below the
function...thank you.

Public Function ExecuteQuery(ByVal strSQL As String, ByVal
myDataTable As DataTable) As Integer
Try
Timing_Start()
Dim myAdaptor As New OdbcDataAdapter(strSQL,
m_objConnection)
myDataTable.Rows.Clear()
'TODO: RUNTIME ERROR: when the SCRIPT column has the
umlaut character
myAdaptor.Fill(myDataTable)
Timing_Stop()
m_iFieldCount = myDataTable.Columns.Count
m_iRecordCount = myDataTable.Rows.Count
'Return (m_iRecordCount)
Return 0
Catch ex As Exception
Error_Show(ex, MsgBoxStyle.Exclamation)
Return (-1)
End Try
End Function


DESCRIPTION:


len


STACK TRACE:


at System.Runtime.InteropServices.Marshal.PtrToStringUni(IntPtr
ptr, Int32 len)
at System.Data.Odbc.OdbcDataReader.internalGetString(Int32 i)
at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap
typemap)
at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
at System.Data.Odbc.OdbcDataReader.GetValues(Object[] values)
at System.Data.Common.SchemaMapping.LoadDataRow(Boolean
clearDataValues, Boolean acceptChanges)
at System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping
mapping)
at System.Data.Common.DbDataAdapter.FillFromReader(Object data,
String srcTable, IDataReader dataReader, Int32 startRecord, Int32
maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable,
IDataReader dataReader)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Expert_Services_Tools.clsConnection.ExecuteQuery(String strSQL,
DataTable myDataTable) in D:\My Documents\Visual Studio Projects
\Siebel Watcher\clsConnection.vb:line 324


SOURCE: PtrToStringUni

John Wadleigh
Siebel Expert

AnswerRe: Error occurs when using OdbcDataAdapter FILL command Pin
Mycroft Holmes20-Oct-08 23:05
professionalMycroft Holmes20-Oct-08 23:05 
GeneralRe: Error occurs when using OdbcDataAdapter FILL command Pin
John Wadleigh20-Oct-08 23:31
John Wadleigh20-Oct-08 23:31 
GeneralRe: Error occurs when using OdbcDataAdapter FILL command Pin
Dave Kreskowiak21-Oct-08 3:56
mveDave Kreskowiak21-Oct-08 3:56 
GeneralRe: Error occurs when using OdbcDataAdapter FILL command Pin
John Wadleigh21-Oct-08 4:31
John Wadleigh21-Oct-08 4:31 
GeneralRe: Error occurs when using OdbcDataAdapter FILL command Pin
Dave Kreskowiak21-Oct-08 5:39
mveDave Kreskowiak21-Oct-08 5:39 
GeneralRe: Error occurs when using OdbcDataAdapter FILL command Pin
John Wadleigh21-Oct-08 6:29
John Wadleigh21-Oct-08 6:29 
Questionhow to use cache memory in vb.net Pin
Vineet Swami20-Oct-08 20:52
Vineet Swami20-Oct-08 20:52 
AnswerRe: how to use cache memory in vb.net Pin
Sathesh Sakthivel20-Oct-08 22:03
Sathesh Sakthivel20-Oct-08 22:03 
AnswerRe: how to use cache memory in vb.net Pin
Dave Kreskowiak21-Oct-08 3:47
mveDave Kreskowiak21-Oct-08 3:47 
Questionweb services with no ASMX or WSDL Pin
tryingtofindanamethatsnotused20-Oct-08 15:40
tryingtofindanamethatsnotused20-Oct-08 15:40 
QuestionTCPListener Pin
Subjugate20-Oct-08 14:31
Subjugate20-Oct-08 14:31 
AnswerRe: TCPListener Pin
Scott Barbour21-Oct-08 8:18
Scott Barbour21-Oct-08 8:18 
QuestionMaxLength for text field in propertygrid Pin
nickbartels20-Oct-08 7:44
nickbartels20-Oct-08 7:44 
AnswerRe: MaxLength for text field in propertygrid Pin
Jon_Boy20-Oct-08 8:40
Jon_Boy20-Oct-08 8:40 
Questionspecifying path to a file on another computer on the network Pin
Dbase20-Oct-08 7:00
Dbase20-Oct-08 7:00 
AnswerRe: specifying path to a file on another computer on the network Pin
nlarson1120-Oct-08 7:13
nlarson1120-Oct-08 7:13 
Question[Message Deleted] Pin
Vineet Swami20-Oct-08 1:29
Vineet Swami20-Oct-08 1:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.