dcsimg

Search:

Type: Posts; User: Metalpalo

Page 1 of 5 1 2 3 4

Search: Search took 0.50 seconds.

  1. Problem with adUseServer for MSDASQL on Windows 7

    Hi all

    I have one VB6 application working with ORACLE database through ADO. The method that reads data looks following:

    Public Sub LoadData()
    Dim rs As ADODB.RecordSet

    Err.Clear
    On Error...
  2. Re: Problem with reading of LONG data through Oracle ODBC driver 10 or 11

    Hi all

    I send a concrete example where I have got a problem. Here is my source code to get data:


    Private Sub test()
    Dim cSQLString As String
    Dim rs As Recordset

    Err.Clear
  3. Problem with reading of LONG data through Oracle ODBC driver 10 or 11

    Hello everybody

    I've got a small VB6 application reading data(DAO) from one Oracle table through Oracle ODBC drivers.
    This table MyTable contains one column "AdditionalInfo" of type LONG.
    When...
  4. How to run VB6 application through DAO on Win 7 64bit?

    I have got one obsolete VB6 that uses DAO to database operations.
    I dispose also with an install package created by VB6 tool.

    After installation of package the users are able to run application...
  5. Re: How to work with MDB via VB6 without MS Access

    Thanks

    But which components have I to install. I think that MS Access driver is neccessary or not? What is neccessary for Jet provider?
  6. How to work with MDB via VB6 without MS Access

    Hello

    I need to use my VB6 application working with mdb file on one PC. Problem is that this PC doesn't dispose with installed MS Access.

    What is neccessary to install? Just MS Access driver?...
  7. Problem with find function on range object

    Hello

    I'm creating Word document via VB6 application and I have got any problem with 'find' function.

    Here is my code:

    With xTable.Range.Find
    .ClearFormatting
    .Text = "$$$CR$$$"...
  8. Replies
    5
    Views
    9,676

    Re: How to adjust word table columns?

    I haven't declared Word objects but it is not important for us.

    My problem is that I don't know how to stretch last column across the page. I want to set last column's width to remaining width on...
  9. Replies
    5
    Views
    9,676

    Re: How to adjust word table columns?

    here is my VB6 code:


    Set xTable = doc.Tables.Add(Range:=sel.Range, NumRows:=RowCount + 2, NumColumns:=4, DefaultTableBehavior:=wdWord8TableBehavior)

    With xTable
    .Columns(1).Width =...
  10. Replies
    5
    Views
    9,676

    How to adjust word table columns?

    Hello

    Can someone please help me with VB6 source code to create four column tables with the properties:

    first three columns will have got a fix column width = 2 cm,
    last (4th) column will...
  11. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    Here is my code:

    Set xResult = New Collection
    Set rs = New ADODB.RecordSet
    rs.Open cSQL, gConnection, adOpenForwardOnly, adLockReadOnly, adCmdText
    With rs
    While Not .EOF
    Set xItem...
  12. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    It's good question.
    I wish that your code is sufficient to gell all characters but I don't know why doesn't work for my provider. I will have to try it for Oracle 10.2.0, now I'm using version 9.
    ...
  13. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    Hello abhijit

    I've tried your code for both cursors(client, server) but with same results. All longer texts(len() > 100) are trucated by my provider. It seems that the GetChunk method works on...
  14. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    Sorry

    but I don't understant

    I found that all texts longer than 100 characters are truncated to this mentioned length.
    I've tried to use something as

    rs.Fields("").GetChunk(500)
    but...
  15. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    Hello

    It seems that I have got problem also with ADO.

    I don't why the field with Long value returns only part of whole string cca(100 characters). That means that following code:...
  16. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    thanks abhijit

    i've remaked it and ado has not any problems with oracle longs. it seems that i will have to use it instead of dao.
  17. Why Oracle Varchar2 is mapped to adVarWChar and not to adVarChar ADO type?

    Hello

    I have got one question regarding the ADO data type mapping.

    After opening recordset I found that the fields containing strings(Oracle VARCHAR2) have set datatype to adVarWChar.
    But...
  18. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    Can you post me example based on ADO technology. I would to try replace it.

    thanks
  19. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    I have one simply table containing column 'additionalinfo' with LONG type and I'm going to load data from this table by following way:



    Private Sub cmdTest_Click()
    Dim cSQL As String
    Dim rs...
  20. Replies
    18
    Views
    3,043

    Re: Problems with Oracle column type LONG

    I mean that rows from number 105 contain other texts assigned to another rows for this column.

    I haven't any problems with characters as you mentioned.
  21. Replies
    18
    Views
    3,043

    Problems with Oracle column type LONG

    Hello

    My VB6 application reads data from one oracle table via DAO objects. This table contains also one column with LONG type.

    When I loaded data into recordset I had got wrong texts for this...
  22. How to change word file name before saving?

    Hello

    My VB6 application creates report into MS Word documents. When I create new blank document the names look like Document1, Document2 ....
    But what I need to achieve is change this name...
  23. Re: Which ancestor use for Form and UserControl?

    sorry for my english but "jcis" is right

    I would like to implement only one public sub working with forms and UCs too. When I used input type Object the parametern MyForm contained correct...
  24. Re: Which ancestor use for Form and UserControl?

    Again

    I don't want to get the labels within a usercontrol from outside the usercontrol!!! In any case I don't want to set UC's labels from outside the usercontrol.

    All I want is using of...
  25. Re: Which ancestor use for Form and UserControl?

    I wanted to use some general method for Form and UserControl something likes:

    Public Sub LoadLabelTexts(MyForm As Object)
    Dim i, j As Integer

    If MyForm.Count Then
    For j = 0 To...
  26. Re: Which ancestor use for Form and UserControl?

    Sorry maybe I don't understand.

    I've create example method which will be set automated caption for all labels on the form:

    Public Sub LoadLabelTexts(MyForm As Form)
    Dim i, j As Integer

    If...
  27. Which ancestor use for Form and UserControl?

    Hello

    I have method (VB6) TextsGetForm(MyForm as Form) which loads texts for controls on formular through the loop on Controls collection(labels, frames ...).

    Now I need to adapt it also for my...
  28. Replies
    4
    Views
    1,617

    Re: Application error after closing

    This way you preferre is not suitable because most of application's operations work with database and connecting/disconnecting every time takes some time and would slow the application.

    Any ideas?
  29. Replies
    6
    Views
    4,152

    Re: How to speed ADO connection via MSDAORA?

    here is code to create the connection:

    Err.Clear
    On Error GoTo ErrorHandler
    Set gConnection = New ADODB.Connection
    gConnection.ConnectionString = "Provider=OraOLEDB.Oracle;" & _ ...
  30. Replies
    6
    Views
    4,152

    Re: How to speed ADO connection via MSDAORA?

    I'm using VB6 with ADO components(2.8 library).

    I decided to switch from MSDASQL to OraOLEDB.Oracle because I got application error on some pc after closing application.

    That means I replace...
  31. Replies
    6
    Views
    4,152

    Re: How to speed ADO connection via MSDAORA?

    I note that also OraOLEDB.Oracle provider with TNS-less connection is slowly than MSDASQL provider through DNS.

    I need to read 20 SQL query. I tried to change cursor from adClient to adServer but...
  32. Replies
    6
    Views
    4,152

    How to speed ADO connection via MSDAORA?

    Hello

    Now I'm using MSDAORA provider instead of MSDASQL and it seems slowly than MSDASQL.

    I executes cca 20 SQL simply query to remote Oracle database and it takes 5 times more time.

    How can...
  33. Replies
    3
    Views
    500

    Re: Problem with closing of application

    Hello

    I found out that my connection uses default OLE Db provider MSDASQL.1.

    My connection string was:
    "DSN=MYDSN;PWD=heslo;UID=user"

    Then I tried to used other provider as MSDAORA.1 with...
  34. Replies
    3
    Views
    500

    Re: Problem with closing of application

    sorry concrete address si 0x7c910f29
  35. Replies
    3
    Views
    500

    Problem with closing of application

    Hello

    I have a simply VB6 program which connects to the Oracle database via ADO (2.8). It works fine on PCs with the english and also german Windows XP.

    But when I close the program on german...
  36. Replies
    4
    Views
    655

    Re: How to quickly load folder structure?

    I've forgotten. It should load the folders on network computer.
  37. Replies
    4
    Views
    655

    How to quickly load folder structure?

    Hello

    I need to read structure (all files and subdirectories) into my directory and file lists. These lists will be used to very simply polulating of the treeview component.

    I've used...
  38. Replies
    4
    Views
    1,617

    Re: Application error after closing

    Hello

    One note:
    Old version of application doesn't handle closing of connection to database.
    Therefore I added this source code into Unload method:


    Err.Clear
    On Error GoTo ErrorHandler
    ...
  39. Replies
    4
    Views
    1,617

    Application error after closing

    Hello

    I have got one VB6 application working on ORACLE database via DAO. In case that application runs longer time and I close it then I got following error:

    The instruction at "0x7c921689"...
  40. How to retrieve id of treeview node via API?

    Hello

    I need to retrieve the handle of treeview note. That means how can I retrieve TV_ITEM whe I have only hwnd of treeview and reference to node?

    Thanks
Results 1 to 40 of 178
Page 1 of 5 1 2 3 4



Featured


Click Here to Expand Forum to Full Width