DanMeyers's Q&A profile

• .NET Development Trying to get access to Access DB from VB.Net application

  I am trying to get access to an Access database from within my VB.Net application with the following: Dim oAccess as Access.Application My problem is that Access is not recognized. When I try the above statement I generate the following error "Type 'Access.Application' is not defined." I am using Visual Studio 2005 (VB.Net) and have added the following references in my project: Microsoft Access11.0 Object Library Microsoft ADO Objects 2.5 Microsoft DAO 3.6 Obj Library Microsoft Office 11 Obj Library Microsoft Visual Basic for Applications Extensibility With the above added, I still get the same error. Thanks Hello Christie, I understand why your doing what your doing but I need ...Show All

• Visual C++ Problem in using TOM (Text Object Model)

  I using this source code that i take it from MSDN but it has some errore. please help me to solve it. Code: ITextDocument *pDoc; ITextRange *pRange; ITextSelection **selection = NULL; IUnknown *pUnk = NULL; SendMessage(hwnd, EM_GETOLEINTERFACE, 0, (LPARAM)&pUnk); if(pUnk && pUnk->QueryInterface(IID_ITextDocument, &pDoc) == NOERROR) { pDoc->RangeFromPoint(pt.x, pt.y, &pRange); // ... continue with rest of program pDoc->GetSelection(selection); } Error: c:\Documents and Settings\Devil\My Documents\Visual Studio Projects\scratch\scratch.cpp(54): error C2664: 'HRESULT IUnknown::QueryInterface(const IID &,void ** )' : cannot convert parameter 2 from 'ITextDocument **__w64 ' to ...Show All

• Visual Basic Sending Key to an other application

  Hi all, I need to build a small application that sends predefined key stroke to an other application, lets say for example, Microsoft Words. I know that might be simple but I never had to do that so does anyone has any idea what function I need to use thanks for helping. Yeah I figured that out, but how do you get FindWindow() and SetForeGroundWindow() to work FindWindow() always returns "0", how can I get the class name of a window (Acrobat) or the title of the window Thanks again ...Show All

• Software Development for Windows Vista WINSOCK DGRAM socket bind() BUG

  Hi, I think that I found a bug in Vista winsock implementation, I'm not sure where to report, so I'll post it here. Description: If bind() call on datagram socket returns that scocket is in use WSAEADDRINUSE (10048), then next call of bind() on the same socket on a free port returns WSAEINVAL (10022) i.e socket is bound already. How to reproduce: Write a simple program that opens 2 datagram sockets, bind one of them on a free port, then bind the second socket on the same port, so you'll get WSAEADDRINUSE, then try to bind the second socket on a free port and you'll get WSAEINVAL. Test case: WSADATA wsaData; int iResult = WSAStartup(MAKEWORD(2,2), &wsaData); SOCKET Socket1 = socket(PF_INET, SOCK_DGRAM ...Show All

• Visual Studio Express Editions COM Interop with VB Express Edition?

  Hello, I am new to this world, but trying to piece together a solution which will allow a couple of different applications to speak to each other. I have some instructions from one of the applications which imply I need to use the COM Interop functionality. But I only have the Express Edition of the VB program. Does the Express Edition allow me to use this functionality or do I need to upgrade to another version to get this to work Thanks much! David ...Show All

• SQL Server Help Please...request to send data to the computer running IIS has failed

  Hello,    I am trying to complete the BOL sample " Creating a Mobile Application with SQL Server Mobile". Using SQL 2k5 and VS Team Suite. I have the emulator about to get on to the internet and can even get to the http:// sqlce.domain.com/sqlmobile/sqlcesa30.dll url but when runing the vb.net code I get the error 28037 "A request to send data to the computer running IIS has failed. For more information, see HRESULT.". Any help would be greatly appreciated. No software firewalls are running. I have a dns entry that points to my laptop for testing. The sync function code is below. Sub sync() Dim repl As New SqlCeReplication() repl.InternetUrl = "http://sqlce.domain.com/SQLMobile/sqlcesa30.dll" repl.Publish ...Show All

• .NET Development Import Data from Sybase into a Recordset

  Hello,   I'm trying to import Data from a Sybase Database with a VB 2005 Application. Everything works fine, the only problem is, i receive wrong data  out of Datafields which contain the style money (Currency). Trying different version of code as follows:  Dim Price as Decimals = rs1a. Fields( "NW_Cur_PreisBrutto" ).Value Dim Price as Double = convert.toDouble(rs1a.Fields ( "NW_Cur_PreisBrutto" ).Value) Any Ideas what's wrong thank you, for taking time and give me a hand. Wolfgang   Zlatko, thx for your help. the latest MDAC was allready installed on my machine. The only thing i can do now is search for another OLDEB provider Wolfgang ...Show All

• Visual Basic Can you reference an array with a variable?

  Hi, I'm having a problem with my program.. Im sorry if this is a beginner question but im still new to VB. My question is can you use a variable in place of an array index to pull up a value Here is my code, but on the line sysIDs(g) = currentSysID.ToString It throws a null reference and says An unhandled exception of type 'System.NullReferenceException' occurred in Hydra.exe Additional information: Object reference not set to an instance of an object. Anyways, here is the code. Its basically pulling data from a table column and storing it in the array. Dim rowCount As Integer rowCount = SysTable.Rows.Count Dim sysIDs() As String Dim mismatchSysIDs() As String Dim currentSysID As ...Show All

• Visual Studio Express Editions Learning VB

  This may sound stupid but I am new to VB programing. I have read books and taken a few classes in programing. My question is how do you know what each peice of code is used for and how you know it is there txdiver78133 wrote: My question is how do you know what each peice of code is used for and how you know it is there Answer: comments and documentation. If you are just learning, these are two of the most powerful tools at your disposal. As you write code, write a comment for almost every line. Make your variables with meaningful names (e.g. don't use ' iNum ' for a variable name, if it's counting seconds 'til quitting time; use something like ' SecondsTilQuit ') Either way, be consistent. Always have a pen and paper, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rendering To Textures in Beta2

  I used Texture2D's heavily with the usage RenderTarget, however in Beta 2 its like a whole new API. I understand that Surface no longer exists and RenderTarget/2D should be used. The problem is, the whole mentality is backwards compared to what im used to. From what I see I should create a RenderTarget2D and set that as a render target, then do rendertarget.GetTexture() if I want to set it. Thats fine. However, how do I copy between render targets There is no StretchRect or equivelent function I can see, which I used alot before. Surely I dont have to go about getting a texture, setting it, creating a 'copy' effect, setting a new render target, resolving the new render target just to copy from one to another Is there no alte ...Show All

• SQL Server C code to import image to SQL Server 2000

  I know my question is kinda weird but it seems I have to do this way or threre are some better ideas. Could you show me a sample C code to connect to a data server and call a stored procedure to import an image file into SQL Server 2000 I am writing an extended stored procedure in VS 2003 .NET and it seems extended stored procedure can only work with C code. Thanks! YL Iy you are using ODBC, you can try SQLPutData There is some code sample in the following link http://msdn.microsoft.com/library/default.asp url=/library/en-us/odbc/htm/odbcsqlputdata.asp ...Show All

• Visual Studio 2008 (Pre-release) WPF Controls Help...

  Hello, I have a Window, which contains a stackpanel. I've added two WPF UserControls, each of which contains a Canvas and some elements within the canvases. The problem I have the two User Controls stacked, however, it appears the second Canvas's elements are drawing from the top of the Window, not the second canvas. I can place a TextBlock in the Canvas and set Canvas.Top="1", however, the "1" is set from the Window, not the Canvas in which it is contained. Maybe it's taking a cue from the first Canvas. Anyone know how to address this issue Or what I'm doing wrong I'd rather not compensate for this in the User Control, as I want them to be separate, and not know what the other is doing. ...Show All

• .NET Development Reading SID's, ACE's and DACL's

  Im building a tool that will periodically check a directory for a number of things, including the permissions that the 'network service' account has, namely whether it has write & modify access or not. Im new to windows security programming, but im working through an example using the .net framework class wrappers. Some of the code im using is listed below. Questions: - Is the first part of a SID going to be the same for a given user name from machine to machine Code that isnt written yet - im going to loop through the access list until i find the account(s) im interested in and then check their FileSystemRights, which is stored as a "OR'ed" string. Question - Is there a better way to refer to system accounts that ...Show All

• SQL Server Failed to create user login

  This is the error message i keep getting when following the SQL Server tutorial on how to make a new user; TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Create failed for Login 'employee'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ The MUST_CHANGE option is ...Show All

• SQL Server Replication vs other agent jobs

  Hi all, after creating the replication job (works) other agent jobs hang up. after restart the agent, the jobs work one time. t can it be a problem with dieffernt agent profiles/accounts   many thanks oliver Here are a couple articles that document the problem, some of the know workaround is to increase the desktop heap, which I woulnd't recommend, stagger the start job times, change the proxy account for some of the jobs, move to 64bit OS (which isn't very practical for many): http://support.microsoft.com/kb/824422 http://msdn2.microsoft.com/en-us/library/ms152544.aspx ...Show All