Search:

Type: Posts; User: Tgirgenti

Page 1 of 3 1 2 3

Search: Search took 0.07 seconds.

  1. Re: [RESOLVED] "Runtime error '430' class does not support Automation or does not sup

    madnessman,

    I'm not sure of what your point is.

    Thanks,
    Tony
  2. Re: Why does a 93 character string return a length of 42

    I can't explain it. I just know that's what happens on my computer.
  3. Re: Why does a 93 character string return a length of 42

    dilettante,

    Do you not understand my explanation?

    Tony
  4. Re: Why does a 93 character string return a length of 42

    Sorry everybody.

    I had:
    Dim X

    I changed it to:
    Dim X As Integer.

    That fixed it.
  5. Why does a 93 character string return a length of 42

    Hello,

    I'm using VB6 on a Windows 7, SP1 computer.

    Can anybody explain why this function returns a length of 42?


    X = Len("\\TONY-PC\CoyneEDMS\Bin\DeliveryPaperwork.exe...
  6. Re: [RESOLVED] "Runtime error '430' class does not support Automation or does not sup

    Thanks RobDog.

    I am totally overwhelmed by all this not to mention totally confused.

    I will continue to make sure i recompile my VB 6.0 programs on my old XP computer. I only have a handful of...
  7. Re: [RESOLVED] "Runtime error '430' class does not support Automation or does not sup

    Cayoga,

    If you are still following this thread, I have experienced the same issue.

    Compiling a VB 6.0 program in Windows 7 Ultimate runs fine in Windows 7.

    When trying to run it in the...
  8. Re: Why do I get an error when trying to close an open Recordset?

    Si,

    Thanks for your reply.

    I think you are saying that even though it seems redundant and repetitive and it is more coding, it is better to make the ADO object variables local to the...
  9. Re: Why do I get an error when trying to close an open Recordset?

    Hello Si.



    So, if i use this database and recordset in another Sub/Function of the same program, should i also declare the same stuff for them also.

    It seems redundant.

    Thanks,
    Tony
  10. Re: Why do I get an error when trying to close an open Recordset?

    Si and JG.

    Thanks for your excellent suggestions.

    I will be working on them to improve my code.

    Tony
  11. Re: Why do I get an error when trying to close an open Recordset?

    Hello JG.

    Thanks for your reply.

    After studying the Recordset Status = 4096, I decided that the error was occurring because of a previous Add/Update of a different record. Even though I...
  12. Why do I get an error when trying to close an open Recordset?

    Hello,

    I'm developing a VB 6.0 program using SQL Server 2008 R2 Express.

    I hope somebody can explain why my program goes to "Check_History_CloseRS_Error" when i execute the following code:

    ...
  13. Re: Getting Error -2147217873 when not debugging

    I put this code in my program because i was getting an Error Number: 3219, Error Description: Operation is not allowed in this context.

    This thing has me totally flabbergasted.

    Can anyone...
  14. Getting Error -2147217873 when not debugging

    Hello,

    I'm developing a VB6 ADO SQL 2008 R2 Express database program.

    I have struggled with this problem for over a day now. I am totally baffled as to what and why it is doing this.

    I'm...
  15. Re: Will ADO update records without a 'recordset.Update' statement?

    Thanks JG.

    That's something I did not know.

    So, if i just want to get a count of records that it will update, i should comment out both lines:


    With newMSDSHistoryDBRecordset
    ' ...
  16. Re: Will ADO update records without a 'recordset.Update' statement?

    Hello Si.

    Thanks for your reply.

    I'm not sure I understand your last two sentences.

    The reason why I am asking this question is because, when i ran this program, it updated all the records...
  17. [RESOLVED] Will ADO update records without a 'recordset.Update' statement?

    Hello,

    Will this code update the newMSDSHistoryDBRecordset!ObjectID when it gets to the With/End With area?

    Any help would be gratefully appreciated.

    Thanks,
    Tony
  18. Re: [RESOLVED] Open multiple databases with one connection

    Thanks for your answers.

    I will take your answer as a definite no.

    This post is resolved.
  19. Re: Open multiple databases with one connection

    Thanks for your answers.

    I'm using ADO 2.8 to connect to a SQL Server 2008 R2 Express server from my VB 6.0 program.

    I use this same connection string for all four databases that i open using a...
  20. [RESOLVED] Open multiple databases with one connection

    Hello,

    I'm using VB 6.0 with SQL Server 2008 R2 Express.

    Can I open and use more than one database concurrently with a single connection to a server/instance?

    Thanks,
    Tony
  21. Re: How to manipulate data after reading from binary file

    Thanks Si and Opus for your replies.

    Yes, the binary mode of opening a file might be faster, but I don't consider that a benefit since there is more coding involved to actually manipulate the data...
  22. How to manipulate data after reading from binary file

    Hello,

    I'm developing a VB 6.0 SP6 program on an XP Pro, SP3 computer.

    I used the information from here: http://www.vbforums.com/showthread.php?t=342619 and here:...
  23. Re: Does stored procedure need to be in database?

    szlamany,

    I have to apologize for my inability to state my problem in a clear and understandable way. Since my reopen post of last Tuesday, I should have been more specific about what i am...
  24. Re: Does stored procedure need to be in database?

    szlamany,

    I very much appreciate your intention to help me produce a well coded program.



    Confused by this. What would a stored procedure do? Wouldn't it create the databases and tables?
    ...
  25. Re: Does stored procedure need to be in database?

    I'm not trying to ignore your request. I'm just not sure of how this helps you. There are no stored procedures for the current existing working program, but here is the procedure to create one of...
  26. Re: Does stored procedure need to be in database?

    FunkyDexter,



    The temp database holds data and printed lines until the program can figure out which PDF documents to attach to it. I didn't write that program, i'm just trying to do the same...
  27. Re: Does stored procedure need to be in database?

    szlamany,


    This is a totally client running program. It does not involve a server except to print to different printers based on location.


    I'm sorry, but I don't get it. Stored procedures...
  28. Re: Does stored procedure need to be in database?

    I guess I should have told you I am doing this in VB 6.0. I'm not as adept with the SQL language as you seem to be. I could have given you that kind of detail, but not in that language.

    I...
  29. Re: Does stored procedure need to be in database?

    Wow!

    I thought everybody would be happy that I found a way to create a temporary recordset.

    You seem quite adamant about my choice to use a disconnected recordset and i'd like to know why.

    I...
  30. Re: Does stored procedure need to be in database?

    I'll probably use this method for what I need: http://www.vbforums.com/showthread.php?t=395591

    Thanks to everybody for their help.

    Tony
  31. Re: Does stored procedure need to be in database?

    Hello leinad31.

    I'm not sure I understand what you are saying.

    What is "ETL" and what do you mean by "permanent part of the business process"?

    I'm not in touch with the person that wrote the...
  32. Re: Does stored procedure need to be in database?

    Hello Szlamany.

    What you say makes sense. I was trying to do things the same exact way and sometimes that's not a good idea.

    I just checked a database after a current run. It's hard to tell...
  33. Re: Does stored procedure need to be in database?

    Hello,

    I'd like to reopen the dialogue of this thread in light of a program that i want to convert from a VB 3.0/Access Database(.MDB) program to a VB 6.0/SQL Server 2008 R2 program.

    The VB 3.0...
  34. Re: Need recommendation for development computer

    Hello Shaggy.

    Thanks for your reply.

    I'm not sure of why I would need two monitors. I have never had a situation where I found myself wishing i had two monitors. One monitor is plenty for me....
  35. Need recommendation for development computer

    Hello,

    I currently develop VB programs on a Dell Dimension 9150 with XP Pro SP3 that I bought in 2006.

    I use my computer to develop VB 3.0 to VS 2010 programs. I also use SQL Server Express...
  36. Replies
    2
    Views
    2,232

    Re: Change appearance of VB 6.0 Datagrid

    Thanks LaVolpe.

    I am reading about custom controls, so eventually, I might think about doing it that way. Although, getting a nicer looking DataGrid is not the most urgent part of my project.

    ...
  37. Replies
    2
    Views
    2,232

    Change appearance of VB 6.0 Datagrid

    Hello,

    I'm developing a VB 6.0, SP6 ADO program on an XP Pro, SP3 computer.

    I have a DataGrid control in my program.

    Is it possible to use some Windows API to change the detailed appearance...
  38. Re: Named Pipes Provider: Could not open a connection to SQL Server [2]

    Hello abhijit.

    Thanks again for your help.

    I just wanted to let you know that the issue was resolved by putting "Server=.\SQLSERVER" in my connection string.

    I used the information from here...
  39. Re: Named Pipes Provider: Could not open a connection to SQL Server [2]

    Hello abhijit.

    Thanks for your help.

    I only know of two ports related to SQL Server. All of the sites that recommend opening ports for SQL Server, say the port 1433 should be open.

    The...
  40. [RESOLVED] Named Pipes Provider: Could not open a connection to SQL Server [2]

    Hello,

    I'm developing a VB 6.0, SP6 ADO program on an XP Pro, SP3 computer.

    I'm having a terrible time trying to figure out why the program works great in my office, but when I bring it to a...
Results 1 to 40 of 82
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width