Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: diddydustin
  • Order by date
  1. diddydustin

    Wrap or 'host' an application within another?

    I'm trying to write an application that 'hosts' an application within itself... I want to run the IBM ISeries emulator software, however, I would like to have my own UI that provides a couple buttons below the actual application. So basically, I would like to write a .NET app that provides a UI...
  2. diddydustin

    Save last value in bound textbox to be used for subsequent records?

    The Default Property is not a static value and changes dynamically with each input from the user. D
  3. diddydustin

    Save last value in bound textbox to be used for subsequent records?

    Yes, I know that, but how can I set the Default Property of a textbox via VBA, and not manually through Access? D
  4. diddydustin

    Save last value in bound textbox to be used for subsequent records?

    Hey guys, I have a simple form that interfaces a table with the following fields: License, Vehicle_Make, Vehicle_Type, Vehicle_Color, Time, Direction, Vehicle_Markings, Misc, Location The user enters data in each field and then proceeds to the next record to do the same. I would like for the...
  5. diddydustin

    Parse SQL query within stored procedure

    Hey guys, I need to parse a SQL query within a stored procedure to check the syntax and see if it is a valid query. If it isn't, the error will go in an OUTPUT variable. However, I'm having trouble parsing a string within the stored procedure because SET PARSEONLY ON isn't work. It tells me...
  6. diddydustin

    IDBInitialize::Initialize returned 0x80004005 err creating link server

    Sorry needed to bump this thread because we still can't figure out this issue! Does anyone have an idea what could be going on? Thanks Dustin
  7. diddydustin

    IDBInitialize::Initialize returned 0x80004005 err creating link server

    Can you think of anything else it might be? Dustin
  8. diddydustin

    IDBInitialize::Initialize returned 0x80004005 err creating link server

    Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\Documents and Settings\dlyons>dir \\devweb\upload\AmazonQue\test_7_7_2005_9_ 2_12.xls Volume in drive \\devweb\upload has no label. Volume Serial Number is 0251-237B Directory of \\devweb\upload\AmazonQue...
  9. diddydustin

    IDBInitialize::Initialize returned 0x80004005 err creating link server

    Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Unspecified error] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]. Same error. I...
  10. diddydustin

    IDBInitialize::Initialize returned 0x80004005 err creating link server

    (1 row(s) affected) (1 row(s) affected) (0 row(s) affected) (1 row(s) affected) (0 row(s) affected) (1 row(s) affected) INSERT INTO tblQueItem SELECT e.ISBN, 121, "A" FROM ExcelSource...Sheet1$ e LEFT OUTER JOIN tblQueItem q ON q.chrISBN = e.ISBN WHERE...
  11. diddydustin

    IDBInitialize::Initialize returned 0x80004005 err creating link server

    No, sorry that is commented out. It appears on two lines because of the limits on my post. However, in the code those are commented out. What is running is: -- Build insert string SET @SQLstring = 'INSERT INTO tblQueItem SELECT e.ISBN, ' + cast(@intQueID as varchar(128)) + ', "A"...
  12. diddydustin

    IDBInitialize::Initialize returned 0x80004005 err creating link server

    Hi guys, I am trying to run the following code: -- local variables DECLARE @Worksheet AS varchar(255) DECLARE @SQLString AS varchar(255) DECLARE @RC int DECLARE @server nvarchar(128) DECLARE @srvproduct nvarchar(128) DECLARE @provider nvarchar(128) DECLARE @datasrc nvarchar(4000) DECLARE...
  13. diddydustin

    How to create form to select criteria for query/report

    Hey guys, I was wondering if anyone could help me in the right direction. I have a query that returns many results. I would like to create a form that has 4-5 textboxes/comboboxes that are used to select the criteria for the query. I guess they would be establishing a filter for the query and...
  14. diddydustin

    Need to check on form load if user is already logged in.. how?

    Hey guys, I need to check on load of a form if the database is already open by another user. If it is, I need any subsequent tries to open the database to only open it as READ ONLY and tell the user what the Windows username is of the person logged in. How is this possible? What do I need to...
  15. diddydustin

    Having problems with connections staying open

    .ConnectionString = "Data Source=devcat;Initial Catalog=abc_AmazonQue;user ID=IntranetUser; password=IntranetUser; application name=AmazonQue" When I do a 'pooling=false' in the CONNECTION_STRING i don't have the problem anymore. When it is 'true', we step through the code, see the connection...
  16. diddydustin

    Strange problems with connections not closing

    Hey guys, I have a VB.NET app connecting to SQL Server. We are having a strange problem where we will step through our code, watch connections being open, but when they close (and VB says the object is closed), SQL Server won't reflect this and the connection will stay open. Sometimes when we...
  17. diddydustin

    Having problems with connections staying open

    Hello everyone, I am having some issues with my service writen in VB.NET. I have checked all my connection objects within my code, however, somehow when the service runs connections are staying open to our database and it keeps growing and growing. I can't figure out where in my code this is...
  18. diddydustin

    Timer in Windows service stopping on i't's own

    Hey guys, I'm having a weird problem. I have a Windows service in .Net that runs fine for a while but then seems to stop. Here is a bit of the timer code: ' AmazonQue ' The registry values for storing the time intervals are: ' HKEY_LOCAL_MACHINE/SOFTWARE/AmazonQue/SuccessTime ' Time used if...
  19. diddydustin

    Query returns 3 of every record? please help

    It returns 1.
  20. diddydustin

    Query returns 3 of every record? please help

    No, the tblQueryItem table does not have multiple rows for each ID... the query generates 3 rows for each 1. Do you see from the example above?

Part and Inventory Search

Back
Top