shree123's Q&A profile

• SQL Server Linked server to VFPOLEDB working in 2000 but not in 2005?

  I have run the following command and opened a working linked server in SQL Server 2000 but it fails for 2005. sp_addlinkedserver 'AZ' , '' , 'VFPOLEDB' , 'c:\comp01\company.dbc' To test, I run: select * from openquery(AZ, 'select * from contact') and I ge   Msg 7399, Level 16, State 1, Line 2 The OLE DB provider "VFPOLEDB" for linked server "AZ" reported an error. Access denied. Msg 7350, Level 16, State 2, Line 2 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mech Commander 2 Shared Source Release Intall problem

  Hey there, I'm using XP professional Korean version with sp2...I've installed XNA Builder without any problems, but when I install the Mech Commander 2 Shared Source Release, a error messege popped up like this: Error 1324. The path Microsoft MechCommander 2 Shared Source Release contains an invalid character. Then the installation finished. Could anyone be pleased to tell me what can I do for this I've download it twice, but th ...Show All

• Visual C# Create extended stored procedure

  Hi, You could present structure of a code extanded stored procedures for SQL 2000 on C# Thank It is not possible to write an extended stored procedure for SQL 2000 using C#. You will need to use C++ Regards, Vikram ...Show All

• Software Development for Windows Vista how to change the time to Beijing time in WWF?

  when i tracking the workflow instance , I want to change the tracking time to beijing time , can you help me, thanks WF will always use UTC as the format to track time in the database. It is not possible to hard-code time to a local time zone in the tracking database. Using UTC enables the system to deal with different time zones in a client server scenario. Deserialization of datetime values converts from UTC to local time in the workflow ...Show All

• SQL Server Anaylsis Services over HTTP

  Hi guys, I am hoping this will be a quick one. I am using Analysis Services 2000 with SP4 on Windows XP. It is the Developer Edition so I should have all the functionality of the Enterprise Edition without the scalability. Ok, so I have followed the “INF: How to Connect to Analysis Server 2000 By Using HTTP Connection” ( http://support.microsoft.com/ kbid=279489 ) article on MSDN. On completing the steps I did see a blank page, whi ...Show All

• Visual Basic multiple button with 1 method

  hi there, i have set of 5 buttons, and i would like to use 1 method to listen to these 5 button's click event and display the particular name of the button when i click 1 of it using messagebox, i have no idea how to implement it, can anyone show me example: when i click Button1, a messagebox will prompt and show me  "Button1", so as well for others Private Sub Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Ha ...Show All

• SQL Server Reporting Services 2005- Excel Download

  Is there any way to maintain formulas when downloading to Excel... Meaning if my report has this desc       value widget a     1 widget b      2 widget total  3 I want to have the "Widget total" have to have the formula in excel when it downloads and not the number "3". ...Show All

• Visual C++ font italic and bold

  Hi, I'm having trouble changing fonts to bold nad/or italics. I have the following which works for font type,size and color: System::Drawing::Font *drawFont = new System::Drawing::Font(font_type,font_size); Color myColor = Color::FromArgb((int)r,(int)g,(int)b); SolidBrush *drawBrush = new SolidBrush(myColor); ev->Graphics->DrawString(text_data.c_str(),drawFont,drawBrush, x, y); However I cannot change to bold or italics. Any suggestions wi ...Show All

• Visual C# Monitoring a DB Table!

  Hi, It would be great if someone can provide me a better solution to this problem. I need to constantly monitor a sql table. If any new records are added to this table, I need to fetch the newly added records and process them. Right now I am using an infinite loop to do this in C#. Is there any other efficient way of doing this. It would be helpful if you could provide your solutions in C#. Thanks & Regards, Frenz ...Show All

• Visual C# Password?

  Is it possible to password protect a program Hi, That makes sense and it does, but I would like my password character to be like which is used for most internet logins like the Window Live ID login. Is making these passwordChar characters allowed Thanks. Eragon. ...Show All

• Visual Basic Crystal missing from Clickonce Preq

  I do not have Crystal available on the publish/prerequisite screen. Only Framework ans SQL Server. Anyone know why The app does not run on deployed machines. Thanks Hi, In deploying projects with Crystal Reports. You'll have to include the merge modules (*.msm) from crystal reports ( try downloading it here ). specify the license of your crystal in the merge module and your done...       che ...Show All

• Visual Basic Copying the Contents of a Folder

  VB.Net 2003 I am looking for any code snipets that allow in vb.net 2003 to copy the full contents of a folder to another folder name. Thanks, Fred The following quick-and-dirty code should work in VS 2003 for copying files: Imports System.IO Module Module1 Sub Main() Dim path1 As String = "C:\dir1" Dim path2 As String = "C:\dir2" Dim files() As String = Directory.GetFiles(path1) ...Show All

• SQL Server Sharing datasources

  I have 2 datasources in the home folder. But when I import a new report in a subfolder it doesn't find the datasource. How can I reference a datasource in other folder The data source in the report designer is always located in the same folder as the report (report designer does not support folders). As such, when you publish just your report, the data source settings will reference a data source that is in the ...Show All

• Visual C++ relative path

  hi! how can i specify a relative path in vc++ 2003 i have a program (.exe) in some path. this program needs to read a txt file in the same path, but i don't want to specify the absolute path(ie, c:\dir1\dir2\text.txt), i want specify just the file name (ie, text.txt). anybody can help me thanks, marcelo Here is some of my own code, hope to be helpful CString m_AppPath; TCHAR temp[MAX_PATH];  ::GetModuleFileName(AfxGetInstanceH ...Show All

• Windows Forms Refresh Designer at Design Time?

  Hi,   I’ve created a simple user control which resizes its height automatically according to the image size loaded by a user at design time. After loading the image my control resizes but the control selection area doesn’t resize automatically - only when I click on the control. My control also has a custom control designer which restricts the control user to set the user controls height at design time.     ...Show All