Click here to Skip to main content
15,905,028 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: LinkLabels and Data Source Pin
Wendelius22-Oct-08 9:40
mentorWendelius22-Oct-08 9:40 
GeneralRe: LinkLabels and Data Source Pin
KrisnNala23-Oct-08 7:08
KrisnNala23-Oct-08 7:08 
GeneralRe: LinkLabels and Data Source Pin
Wendelius23-Oct-08 7:55
mentorWendelius23-Oct-08 7:55 
GeneralRe: LinkLabels and Data Source Pin
KrisnNala23-Oct-08 8:22
KrisnNala23-Oct-08 8:22 
GeneralRe: LinkLabels and Data Source Pin
Wendelius24-Oct-08 7:49
mentorWendelius24-Oct-08 7:49 
GeneralRe: LinkLabels and Data Source Pin
KrisnNala24-Oct-08 22:13
KrisnNala24-Oct-08 22:13 
GeneralRe: LinkLabels and Data Source Pin
Wendelius25-Oct-08 0:42
mentorWendelius25-Oct-08 0:42 
QuestionUsing ODBC or OLE to handle database with LONG column? Pin
John Wadleigh22-Oct-08 3:00
John Wadleigh22-Oct-08 3:00 
I have hit a wall with my application. I am having problems when dealing with a LONG column in the database. I am getting errors when using the data adapters for either ODBC or OLE (tried both) when the value in one of the LONG columns reaches over a certain threshold length. I try to use the FILL command to get the data from the data provider and into a DataSet or DataTable to then display in a window for the user. However, this causes an error as I mentioned. So I have spent too much time digging and trying to get past this but cannot find a solution.

Do I need to create my own override for the FILL command so it handles LONG columns? I would have expected this to be already handled by MS Framework - perhaps not!?

Anyone have time to help me? I would REALLY appreciate it!

I am trying to access a SQL Anywhere database file (dbf) and provide a fully functional database explorer to the users so we can perform various tasks easier.

Here is my ODBC test code that fails at the FILL line...

Dim conn As New Odbc.OdbcConnection("DSN=" & "client_x" & ";UID=" & "STT" & ";PWD=" & "NEED2CHANGE" & ";")
Dim dr As Odbc.OdbcDataReader
Dim strSQL As String = "select b.name, b.row_id, b.inactive_flg, b.script from SIEBEL.S_APPL_WEBSCRPT b where b.row_id = '1-K3E-1IYQ'"
Dim dt As New DataTable
Dim dg As New DataGrid
Dim cmd As New Odbc.OdbcCommand(strSQL, conn)
Dim vals() As String
Dim myAdaptor As New Odbc.OdbcDataAdapter(strSQL, conn)
myAdaptor.AcceptChangesDuringFill = True
myAdaptor.Fill(dt)


Here is my OLE test code that works when I query only for 1 record, but when multiple records are returned I cannot get the FILL command to work at all!

Dim ConnString As String
Dim Connect As ADODB.Connection
Dim RS As New ADODB.Recordset
Dim DataGrid1 As New DataGridEX
Dim dt As New DataTable
Dim ds As New DataSet
Dim custDA As New OleDb.OleDbDataAdapter

Dim strSQL As String = "select b.name, b.row_id, b.inactive_flg, b.script from SIEBEL.S_APPL_WEBSCRPT b"

ConnString = "DSN=" & "client_x" & ";UID=" & "SST" & ";PWD=" & "NEED2CHANGE" & ";"
Connect = New ADODB.Connection
Connect.CursorLocation = ADODB.CursorLocationEnum.adUseServer
Connect.Open(ConnString)

RS.CacheSize = 10
RS.Open(strSQL, Connect, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly, ADODB.CommandTypeEnum.adCmdText)
custDA.Fill(dt, RS)

Dim f As New Form
Dim t As New TextBox
t.Multiline = True
f.Controls.Add(t)
t.Dock = DockStyle.Fill
t.Text = RS.Fields(3).GetChunk(RS.Fields(3).ActualSize)


Thanks!

John Wadleigh
Siebel Expert

AnswerRe: Using ODBC or OLE to handle database with LONG column? Pin
Dave Kreskowiak22-Oct-08 5:04
mveDave Kreskowiak22-Oct-08 5:04 
Questionhow to edit appconfig in windows application (C#) Pin
Piyush Vardhan Singh22-Oct-08 2:35
Piyush Vardhan Singh22-Oct-08 2:35 
AnswerRe: how to edit appconfig in windows application (C#) - CROSS POST Pin
Ashfield22-Oct-08 3:02
Ashfield22-Oct-08 3:02 
GeneralRe: how to edit appconfig in windows application (C#) - CROSS POST Pin
Piyush Vardhan Singh22-Oct-08 3:08
Piyush Vardhan Singh22-Oct-08 3:08 
GeneralRe: how to edit appconfig in windows application (C#) - CROSS POST Pin
Ashfield22-Oct-08 4:08
Ashfield22-Oct-08 4:08 
GeneralRe: how to edit appconfig in windows application (C#) - CROSS POST Pin
Jon_Boy22-Oct-08 6:30
Jon_Boy22-Oct-08 6:30 
GeneralRe: how to edit appconfig in windows application (C#) - CROSS POST Pin
Paul Conrad22-Oct-08 8:03
professionalPaul Conrad22-Oct-08 8:03 
AnswerCP IGNORE: Cross post and not even in right forum!... Pin
leckey22-Oct-08 14:36
leckey22-Oct-08 14:36 
QuestionServer/Client Application Pin
AngSoft22-Oct-08 2:27
AngSoft22-Oct-08 2:27 
AnswerRe: Server/Client Application Pin
Johan Hakkesteegt22-Oct-08 3:04
Johan Hakkesteegt22-Oct-08 3:04 
AnswerRe: Server/Client Application Pin
Ashfield22-Oct-08 3:05
Ashfield22-Oct-08 3:05 
QuestionThreading Problem Pin
pdnet21-Oct-08 22:07
pdnet21-Oct-08 22:07 
AnswerRe: Threading Problem Pin
Eduard Keilholz22-Oct-08 0:04
Eduard Keilholz22-Oct-08 0:04 
GeneralRe: Threading Problem Pin
pdnet22-Oct-08 1:12
pdnet22-Oct-08 1:12 
AnswerRe: Threading Problem Pin
N a v a n e e t h22-Oct-08 2:26
N a v a n e e t h22-Oct-08 2:26 
GeneralRe: Threading Problem Pin
pdnet22-Oct-08 19:05
pdnet22-Oct-08 19:05 
GeneralRe: Threading Problem Pin
Dave Kreskowiak23-Oct-08 1:57
mveDave Kreskowiak23-Oct-08 1:57 

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.