Answer Questions

• skills0 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

• Jeff Waz decimal separator

  Hi Im experimenting with the reportViewer control in a .net 2.0 winform application, and I'm having a little problem: I can find no way to change the decimal separator(or the thousand separator) of a column of numbers in a table. I have tried all sorts of Format(), formatNumber() and FormatCurrency(). I've also tried to explicitly set the CurrentCulture of the application to a new cultureinfo object, and I've tried to change the culture of th ...Show All

• -Sam- Generate Scripts option in SQL 2005 Management Studio

  Did anyone even bother to test the Generate Scripts option for a database I changed the following options from their default setting: "Include Descriptive Headers" = True "Include if NOT EXISTS" = True "Script for Server Version" = SQL Server 2000 "Script Indexes" = True and scripted all Stored Procedures, Tables, User-defined functions, and Views Problems: 1.  Generates IF NOT EXISTS (SELECT * FROM sys.objects ... should be ...S ...Show All

• GlennGraham Cannot print landscape

  In Report Manager in SSRS 2005, no matter what printer I go to, there is no landscape option. It's not the driver, unless the driver for the printer isn't like SSRS because I can print landscape on any of these pritnters in any other application. Why is that I do not see an option to switch to landscape period after looking at my printer properties afer clicking the print button from SSRS From what I understand it is not the printer you ...Show All

• erdsah88 SQL Mobile 2005 Merge Replication with SQL 2005 x64

  I am having trouble with getting Merge Replication up with a new SQL 2005 x64 Server.  I already have it running smoothly with SQL 2005 Mobile and SQL 2000, but I want to migrate the backend to SQL 2005. There is a front end server running IIS 6.0 on Windows 2003 x86 Standard (Server A) with SSL required and Basic Authentication set as the only authentication method (default Domain and Realm are also set).  The backend server is&nbs ...Show All

• paritosh how to colum the page?

  Good day! can any one help me how to colum the page example i have three colums in the page if the data exceed in the first colum it wil go to the second colum then 3rd colum. Can any one hlp me. Your help is greatly appreciated See this article in MSDN: http://msdn2.microsoft.com/en-us/library/ms155816.aspx ...Show All

• gdf Export the data as an XML file?

  I have two tables in my database like this. AppsTable with columns INSTANCE_NAME, VALUE. SecondTable with columns UID,SID,XID I need the xml file like below. - - where commonID  is the Value of  UID from the second table, appInstance name is the instance_name from the appstable.           If i have values like this in second table: &nbs ...Show All

• Isuru SSAS 2005 Cubes - Charting

  Hello, Does anyone know of a graphing or charting control that can be used in VS for .NET 2005 Windows Forms for graphing OLAP Cube data, besides the Office Web Component and Chart FX Preferably something that is true .NET 2005 (not COM) and can use XMLA Is there anything else out there that can be purchased at a reasonable price Thanks in advance for your help. Wendell G. Have you looked ...Show All

• Knud Grouping a query in 30 seconds

  Hi, How can I make a query and group the registries in a interval of 30 seconds...like for each line I have a datetime field that have all the day, and I need it to return just like TIME Contador_type1 Contador_type2 Total 01-01-2006 00:00:30.000 2 5 7 01-01-2006 00:01:00.000 3 7 10 It's just an example...but that ...Show All

• ArtRI Advanced SQL Generation Options in VS2005

  Hi There im not sure if im in the right place but i was wondering why the above option is greyed out when creating a new sql datasource. This occurs even when i select all fields within the table (including primary key fields) Thanks Todd I'm not exactly sure which forum would be best for you  - you could try this one ... http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=7&SiteID=1   Dona ...Show All

• Somoorthi Problem in Initialize SQL2005 Reporting Service

  I have installed SQL 2005 Standard Edition downloaded from MSDN web site and selected to install all components, install database engine on default instance and default reporting service configuration. After installation, I found that the initialization option in "Configure Report Server" page goes disabled. I checked the log and it has "INFO: Evaluation copy: 0 days left" at the end. I am sure that this server have not installed any pre-re ...Show All

• Mel8240 Adding Drop Down List in Report

  I am using Visual Studio 2005 to create a report from a OLAP cube. I am building a drop down list for user to select the desired branch. My mdx query as follow: with       member [Measures].[ParameterCaption] AS '[Company].[Branch].Currentmember.Member_Caption'       member [Measures].[ParameterValue] AS '[Company].[Branch].Currentmember.Uniquename' select      {[Measures].[P ...Show All

• JonathanKay missing notifications

  Hello, We are building a simple distributed application around the service broker where each queue is serviced from a windows service. We have a windows service running constantly as a "listener" on an event queue for each of what we call "request" queues. When a message is received by the request, the listener service instantiates a reader to process the request. As we are in development, things get out of sync at tim ...Show All

• william.c.schneider Uploading images to SQL Express

  Hi, Could someone help me on how I can store images into my SQL Table I'm using "Image" as Column Name and I use VWD 2005 Express. I saw a lot of C# examples, but not VB.NET examples. Please help !!!!! Bart Sorry Bart, I don't programm ASPX (yet). I programmed it as a Stand alone in VB.Net. Okay, I figured it out.... told you I was slow at this. If I wanted to add a desc ...Show All

• John Warner .NET2 SMO Components

    I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager. When I tries to install this program the system asks for MS Framework,net2 SMO Components. Where can I download these components Thank You Best regards Oyvind       All of the information needed to install and run Management Studio Express is at http://www.mi ...Show All