SPeddi's Q&A profile

• Visual FoxPro Figured out... done...

  Hello All, Please, if anyone can let me know how to link a VFP DB to a SQL DB using 'linked servers' that would be great. I need to use the VFP tables in a SQL Server Reporting Services report. Using ODBC w/ a DSN (or even a connection string) locally works fine in .NET 2003. But when trying to use this method on the reporting server, I get some nasty error. To avoid having to write a trigger and a DTS package to populate the SQL DB with the VFP table data, I should be able to link the VFP back-end to SQL 7 via Enterprise manager. Maybe I'm doing it wrong, because this is relatively painless to do in Access but is not something that I can ...Show All

• Windows Forms DataGridViewComboBoxColumn value is not valid

  howde... I decided to move towards VS-2005 after seeing that the Datagrid has be revamped to included comboboxs, buttons, images etcs.. I noticed that the Dreaded Tablestlyes has been dropped (YAAAARR!!!!) any way after useing for about a day scratching my head..  I keep getting DataGridViewComboBoxColumn "value is not valid" dont make sense to me.. btw I am  not useing the wizard as I need to dynamically create Colums.. ok here is some code., shorthand code ----------------------------------------- (assume all sql statments are correct and datagridview is setup) datagridview1.datasource = dtCompany datagridview1.Autogenerate = fa ...Show All

• Visual FoxPro FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

  Hi there. I just installed a Visual FoxPro 9.0 and started "playing" with it. Tried to create a table - it is straightforward and then a form. It seems to be a rich platform. Something puzzles me though. I do have extensive experience with Visual dBASE PLUS and previous versions in terms of OO language and form/table designer. Thus I am trying to compare. I am attempting to migrate to MS software/platforms wholesale since the dBASE is offering limited options as compared to MS's tools. I am doing C# and Visual FoxPro at the same time. Anyway, So far, after about two hours of playing with FoxPro Form designer I encountered some problems. They ...Show All

• Windows Forms printing

  Hi This is the first time I am using the printing class. What I want to do, is perhaps like everyone else, customize the layout of a page and print that page, putting in the appropriate values and so on. How do I go about creating such a page, where I can position, say, a logo on the top center of the page, then a line below that, the address and so on - like an application type form layout. how can I achieve this in C# (.NET 2.0) Many thanks! You don't really print lines in .NET, you draw text. You can place text anywhere you want (Graphics.DrawString(String, Font, Brush, PointF)). If you want to draw line-by-line y ...Show All

• Visual C++ im a beginner/ need help

  How do I delete projects and files i have done and messed up on in visual studio c++ They are located in your my documents directory under visual studio 2005\projects. All you have to do is delete the corresponding directory and it will remove the project. ...Show All

• Visual Studio Express Editions P: Update to DB with VBE & SQLE; Q: Where is the problem or what is missing?

  Pre: - WinXP En SP2; latest patches - VBE installed - SQLE installed & running on same machine Scenario: 1. Start VBE 2. Create new WinApp 3. Add new DB; complete Wizard; crated DB & DS is empty 4. Open DB; create a Table with three Columns ("idUser",int,Ident Spec = Yes,DBNull = No;"Firstname",nvarchar(50),DBNull = No;"Lastname",nvarchar(50),DBNull = No) 5. Open DS, drop created Table from DB Explorer to DS View; You should the a class alike view of the table in the DS 6. Open Form1 Design and drop detail view of DS Table to form; You should see three labels, three Textboxes and a navigation bar on to ...Show All

• SQL Server SQL Mobile Installation Problem on Device

  I have been unable to properly install SQL Mobile 2005 on my armv4i windows CE 5 device. Below is a summary of what I have found and done. Any help in resolving my issue will be appreaciated. Thanks in advance for your help. Symptoms: No errors occur during installation of SQL Mobile on the device via cab files (either deployed through VS2005 or manually copied and installed on the device) SQL Mobile 2005 appears to be installed, can see it in the device remove programs list. All 7 SQL Mobile dll files are present in the windows folder. (sqlceca30.dll, sqlcecompact30.dll, sqlceer30en.dll, sqlceme30.dll, sqlceoledb30.dll, ...Show All

• SQL Server OUTER JOIN table limit?

  I came across this statement from ASP.NET forum : "..There is a limit to the level for OUTER JOIN ANSI SQL limit is four after that you may get strange results. ..." . I did a little research but without getting clear answer from the SQL92 standard itself. I am wondering whether I can get help about this in SQL Server 2005 implementation here. I put this question in another way, How many tables can we use in OUTER JOIN(or INNER JOIN) in SQL Server 2005 Thanks. There is no limit in the ANSI SQL standard or SQL Server. In fact, the ANSI SQL standard doesn't talk about such limits anywhere. The ...Show All

• .NET Development wat is webservice

  what is webservice and how it will be use in real time scenario's wat are the main differences b/w webservice/remoting/windows services   SreenivasRao.K wrote: what is webservice and how it will be use in real time scenario's wat are the main differences b/w webservice/remoting/windows services a "windows service" is a program that runs on windows in the background and does not automaticaly have any way for a remote computer to connect with it. you can add network access to a windows service if you want. for example IIS is a windows service that provides www servers to windows machines. a "We ...Show All

• Windows Forms Error when installing prerequisite .NET FW 2.0

  Hi, I get an error when I try to install my ClickOnce application on a machine that doesn't have .NET Framework 2.0 installed. I have set my clickonce application to install the prerequistes from the vendor's website (Microsoft in this case). The downloading and installation of the .NET FW 2.0 seem to go fine but my problem occurs when the installation tries to "go back" to my project installation and tries to continue with my 'ClientApp.application' file. The error message I receive is this: The following error occurred attempting to install 'C:\Documents and Settings\thoand\Local Settings\Temporary Internet Files\Content.IE ...Show All

• Visual FoxPro need foxpro help

  I'm getting a System Error "Divide by Zero or Overflow Error" when I try to run FoxProw.exe on Windows 2000 .  The program installs okay, but I can't get it running.  Thanks in advance for your help ... Try the IPatchFP.exe ( http://download.microsoft.com/download/fox26win/patch6/1/w9x/en-us/ipatchfp.exe ) instead. This works for international versions as well as reportedly FPW 2.5, 2.5b, and 2.6. Rick ...Show All

• SQL Server Business Intelligence in SQL Express?

  Hello, I have spent about half an hour looking for an answer to this, so apologies if I have missed it. Can you get Business Intelligence Development Studio together with SQL Server 2005 both in Express editions There was mention of an Express toolkit which includes BIDS but it seemed to imply you couldn't combine it with SQL Server Express. If not, what is the cheapest way for an individual to get Business Intelligence Development Studio My evaluation edition is about to run out. Thanks, ...Show All

• .NET Development Validate XML with XSD doesn't seem to work

  Hi All, I have an XML-file that I want validated against an XSD file. To check if my code works I deliberately made an error in the XML file. But somehow the ValidationEventHandler is never called.. What am I missing Public sub checkMPXMLFile(ByVal strMPXMLFileName as string)    Dim fsXML As New FileStream(strXMLFileName, FileMode.OpenOrCreate, FileAccess.Read, FileShare.Read)    Dim fsXSD As New FileStream(getXSDPath() + getXSDFileName(), FileMode.OpenOrCreate, FileAccess.Read, FileShare.Read)    Dim reader As XmlReader = XmlReader.Create(fsXML)    Dim schema As XmlSchema = XmlSc ...Show All

• SQL Server How can default schema change in stored procedure ?

  Hello, How can default schema change in stored procedure For Example: There are two user 'User1', 'User2' in TestDb Database. These users default schema is same name, like 'User1's default schema is 'User1', and 'User2's default schme is 'User2'. And each users have 'Table1' table, like [User1].[Table1], [User2].[Table1] In this enviroment, query 'SELECT * FROM [Table1]' refer default schema of execute user. like 'User1' execute 'SELECT * FROM [User1].[Table1]'. But if dbo create a stored procedure below, default schema doesn't work. CREATE PROCEDURE SelectTable1 AS SET NOCOUNT ON SELECT * FROM Table1 GO When User1/Us ...Show All

• Architecture A good first book about .net architecture

  Hello gurus! I am a computer engineer (a Spanish five years degree) and a MCAD.net professional. I know about general architecture but not architecture in .net world. I want you to tell me a good first book about architecture under .net (net 2.0 ), develop real scalable applications, n-tiers, etc etc. Thanks. This looks good - Pro Scalable .NET 2.0 Application Designs , though I don't own it, I have browsed it in the bookstore and it is next on my list. If you understand architecture, and you need a good guide for using the the .Net mechanisms that will build your system: Lowy's Programming .NET Components, Second Editio ...Show All