rmcquade's Q&A profile

• SQL Server Watching an incoming directory for files to process

  Here's the senario:  We have 3000 stores each sending detail sales data polling files to our FTP site. Most of these files arrive between 10 pm and 4:00 am, with stragglers coming in all day.  We receive several different files from each store, containing different types of data (payroll, order header, order detail etc...).  Detail files could be up to 5000 rows per store. We have built several test SSIS packages that will process these files using multiple flat file connectors to load each file thru to one or more destination tables in our data warehouse.   My question:  What is the best way to execute the ...Show All

• SQL Server How to create sql server login for workgroup computer?

  How can I add a new sql server login using windows authentication where the login id is from a user belonging in a workgroup No domain connection. Just a workgroup account will have a login in the sql server using windows authentication. Thanks Thats not possible, WIndows authentication can be used if the server can prove your identity. I a (non-trusted) workgroup, this is not possible, because everyone can join the workgoup and could spoof another ones identity. You can only use the local accounts of the SQL Server to do so. In those enviroments you can impersonate the user with a remote account on the SQ ...Show All

• Visual Studio Express Editions How do I update multiple tables from a DataGridView ? (VB Express 2005)

  I have 3 tables in an access database, staff, roles and staff_roles Staff contains a staff_id Roles contains a role_id staff_roles is a join or bridge table containing staff_id and role_id What I'm trying to do is to produce a simple datagrid along the lines of staff.name (as text), roles.role_name where role_id =1(as tick box), roles.role_name where role_id = X The number of roles may change, hence building this as a seperate linked table rather than adding values to the staff table. Is this sort of thing possible using the standard GUI construction controls or would I have to build it from scratch ...Show All

• Windows Forms Caller Phone Number

  Hi all    I need help if any one can tell my how I can get the caller number from the modem if a call came to the modem and show me in the textbox the phone number. Be note: That my landline has the caller number display service research serial com port programming :) sorry I have never done this but thats where I woul ...Show All

• .NET Development POP3

  Hi, I'd like to ask how to get e-mails from a POP3 server in vb2005 and if i got them how can i show them as an html mail message thnx a lot; Here's a fairly good article http://www.c-sharpcorner.com/internet/Pop3Access.asp It's in C#, but you should get the gist. ...Show All

• .NET Development Program settings in registry

  I'm familiar with usuing the registry in vb6, but am having difficulty with .net I'm stymied in how to go about fetching the font name and size from the registry and setting my richtextbox to reflect these settings. Keep hitting the casting wall string to system.drawing etc... Warning: You're dealing with a hobbiest here... Thanks in advance for help What font name and size It sounds like the problem has nothing to do with the registry, from what you say about casting. You can't cast a string to anything to do with drawing, if you have an image, you can use Graphics.FromBitmap to get a graphics object, which then has a Dra ...Show All

• Visual Studio Team System Error with getting associate workitem after customizing team build to get version on specific workspace

  Hi I customize my team build to build on specific workspace ; I have done it by edit my TFSBuild.proj file and include there my new target . My workspace is : SHMULIK And the owner is : shmoel < Target Name = " CoreGet " Condition = " '$( IsDesktopBuild)'!='true ' " DependsOnTargets = " $( CoreGetDependsOn ) " > < Get Condition = " '$( SkipGet)'!='true ' " Workspace = " $( WorkspaceName ) " Recursive = " $( Rec ...Show All

• SQL Server SQL Authenfication

  Hi, i m trying to connect to msssql 2005 with SQL Authentication .but without success. "Server authentication is set to SQL Server and Windows Authentication mode". on connect i recive this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT:]" any help would be nice Luka Does your computer have the latest version of MDAC (2.8 SP1) You can download it from <a href="http://www.microsoft.com/downloads/details.aspx familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en"> Microsoft.com</a ...Show All

• Visual Studio Express Editions windows service pack 2 problem

  Hi, I'm having a problem installing visual express - i open the setup file and get an error message stating 'windows xp service pack 2 information - you must install this to continue'. So I go to microsft update and do so, and restart the computer etc but no luck... anyone any ideas where im going wrong Thanks in advance ...Show All

• SQL Server Using CC and BCC in Notification Services

  I'm trying to set CC (CarbonCoby) and BCC properties of an email notification. The SMTP protocol element of my ADF looks like this: <Protocol > < ProtocolName > SMTP </ ProtocolName > < Fields > < Field > < FieldName > Subject </ FieldName > < SqlExpression > SubjectText </ SqlExpression > </ Field > < Field > < FieldName > From </ FieldName > < SqlExpression > FromAddress </ SqlExpression > </ Field > < Field > < FieldName > To </ FieldName > < SqlExpression > DeviceAddress </ S ...Show All

• Windows Forms ClickOnce fails only on first time launch

  Hi, I've successfully deployed an app. to my website using ClickOnce (VS2005 beta 2). The app. installs fine on my local machine but then the JIT debugger jumps in with an argumentoutofrange exception. The debugger won't attach to my process but if I come out of the debugger and run the installed app. from the StartMenu it runs perfectly. So it's a one time problem - but where and how to resolve Thanks for your help. Jon Sameer, OK, I made my own spade. Perhaps this will help others upgrading. I had kept a current version of my app. in VS2003. When I upgraded that in VS2005Express the compiler me ...Show All

• Software Development for Windows Vista Vista Build 5342

  Hi. I'm running my AMD64 3300+ with XP Home. I've been MSN-invited to Beta test Vista and have d/l'd Vista_5342_64bit_Main_Staged_DVD_EN.iso at 3.56 Gb. When I click on the downloaded folder, it becomes a winrar archive that only extracts to a readme.txt folder that states "this disc contains a "UDF" file system and requires an operating system that supports the ISO-13346 'UDF' file system". As you might surmise, I can't install the program. I've tried burning it to a dvd but that doesn't help. Any suggestions will be greatly appreciated..thanx! Don't open it with WinRar. Either&nb ...Show All

• Windows Forms Forms

  When opening form2 from form1, how do you close form1 I believe I just answered this very question on another thread. Have a look here: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=85269 ...Show All

• Visual C++ Singular preprocessor definition needed

  This is my first post, I hope to be clear enough (sorry for my eglish) and I hope to be lucky and find the answer to a very big problem. I have a VC++ project and I need to create, during the compilation, a define that has the same name of the file that I am currently compiling. For example, if when I am compiling a file called Main.c I need to create runtime a define #define main 1 I do this by specifying the in Preprocessor Definitions section $(InputName)=1 The problem is that the command above create a define #define Main 1 instead I need the name of the file in lower case . I thought in the beginning to create a custom task in M ...Show All

• .NET Development .Net wsdl:import problem when parsing a wsdl made with websphere / java

  Dear developers, using .Net as a client for a webservice, which seems to be build with IBM Webshere / Java, results in a wsdl parsing error with the following message: The HTML document does not contain Web service discovery information. From what I have discovered, the problem remains on parsing the wsdl:import statements which are included the wsdl because it is splitted into several wsdl files which are combined using the wsdl:import statement. The problem occurs in .Net 1.1 and .Net 2.0 with the following wsdl for example: http://wsdl.eu.clickandbuy.com/EMS/1.0/EMSbinding.wsdl Is this wsdl really invalid or is this an interop/compati ...Show All