Patricia's Q&A profile

• SQL Server How to access different sql server with quey analyzer?

  Hi everybody, I do not know if this is the correct area to post this topic So, How to access different sql server with query analyzer Usually, when to install sql server, it access the database server locally installed, now I like to access other sql server within a domain using query analyzer. How to configure this in order I could use query analyzer to access other sql server within a domain Thanks in advanced. den2005 ...Show All

• SQL Server IMPORT DATA FROM XML SOURCE TO SQL

  Hello, I'm trying to import data from a xml file (several tables inside) into sql tables. - In the xml source, I choose the xml and xsd files and I see all tables perfectly. - Drag the xml source output to Sql Destination input, choose one table to import and create the sql table - I execute the task and it concludes ok - In Execution Results window appears as warnings as fields of each one other tables (giving information abou ...Show All

• SQL Server Message Queue Task

  Ok, im making some progress. So what i have is a Message Queue Task which is bound to a message queue connection manager (which 'tests' ok). The Message Queue Task is set to recieve, variable from string message (declared a variable of type string) and to remove the message from the queue. The output of that task is piped into the data flow task. The data flow task expands into a XML Source which is configured to get its input from the string i ...Show All

• SQL Server How to reference different databases on different servers in one query

    Hi, I'm a novice to SQL Server, though I have some experience in Access. My problem is this: I have a table on my local database that I want to insert into a remove database on a different server What are the steps neccessary My local server name is 'HOME\SQLEXPRESS' Local database: 'MyDBTest', table name: 'dbo.Courses' (the fields are: ID, CourseName, TeacherID) The remot ...Show All

• Visual C# using dataGridView EditingControlShowing for Keypress and multiple calls

  I am using the following logic to capture the keypress event in a dataGridView so that I can edit numeric cells.  The logic works but my logic is being called multiple times on a singe keypress.  For example, when the character "A" is pressed, the message box will be displayed from 2 to 6 times on the screen before the control is returned back to the cell so that more data can be entered.  The first time an incorrect characte ...Show All

• Visual Studio Express Editions Newbie needs help with assignment

  Hi, I am a new newbie and need to get a simple login and password form for my app, which is just a single data-entry form. Any advice There should be a template for a Login Form when you add a windows form to your project. You'll still need to code the validation stuff but its the basic template for the form Here's another positing that has some code as well.. http://forums.microsoft.com/MSDN/S ...Show All

• Visual FoxPro Two questions (about database structure & controls)

  Hello. Today I've stumbled upon two problems I couldn't solve myself. 1. How can I get the structure of a dbf file (in order to make a query for creating the same table in MS SQL) 2. How can I address objects in a form by a cycle. For example    for i=1 to 10       thisform.command(i).caption = str(i)    endif Thanks a lot in advance Thanks very, very m ...Show All

• Architecture biztalk Configuration problem

  Hi, I have installed biztalk server 2004 on windows 2000 professional machine which is having local sql server 2000 client. The sql server 2000 database resides on another wondows 2003 server machine. When i am configuring biztalk server on my local machine(through configframework), it gives me following error Failed to create SQL login for biztalk administrators group on database server "RemoteWindows2003ServerName". Windows ...Show All

• Visual Studio 2008 (Pre-release) Not able to generate proxy with typed dataset using svcutil.exe and WCF Feb CTP (with Jan Ctp was working fine)

  Hi, I wrote an WCF service using Jan CTP which transfer the typed dataset to and from between client and service. It is working with Jan CTP and I am able to generate the proxy using the SVCUtil.exe. Recently I have updated my system to work with Feb CTP and provide the necessary chnages in the App.config file. when I tried to generate the new Proxy with SvcUtil.exe( WinSDK FEB version) I got the below error: Error: Unable to obtain Met ...Show All

• Software Development for Windows Vista ASP.Net and SQL Persistance?

  I am creating workflows in a ASP.Net Form with the Workflow and Persistance declared in the Web.config. This was functioning fine in Beta1. After making what I believe the new declarations to be, I seem to be unable to persist in this new version. Anyone else have similar problems Joe, What kind of problems are you having with persistence Could you post any exception messages or any other info detailing the ...Show All

• Windows Forms datagridview add new row

  How do you get the values that were entered into a new row of a datagridview and update the datasource Is there an event that is fired when the user is finished or should I use an "add new button" to capture the new row. I am using bindingsource in my datagridview. the bindingsource datasource is a dataset. thanks! yanci. I added the statements and I get the following error: Update requires a valid InsertComm ...Show All

• Windows Forms Anyone know a free tree control that allows you to set node images?

  Hi, Has anyone come across a free windows forms tree control that allows you to set images on a per node basis Thanks, Alex Oh duh! for some reason I thought you couldnt do that.  Thanks Mick.  Alex ...Show All

• SQL Server How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. because some tables inside contain only numbers so i have to search for the keyword and display the result(omim number) and link this result number to a table contain num ...Show All

• Visual Studio Express Editions FAQ and knowledgebase about serial communication.

  It seems that a lot of people - including myself - has troubles with the serial port - especially if you want to push the system to the limit or for example uses break conditions to separate telegrams. It also seems that very few people are able to help when it gets a little more tricky. The subject is much too big for FAQ, as you need program examples etc., and if you load a program as a part of a new thread, it will very fast be digged down ...Show All

• SQL Server Integrated Security...

    Does anyone know how to impersonate a user and then use integrated security with SQL server   Every place I've looked so far only shows how to use integrated security through IIS.  For some reason, everytime I impersonate a user account, SQL server identifies me as "NT AUTHORITY\ANONYMOUS LOGON"  Is this by design or am I doing something wrong Just to conclude: the problem stems from using ...Show All