Answer Questions

• Patri Opening a Link in a new window.

  Hi I'm would to link from a report to a second report, I would like the second report to open a new window. I can open the new window with the samples I found in the Forum (javscript windo open'www.microsoft.com','_Blank'), when I try using the actual report and parameters it does not work, here is what I code in the link (fx) = void(window.open('Globals!ReportServerUrl' /Dirxx/Report1&JParmname=" & Fields!LinkID.V ...Show All

• vinaymishra RDA SQL MOBILE ERROR 28037 HResult = -2147012867

  I am modifying the aplication to visual.net from visual studio 2005 but I have problems ( in this moment i working in my pc , with sql 2000 personal ,windows xp , sql mobile and pc pocket emulator for window ce 5.0) I don't know but i can't make the Pull in the server. 1) the http://localhost/driver2005/sqlcesa30.dll diag is correct 2) I don't have the windows firewall 3)the anonimous user have all the permition in the virtual direct ...Show All

• ppawlo About Login Account

  Hi everyone, I have a simple question for you which is too important for me. My question is about logins in my own(local) server. I know that my local server(my computer's server) has to default login account which are called sa and BUILTIN/ADMINISTRATOR. While I am using my own server, I do not know which default login account is used by my Server since I use windows authentication while connecting to the Server. Another question is that while ...Show All

• 69er Data types in SQL Server

  Hi, Can someone please tell me what are all the data types in MS SQL Server 2005 Express used for I have only used Access before and the data types in Access are - DATA TYPE    INFORMATION STORED Autonumber - A number that is assigned automatically and never changes thereafter. Currency   - Amount in the currency format chosen. Date/Time  - Date and Time. The Format property chosen on the general tab to dat ...Show All

• camilletrapp Answer: My First Report

  I need to create a report for a phone directory. Basically my report needs this format. department        employee        employee        and so on..... department        employee        employee        and so on..... department My data is stored in two tables department - deptID deptName Main - deptID empName title order by ...Show All

• eldelo unable to use existing sql logins

  Hi friends i have sql 2000 db which i attached to our sql server 2005.the problem all sql logins i've for this db are there but i cant login using any of those logins. i tried to delete them as i wanted recreate them but get following error. any idea how to reactivate those logins.Thanks for your help TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for User 'Damia'. (Microsoft.SqlServer.Smo) ...Show All

• jerome c VB.NET 2003 STD WITH SQL SERVER EXPRESS

  I have installed Sql Server 2005 express and Visual Basic. Net 2003 standard edition. How do I connect to Sql Server 2005 express from Visual Basic. Net 2003 standard edition I tried to use sqlnative client to connect, but it gave an error message saying this is not supported in this version of Visual studio. Looking for an answer ... thanks. Interesting, can you use the OLEDB Commands for the ...Show All

• paulorib OLEDB question

  This may be a newbie question but here it goes.  I have SQL Server 2000 running on a windows server 2003 machine.  When i have my database local, on MSDE everything is fine.  But when i switch my code to move to the server, (after i've attached the database within the server) it tells me that server either does not exist or login failed.  Now here is my connection statement OleDbConnection m_conn; string connectionStrin ...Show All

• streetworm Merge replication failing after recreating the publication

  I am having a problem with merge replication after recreating a publication. It is a simple two-way replication between two servers allowing applications to update data at both ends, i.e. 1 publisher, 1 subscriber for all tables except some junk ones. The problem started after I did the following: 1) I dropped and recreated the publication to allow for some changes to the database schema. These caused problems so I dropped the subscription an ...Show All

• Montana16 Error using Datareader Destination

  Hi guys, I'm in dire straits here - really hoping someone can help me. I'm using a datareader destination and consuming it in a C# app. When I fire ExecuteReader on my DTSCommand object to return some data I get the error: "Could not obtain a datareader object from the specified data flow component" So we don't have a clue why this isn't working. Although...I'm intrigued by the line about "specified data-flow component". In the C# app you d ...Show All

• trustfundbaby ODBC connection failing on 64 version of Windows 2003 server

  I have an application that talks to a SQL backend using an ODBC DSN connection. It works fine when running on a 32bit machine but fails in the 64bit environment. The DSN is setup properly on the 64bit box and the Test Connection returns sucess. However when my application tries to use the DSN to connect to the database I recieve the following error. IM002 - Data source name not found and no default driver specified. The data source nam ...Show All

• Rodrigo Chagas How to search all columns in a table at once?

  This is a true newbie question. I want to search an entire table for a string. Is there a way to do the equivalent of: SELECT * from <db.table> WHERE(*) LIKE '%<some string>%' The WHERE(*) is my attempt to say search all columns. That's apparently not legal in SQL so my question is whether there is a legal way to do it without have to spell out the names of all the columns. This is sort of equivalent to doing a Find on a string in a ...Show All

• Coeamyd Login failed for user ''. Reason: Not associated with a trusted SQL Server connection

  Hello, here we have 2 developers, one developer has sql 2005 in his machine, the connection string has Integrated Security=SSPI, that developer can connect to the application, the other user gets that error when he tries to execute the application froms its own IIS. The sql server has windows authentication, I want that the application uses one account, I tried to create one account, and give db_owner to it on the database, then I changed the ...Show All

• Billy Sells Replication error with sqlserver mobile:A request to send data to the computer running IIS is failed, see Hrresult"

  I have smilar kind of an issue with replication. I had sucessfully done replication with Sqlce2.0 on sql server 2000. In development machine I had VS 2003, sqlce development tools. Now I use the same code done in VS 2003 into VS2005, it sucessfully converted the code. In server machine (win 2003) I installed sql server 2000, sql server 2000 service pack 4, SP4 merge replication components, sql server 2005 mobile server tools and ...Show All

• OMCPero does Sql server has command equalent to Rollback to in Oracle

  HI All does Sql server has command equalent to Rollback to in Oracle. That means when you do some update operation and i want to revertback the original record. If so what is that command. With Regards, AHARI Yes it does: BEGIN TRAN UPDATE.... <your update statement> ROLLBACK/COMMIT TRAN By the way, you should try the T-SQL forum for this sort of question: http://forums. ...Show All