Answer Questions

• gfe The Device is not ready error when Executing package on the server

  Hi, I have a package which reads an XML file from a certain folder and parses it. I deployed my package onto the server. Copied XML files on the D:\ drive the following folder on the server. Dim reader As New Xml.XmlTextReader( "D:\Apps\Request\Clients\ClientsStatus.xml" ) is fine. But Do While (reader.Read()) generates "The Device is not ready" I think it is still trying to read it from my desktop on which I don't have a D drive. Any help is appreciated.       sql agent is running as a domain user with admin privs to the file share. The drive is mapped with explicit credentials for the same user. I ...Show All

• Okugops Two questions around Date

  Question 1: I am passing a datetime as a parameter to a Stored Procedure. The datetime may contain time, which I want to strip out - the date is the important part and it is critical that the time is 00:00. What is the most efficient way of stripping out the time so that it is 0 Question 2: I have a Year (small integer), Month (tiny integer), and Day (tiny integer). What is the most efficient way to use these to make a datetime In both questions, please assume that a universal standard must be used, since the database in question may be running outside of North America. Many thanks, Flavelle To all - thanks. I like the approach of casting the date to int (it's simple, and certainly never s ...Show All

• sheidee21 ssis will not display package

  When I try to open the designer (with exiting, e.g. tutorial or new project/package) I get the following error message: Microsoft Visual Studio is unable to load this document: Index (zero based) must be greater than or equal to zero and less than the size of the argument list I reinstalled (repair) - still not usable - I saw another post with this issue and the only recommendation was reformat and reinstall - seems drastic, looking for a less intrusive solution thanks Richard What language are you using for SSIS Something other than English, perhaps Have you always received this error, or did it just start happening Phil, English, and ssis has not worked on thi ...Show All

• axel_2005 Handling encryption at the application level

  Developing an application, which is handling encrypting for a SQL server 2005 DB at the application level, using symmetric AES encryption. After being encrypted the data is being sent to the SQL server 2005 DB to be inserted. This is what I want to accomplish. But I have one or two questions as I am going through the research for my project. Encrypting the data shouldn’t be that big a deal, but can SQL server 2005 handle to insert these data If yes how I am thinking just simple SQL INSERT statements When the data are inserted can SQL server, as it supports AES encryption, through the DBMS decrypt the data as they have been encrypted else where and then perform specific functions (by specific function I just mean any functio ...Show All

• cjreyn convert 180-day version of sql

  I need to find out what steps to take to convert the 180-day version of sql server 2005. My server has Microsoft Small Business Server 2003 Premium installed. What do you want to install instead Make sure you have the correct licences in place. Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- If you have the correct licensing and are looking for the technical answer, the trick is to use the SKUUPGRADE=1 flag during upgrade. Take a look at template.ini or Books Online for more info. Here is a forums snippet that I can't seem to find on MSDN at the moment, but it should get you started. If you have already expired with your existing version, take a look at this ...Show All

• sfabriz Cannot login using Integrated Authentication

  I can't seem to login using Integrated Authentication. I enter the user name / password and receive "You are not authorized". I messed with everything I can find and no solution. * I can browse a simple web page. * I cannot browse LocalStart.asp (get asked for User/Password) * I can set security on the reports folder to Anon and browse to Home.aspx * I have disabled the loopbackcheck. This is my dev box running Media Center 2005 w/SP2, IIS 5.1, SQL Server 2005 Any help would be appreciated. The only way that seems to work is if I change it in the Internet zone and not the Intranet zone. Changing the Intranet zone still fails. Doesn't this create a huge security hole becaus ...Show All

• Olexandr Where did the fields go?

  Using Visual Studio 2003 and an ODBC connection to an Oracle 7 database I created a dataset with the following query: SELECT ITEM, REV,QTY FROM MYDB.CONTRACT WHERE CON_NUM = 'CONTRACT_NUMBER' All is well until I change the contract_number to a parameter using either or a named parameter. Report users will choose the parameter value from a drop down list generated by another query. Although the parameterized query will still run via a prompt dialog, the report field list disappears and many errors occur. Does anyone know why this happens to the fields and how to retrieve them Thanks, PH BTW: ODBC connections seem to be the only type that will accept parameter queries to this version of Oracle. Have you ...Show All

• Marcos B Remote connection to database on same PC?

  I am running the SQL express advanced on the same PC that also hosts my Visual Basic Express application. I have user instances turned off and full-text enabled and working from within a SQL query window. However, I can not create a working connection to the database using the data source wizard from the server explorer within VB.NET. Since this is on the same PC, do I need to enable anything other than shared memory I get the error: Provider SQL Network Interfaces, error 26 Error locating server/instance. DeBug That sounds like a limitiation in the Express edition of VB. The database explorer seems to always expect the named instance SQLExpress which you now no longer have. You might need to use ...Show All

• kailuowang Difference between dates in different rows...

  Hi all, I have a table named Orders and this table has two relevant fields: CustomerId and OrderDate. I am trying to construct a query that will give me the difference, in days, between each customer's order so that the results would be something like: (using Northwind as the example) ... ALFKI 25/08/1997 03/10/1997 39 ALFKI 03/10/1997 13/10/1997 10 ALFKI 13/10/1997 15/01/1998 94 ALFKI 15/01/1998 16/03/1998 60 ALFKI 16/03/1998 09/04/1998 24 ... At the moment, I have the following query that I think is on the right track: … SELECT dbo.Orders.CustomerID, dbo.Orders.OrderDate AS LowDate, Orders_1.OrderDate AS HighDate, DATEDIFF([day], dbo.Orders.OrderDate, Orders_1.OrderDate) AS Difference FROM dbo.Or ...Show All

• Simon Bowles Datamining Viewer Client Problem

  Hello! I am running a SQL Server 2005. I created the mining models from the tutorials. I can connect with the DataminingViewerClient directly on the SQL Server(i.e. to localhost), but when i try to connect to the Server from my other computer it is not working i always get connection faild and i should check that the server is running. I can connect to the Server with other programms but the viewer is not working. Any ideas what that could be Ok i now tried to connect from Server A to Server B, not working either. It works on both when i run the viewer directly on the server and connect to localhost but not from Server A to B or vice versa or from any other computer. Could it be that some permissi ...Show All

• Patrick-SURFThru How do I Create a Temp Table as the Beginning of a Process Flow?

  Hi Folx, I am new to SQL Server and I am struggling. Versions: Microsoft SQL Server Integration Services Designer Version 9.00.1399.00 Microsoft SQL Server Management Studio 9.00.1399.00 I would like to 01. create a temp table 02. load the temp table from a flat file 03. insert into a destination table the rows from the temp table where NOT EXIST the primary key of the destination table. ISSUES: Flat File Source will not accept that a resource will be available that does not yet exist (the temp table) I set the Flat File Source to “Ignore Failure” and ran the package. It ran with warnings but did not insert the new rows. The “Ignore ...Show All

• yhong Disk activity

  We are about to go to SQL 2005 and that means getting some new Servers and i am wondering if our SAN is adequate. I like to measure over the next few weeks the amount of data that is sent to the SAN and how long its taking to come back....i.e if someone is running a large report how much data is sent and how long it takes to return. This is for 2000 SQL (i like to get all these results to build my migration plan and hardware configuration). I like to see...........18 mb of data , date time and how much read / write etc if possible the sql. Any ideas I got the following to run Disk Write Bytes /Sec Disk Read Bytes/Sec Avg Disk Bytes Read Avg Disk Bytes Write Avg. ...Show All

• Joe Hatfield Report Viewer language

  Does Reporting services supports Turkish language I am using reporting services in my asp.net project and I want to change "view report","export" buttons text to turkish words, is this possible, if possible how thanks I find something about IReportViewerMessages, I crate class library project "SampViewMessages", I add "messsages.cs" class which implements IReportViewerMessages. I create strong key GACkey.snk (c:\GACDemo\GACkey.snk) and changed AssemblyInfo.cs like [assembly: AssemblyTitle ( "" )] [assembly: AssemblyDescription ( "" )] [assembly: AssemblyConfiguration ( "" )] [assembly: AssemblyCompany ( &quo ...Show All

• TCSC Import Into Access Tables Using ODBC

  Hi, I want to import into an MDB table a csv file. I'm trying to use the bulk copy table. my function is: SQL = "SELECT * INTO [my_table] FROM [ODBC;Driver=Micrsoft text driver (*.txt; *csv) ;Dbq=c:\\;Extensions=asc,csv,tab,txt;].table.csv" db.OpenEx( "Driver=Microsoft Access Driver .mdb);DBQ=c:\\access.mdb;", CDatabase::noOdbcDialog ); db.ExecuteSQL( SQL ); when i run this function i get an error : "You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database" when i try to import in the same way a dbf file (insted the csv file) with VFP it's working well. what seems to be the problem how can i fix it or if some one kno ...Show All

• waex99 Exception : Script failed for Server '(local)' while generation Scripts on Scripter

  Hi I'm trying to generate scripts for Stored procedures as below int count = db.StoredProcedures.Count; SqlSmoObject [] smos = new SqlSmoObject [count]; for ( int i = 0; i < count; i++) { smos = db.StoredProcedures ; } SqlSmoObject[] smos = new SqlSmoObject[count]; //Generate Crates StringCollection strcol = scrp.Script(smos); writeToFile(strcol, "Create" , "SP" ); I'm getting the " Script failed for Server '(local)' " at scrp.Script(smos); Can anybody help me in this   Hi Allen I need script SPs on Remote Server, not trusted server. Can u please tell the solution for this Code will be like this ServerConnection ...Show All