Answer Questions

• Kyuuketsuki Javascript Error When trying url access

  Hi, i have a problem with the rs 2005, using url access to call a report: --------------------------- Error --------------------------- Error: 'RSClientController' is undefined Calling a report from the reportmanager works. The rs2005 runs on a machine with a parallel installed rs2000. I configured the virtual directory to machinename/reports2005 & machinename/reportserver2005. When i debug the clientscript i see that he reque ...Show All

• blankmonkey Vis. Studio.Net 2K3 + BI Reports

  Hi All, Having a problem installing the BI side of things into Visual Studio. I've installed it onto my laptop fine, but trying to get the BI reports to install on my desktop is turning into a nightmare. I've made sure all the Pre-Req's are there, .NET Framework, Local IIS, etc, but what ever I do, I cant get the BI reports to appear, even with doing an uninstall and full install. Does anyone have any suggestions Cheers Steve ...Show All

• Helder Magalhaes Can't connect with Visual Web Developer Express

  When attempting to use VWD Express' built-in web server I recieve the following error in browser window: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I've done the following: ...Show All

• Ravenet SQL DTS

  Background..... I have Front End VB6, and Back End Access... Access is mainly a Data Dump...a bunch of tables and data...NO queries, forms etc in Access...just Data and indexes My Question is.... Is the DTS Import Feature supposed to convert Access(including Indexes, Primary Indexs) into SQL Server B/c as far as i can it is doesnt do that If so where in SQL Server should I be looking b/c i must be blind. Second, i am getting this error ...Show All

• gaums I want make table 4 like this one in SQL server 2005

  I Have 3 table Like this: Table 1: Name = Tbl_Mian_code M_Code Master_Code Master_Name Main_Type Main_Gruop Main_Txt 1001 1001 Bank 01 01 1002 1002 Cash 01 02 1003 1003 Good's 02 01 Table 2: Name = Tbl_Mian_code Id_2 Main_Code Sub_Code Master_Code Master_Name Sub_Txt 1 1001 0001 1001 0001 Bank_Visa ...Show All

• Kerry Reynolds Problem in browsing cube and dimension data

  I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display "Unspecified error unable to browes the data" So please solve my problem and what can i do Known problem, see ...Show All

• Tom Albrecht Looping through rows in flat file

  I'd appreciate some guidance on how to solve a problem. I have a flat file of the format Header1 Header2 Header3 Data Record Data Record ... etc. ... Data Record Trailer1 Trailer2 I want to loop through each data record. I want to take a column value (string) from each row, and call a stored procedure passing in that value. The s/p will return another string which I want to use to update the original column value from the flat file. If I can't u ...Show All

• Jeff Drummond SMO / SqlBackup() - Unable to connect to SQLEXPRESS instance

  I am using the following code in an attempt to backup a SQL 05 Express datbase that resides in the local machine instance (SQLEXPRESS). I keep getting a "Unable to connect" error that prevents the backup from running. Any suggestions and or fedback would be greatly appreciated. try { Server server = new Server(Environment.MachineName); BackupDeviceItem bdi = new BackupDeviceItem(@"C:\test. ...Show All

• muysal joins

  Hi Friends I need ur advise on this one. when writing sql statements and whenever there is need to join 2 or more tables am used to the following syntax (using WHERE to join tables) select a.name,b.code from table a,table b where a.code=b.code as you all know we can also use INNER JOINS,OUTER JOINS etc., to join tables and all BOL help example contains this type of syntax. my question is , am having difficulty using/writing this syntax in my que ...Show All

• kiwipiet Subreport's header/footer

  Hi! My report has a subreport, and I noticed that I don't see the header/footer of it. Is it rigth Is there anyway to show a subreport header/footer Thank you! Subreport header/footer items are always ignored. The main report's header/footer will be shown. -- Robert ...Show All

• Ajakati MDF File with 40MB without any Data

  Hi there, I'm using a DataBase for tests, but now that it's completed and I erased all it's contents, I verify that the mdf file of the database have 40 MB, but I don't have any data on it. It's that because whene the database grow's, then never comes dow to a small size I whant upload the database to the server, but 40 MB ... :S  There is any way to just copy the definition, stored proc., views, etc to a "clean" ...Show All

• kismath SQL Server mobile installation

  What is the version number for the SQL Server mobile edition that is shipped with the RTM release of VS 2005 Where exactly can i find the installation for it (either within the VS 2005 installation folder or independently on any site) The VS 2005 RTM that i download only consist of "sqlmobile30devtoolsenu" in the following location : - dvd1\vs\wcu\SQLCE I could not find the installation for SQL Server mobile. However, the readme files say that ...Show All

• Stuart Ray Strange Deadlock issue

  Hi,    Before posting this thread, I have searched for answer in this forum.    But this case is a little bit different from the others.        In our application, we encounter deadlock on a single table.    Env: SQLServer 2000, SP4, ReadCommitted    One thread is trying to do this update sql:    "update resources_allocate set FromDate= , RepFromDate= , Res ...Show All

• Mike-T Problem creating SQL Server Mobile Subscription

    Hi there When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process: Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect. HRESULT 0x80004005 (29061)   An ...Show All

• Ben Chambers Unable to Install SQL Server 2005 after BETA

  I have completed the uninstallation instructions for my beta versions of SQLExpress (repeatedly). I have used the manual unistall procedures also. I have physically removed the SqlServer directory from the the Program Files directory. The result is the same. This message appears every time I try to to install the MS SQL Advanced package: "SQL Server 2005 setup has detected incompatible components from beta versions of Visual Studio, Net ...Show All