Forum Replies Created

Viewing 15 posts - 661 through 675 (of 3,366 total)

  • RE: Dynamic Connection String Failing in report server

    sumit-679660 (12/17/2009)


    Nevermind the 100 servers. I am truly not concerned about how many servers can the code connect.

    If it works for one, it will work for rest.

    The key issue for...

    Kind regards,
    Gift Peddie

  • RE: Dynamic Connection String Failing in report server

    sumit-679660 (12/17/2009)


    Attached is the code.

    Thanks.

    You have attached RDL post the connection object code for the Report that is connecting to 100 servers that you have deployed in production.

    Kind regards,
    Gift Peddie

  • RE: Dynamic Connection String Failing in report server

    So why are my needs not "Valid". All I need is to deploy the report which is already working in preview.

    Also, this is not being used for any "Bad thing"...

    Kind regards,
    Gift Peddie

  • RE: Dynamic Connection String Failing in report server

    (="Data Source=" &Parameters!ServerName.Value & ";initial Catalog=master")

    If the above code run then Microsoft is doing something wrong but it did not run so you need to find out what is a...

    Kind regards,
    Gift Peddie

  • RE: Upgrading my certs

    Basically, my initial question stemmed from that the MCAD requirements also fulfilled elective requirements for the MCDBA (or was it the other way around?). Now that SQL certs have upgraded...

    Kind regards,
    Gift Peddie

  • RE: VS2005 versus VS2008??

    VS2008 comes with Targeting that lets you develop for all existing framework versions, for example you cannot install VS2008 in Windows 2000 but VS2008 can be used to develop application...

    Kind regards,
    Gift Peddie

  • RE: SQL 2000 x86 on Windows 2003 x64

    Well, despite my recommendations to either downgrade Windows to 32bit or upgrade SQL to 64bit, they see no need to change the current setup.

    I googled already a lot, but I...

    Kind regards,
    Gift Peddie

  • RE: Upgrading my certs

    Ray K (12/15/2009)


    http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab1

    Maybe I should try poking around Microsoft's site a bit more! 🙂

    Nevertheless, your thoughts are still welcome!

    Ray,

    I have MCITP BI and DBA SQL Server 2005 which is upgrade...

    Kind regards,
    Gift Peddie

  • RE: ETL process SSIS or VB.Net

    gnewkirk (12/15/2009)


    You are correct. What I am trying to ascertain are people's point of view on whether to use SSIS or develop their own code from .Net Framework for...

    Kind regards,
    Gift Peddie

  • RE: PowerPivot

    I'm hoping it will work quite well for us as the biggest consumers for this information is the accounts department and you know how accountants love excel...

    I am not sure...

    Kind regards,
    Gift Peddie

  • RE: SSMA: Data Migration from Oracle to SQL 2008 slow

    Dietmar Krause (12/14/2009)


    Hi,

    we are trying to migrate a database from an machine running Oracle 9i (on Windows Advanced Server 2000) to a SQL Server 2008 SP1 64bit (on Windows 2008,...

    Kind regards,
    Gift Peddie

  • RE: Emailing textfiles in SSIS

    sqlserver12345 (12/14/2009)


    My SSIS package extracts data from the database and dumps it into a textfile with timestamps.There is job which runs this SSIS package every hour.I have to mail each...

    Kind regards,
    Gift Peddie

  • RE: SQL Server 2005, 2008 and VS 2008

    Lowell (12/13/2009)


    Gift Peddie (12/13/2009)


    I installed VS2008, SQL Server 2005 and SQL Server 2008 now Windows 7 complain about VS2005 not compatible but I ignored that. If try all programs...

    Kind regards,
    Gift Peddie

  • RE: SQL Server 2005, 2008 and VS 2008

    Positive (12/13/2009)


    Thanks for the reply.

    I am unable to open SQL Server 2005 database in Start -> Programs. I am thinking of uninstalling SQL Server 2008, VS 2008, SQL Server...

    Kind regards,
    Gift Peddie

  • RE: What connection manager should I use for Access ?

    becklery (12/12/2009)Hi.

    Please refer to the url below:

    http://smallvoid.com/article/winnt-services-rasman.html

    http://www.ehow.com/about_5052180_remote-access-connection-manager.html

    I wish these would be helpful.

    Regards,

    becklery.

    You need to stop the person is talking about what is technically a data driver to connect to Access...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 661 through 675 (of 3,366 total)