Search:

Type: Posts; User: mojo69

Page 1 of 13 1 2 3 4

Search: Search took 0.18 seconds.

  1. Re: SQL Server 2012 script to backup db not working -

    A backup in Management Studio works fine. When I call the stored procedure from a query window in Management Studio it works fine. If I call for only the problem database to back up from my code it...
  2. SQL Server 2012 script to backup db not working -

    I am calling this sproc from my vb6 code three times in a row in order to back up the three databases our application uses. The first database appears to backup and then disappears from the the back...
  3. Replies
    3
    Views
    2,074

    Re: Adding control error

    AxisMediaControl version 6 and higher no longer supports VB6.
  4. Replies
    3
    Views
    2,074

    [RESOLVED] Adding control error

    Opened up the project today and could not save a particular form. This one has a Axis Media Control on it. When I take the control off everything saves. Have had the same SDK for the Axis Media...
  5. Replies
    1
    Views
    4,459

    [RESOLVED] Create Bitmap from raw image data

    I am using this code to create a .bmp out of raw image data. The data is in a byte[]. It creates the .bmp for me but the image looks like all the data is 'squished' (technical term) at the top.
    Any...
  6. Replies
    9
    Views
    1,440

    Re: Weird issue with PictureBox control

    To capture a fingerprint.

    I think i just need to prepend the data with bitmap information. Struggling to find a good example.....
  7. Replies
    9
    Views
    1,440

    Re: Weird issue with PictureBox control

    I have tried the various ways described. I talked to the Secugen people and they informed me that their control is only creating the raw image file. This may be why the image disappears. I now need...
  8. Replies
    9
    Views
    1,440

    Re: Weird issue with PictureBox control

    Yes. As soon as it hits that line of code the image disappears.
  9. Replies
    9
    Views
    1,440

    Re: Weird issue with PictureBox control

    During debugging I stop on the line and check the Picture2.Image.Height and Picture2.Image.Width properties and there was data there. The numbers are not the dimensions of the control?
  10. Replies
    9
    Views
    1,440

    Re: Weird issue with PictureBox control

    How can I be sure whether .Image and/or .Picture has data?
  11. Replies
    9
    Views
    1,440

    Weird issue with PictureBox control

    Everytime I reference the picturebox control the image/picture disappears. For example:

    Private Sub Command1_Click()

    PicturePrint.Picture = Picture2.Picture
    End Sub

    Neither PictureBox has...
  12. Replies
    5
    Views
    1,382

    Re: Refctoring if statements, a better way?

    I would like to show only one message and then get out. If any of them are busy I cannot let it continue.firoz.raj suggestion looks like it would do the trick. Which way is more efficient?
  13. Replies
    5
    Views
    1,382

    Refctoring if statements, a better way?

    I want to check if a group of backgroundworkers are processing when a user may click on the button that starts them. Is there a better way than this?

    if (bgwCheckFinished.IsBusy)
    ...
  14. Replies
    17
    Views
    2,154

    Re: Difference where query executes

    What is supposed to happen after it finished sorting things out? Should it go back to the prior size? A compact and repair is performed each evening which greatly reduces the size, sometimes 100+ MB...
  15. Replies
    17
    Views
    2,154

    Re: Difference where query executes

    That is interesting because I watch the size of .mdb bloating right after I run any query that might contain more than a couple thousand records. The database is only ~500MB, so it is not close to...
  16. Replies
    17
    Views
    2,154

    Re: Difference where query executes

    Largest column size is 32 characters.

    When the customer is off the system tonight I am going to change the indexing. It will index only on RecordID and APHFChkNo. Two of the current fields that it...
  17. Replies
    17
    Views
    2,154

    Re: Difference where query executes

    APHFChkNo and APHFSeqNo are not among the indexed fields.
  18. Replies
    17
    Views
    2,154

    Re: Difference where query executes

    Table APHF01 is approximately 113,000 rows, 19 columns and it looks like there 4 of the columns that say indexed = Yes.
  19. Replies
    17
    Views
    2,154

    Re: Difference where query executes

    The DAO operation is throwing a 'system resource exceeded' error. Running the query inside access does not?
  20. Replies
    17
    Views
    2,154

    Difference where query executes

    What is the difference between running this statement

    SELECT * FROM APHF01 WHERE (APHFChkNo = '111265') ORDER BY APHFSeqNo DESC;
    from a VB6 app using DAO and running the same query in Microsoft...
  21. Replies
    2
    Views
    1,014

    Re: Access delete query bigger than 2GB

    Thanks for the reply. With this table there are no Foreign Keys or cascading deletes. It did contain around 600000 records. The total database size was 300 mb. There are just two tables, with the one...
  22. Replies
    2
    Views
    1,014

    Access delete query bigger than 2GB

    Why would a delete query (deleting 200,000 records) throw an error telling me that the query is too large? I have some suspicions about the table that I am deleting from, but am wondering how the...
  23. Replies
    4
    Views
    1,393

    Re: Upsize Access DB to SQL Server 2008

    Serge, how would I write loop to alter each of them
  24. Replies
    15
    Views
    12,730

    Re: Error code 3035 question.

    That is what I thought. Curious as to why the person who wrote this code would not clean it up. When I put the .Close in the code is there a way to tell if the RecordSet is null?
    ie.


    If Not...
  25. Replies
    15
    Views
    12,730

    Re: Error code 3035 question.

    Just noticed that RecSet.Close never happens for this operation. Is this a problem? A new Recordset is created each time the function is called.
  26. Replies
    15
    Views
    12,730

    Re: Error code 3035 question.

    This is the line where the error occurs.


    Set RecSet = Glob.dbAppDB.OpenRecordset(SQLStatement, rstype)

    rstype is dbOpenDynaset
  27. Replies
    15
    Views
    12,730

    Re: Error code 3035 question.

    SELECT PMTDHDR05.RecordID, PMTDHDR05.RecordTS, PMTDHDR05.RecordCS, PMTDHDR05.OwningID, PMTDHDR05.PaymentType, PMTDHDR05.HDateFlag, PMTDHDR05.NetTot, PMTDHDR05.CmptrNo, PMTDDET05.OwnerID,...
  28. Replies
    4
    Views
    1,393

    Re: Upsize Access DB to SQL Server 2008

    This would have to be done for around 400 tables. Manually changing the field is what drove me to post a question here. Can I do this in C# programmatically?
  29. Replies
    4
    Views
    1,393

    Upsize Access DB to SQL Server 2008

    When Upsizing an Access 2003 databse to SQL Server 2008 how can I set my autonumber fields to convert with Identity Specification set to yes and 1?
  30. Replies
    15
    Views
    12,730

    Re: Error code 3035 question.

    To be clear, Access 2007 is installed on the machine and we only use it to make database changes etc. The application is still using the old jet engine.

    Also I wish the original developer would...
  31. Replies
    15
    Views
    12,730

    Re: Error code 3035 question.

    We have started the process to upgrade the application to .Net. However this process is going to take some time since we are a two person shop and have a learning curve.
    We have this application in...
  32. Replies
    15
    Views
    12,730

    Re: Error code 3035 question.

    Thanks but I already changed the MaxLocks to 2,000,000 awhile ago. Any other ideas?
  33. Replies
    15
    Views
    12,730

    Re: Error code 3035 question.

    Access 2007
    Windows Server 2008 R2 Standard Service Pack 1 64 bit
  34. Replies
    15
    Views
    12,730

    Error code 3035 question.

    I have a VB6 app using DAO to connect with Access database. The last two days users have been getting Error Code 3035 System Resource Exceeded when doing a simple query. Example: "SELECT * FROM...
  35. Replies
    3
    Views
    759

    Division results in 8.32957075464354E-03

    Here is the equation:
    401.25 / 48171.75
    this results in this:
    8.32957075464354E-03
    how do I get the correct number which is: 120.05420560....
    The total number is 28 decimals long. Basically I...
  36. Replies
    1
    Views
    921

    Application Memory Explanation

    Where can I find an explanation of how C# Apps handle memory when they launch? I think I have a problem with a simple executable that seems to be use more and more memory the longer it runs.
    ...
  37. Replies
    2
    Views
    1,168

    Re: EventLog issue writing from class

    I had not copied the new compile version of the .dll created for the class that I was having trouble with.
  38. Replies
    2
    Views
    1,168

    [RESOLVED] EventLog issue writing from class

    When I step through my code in the debugger the EventLog entries I am creating appear in the eventlog. When I run executable the eventlog entries for one particular class do not appear, but the...
  39. Replies
    3
    Views
    4,118

    Re: nTier question on WCF Service

    So...Service1.cs is a passthrough to the BLL? At this 'tier' am I only setting up DataContracts and the corresponding function calls?
  40. Replies
    3
    Views
    4,118

    nTier question on WCF Service

    I have two classes (Service1.cs and IService1.cs) in a WCF project.
    Do I think of these as the Business Logic Layer or only as a passthrough to access the BLL, DLL, etc.? Also I think that there...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width