hi, I am done with the connection to ORACLE without installing full oracle client. Only installig the instant client will do. But the connection is through ODBC. I want to connect to ORACLE through OLEDB connection. I have downloaded ODAC101040.exe from ORACLE site. But its not installing. Can an...

Hai, Am Tamilvanan. Am a New to Access. In my Access Application i need to Send and Receive Email with Attachment. But i have the Problem in Attachment.I need the attachment function is work as follows. Need one Browse Button. If we click that Browse Button, the file open Dialog Box will be open, th...

Hi,I using Oracle Instant Client 10.2.0.2 with Instant ODBC 10.2.0.2 to build application with MS VC++ 7.1 and run gives duringResultset->MoveNext();exception while trying to move cursor to invalid row (EOT looks to be failing).--Eine Ausnahme (erste Chance) bei 0x7c812a5b in app.exe: Microsoft C...

HII have developped a system with msAccess. However, i now have to put it on an company's WAN and allow multi-user access. I have experienced that the db is not allowing multi-user environment.I am not versed in this area. Could u inform me better concerning ms access on a network and if it wil...

hi.. Plz i need this urgently for my job. This query is already aliased and it stills gives the error:Every derived table must have its own aliasSELECT num, nome FROM (SELECT 0 as num, tema as nome FROM pesquisa AS t1)LEFT JOIN(SELECT COUNT(id) as num, tema as nome FROM pesquisa WHERE (YEAR(ano_defe...

I wanted to make a simple little utility for my brother so he didn't have to use excel for a couple things. Creating a table and a couple forms and reports in access took all of about 15 minutes. But then I realized I never created a standalone access app and after looking into it I would hav...

I am using SSMSE to create my database and sprocs. I am use to Enterprise Manager. When I created a new sproc I received a template with a lot more code then I am use to with EM. I've tried to modify it with my sproc but I continue to get errors when I try to execute it. The errors come from th...

Hello All,I have a problem on how to retrieve records from a database using SQL query. It is a little bit complicated query. I do not know what SQL query experission is correct.In the database table, there are four fields "ClassID", "Personal Nmae", "Age", "Score". The following is an example for i...

hi all,<br/>is there a way to query the last entered record in a table?<br/>thanks

Hi all!<br/>Please, help me. Tell me about "auto insert data from a database to other database".<br/>Thanks Very much.<br/>Jimmy Huynh

hi folks ,I have created a report using sql server 2005 RS.Ive deployed it in the server(localhost).In the subscription section of the report manager ive mentioned a emailid to whom ive to send that particular report.Ive selected the report server email delivery method from the dropdown list in the...

I am doing a website which many users might hit at the same time.I am using a stored procedure which creates temporary tables,fills it with data and after using it, deletes it.As many users will operate in the website,many instance of the stored procedure might be running at the same time.What about...

I have a fairly large XML file (about 10,000 elements each with 5 sub elements). I would like to transfer this as a single parameter to a stored proceedure. Within the stored procedure I would like to be able to treat this data as if it was a table (or load it into a table variable).I have done this...

Visual Basic 2005 How do I go about adding a column to an SQL database. Everytime I did it in the past it was a disaster and I literally had to start all over again from square one. I would go into Dataset Designer to add the column then I would have all kinds of problems with the form that displays...

I have SQL Server Express Edition installed and working properlyI wanted DTS ( or whatever 2005 calls it) to import some MDB databases into SQL Server 2005 or Express (it doesn't really matter)So I load up my SQL server 2005 Developer Edition ie, the full version, wait about 1 hour for it to in...

The following will load into a SQL (2005) table perfectly:<ValidateData><Validate Type="Countries" Name="CountryCode" Value="JA" Test="Not Exists"/><Validate Type="Countries" Name="CountryCode" Value="BO1" Test="Exists"/></ValidateData>But my XML is of the form<Valid...

Hi All,In SQLServer 2000 there are local packages. I need to write a script that will enumerate the local Packages store and return me the name of each DTS. I thought I could use LoadFromSQLServer but that only appears useful if you know the package name.Any ideas?Thanks....

Hi,I have a basic insert statement like this,INSERT INTO TRANS ( pin , date , time , type , amount , descr , userid ) VALUES ( '111111' , '20070425' , '230904' , '1' , 3100 , '' , 'TEST' ) The table structure of TRANS is CREATE TABLE [dbo]...

hihi,i would like to know in wat format to input data in a hyperlinked datatype fields in ms access. i try:1><a href=" http://www.somethinf.com">view</a>2>#<c.test.doc>#view am calling from an asp page,but its not dispalying properlyhelpquikthanks...

I have recently been charged with the task of refreshing an oracle database. Unfortunatly I am not very experienced with oracle. This poses a rather daunting challenge. Anyway, I will try to get pointed in the right direction by any guru's willing to share their knowledge with me. The way th...

Any comments on the best way to do a multi level average like this?I'd do it like:SELECT org, avg(cnt_dep)FROM ( SELECT org, count(*) as cnt_dep FROM emp GROUP BY org, dep )GROUP BY orgAny other offerings?I've triedAVG(COUNT(*) OVER(PARTITION BY org, dep))...

SQL SERVER<br/>after deleting my test records in my table, the autonumber field is not working right anymore. the table is started not with 1 but with 22. how will i fix it in the easiest way? tnx

Hi AllI have to Schemas IN One database and each Schemas have many tablesso some table in Schemas A need to be related to tables in Schemas B.FOR EX :Emp table in Schemas A i want to relat it to Dept table in Schemas BSO When i pass this create query it gives an errormy query iscreate ta...

Aloha,I wrote a server - client app. Ca. 100 clients are connected with the server app.Every 30 Secs the clients sends some datas to the server. The server has to store the datas in a Access DB per OBDC.This is my way at the moment :I open the DB, when i start the server.m_db.OpenEx(...) Then everyt...

SQL SERVERit's so weird! my codes are working good until... my database is not updating after insert or update command. i don't know what happened but i haven't change anything in my codes. but when i run query, it works good. as far as i know, i deleted rows from my related tables. a...

SQL Edge is a universal SQL query tool that allows users to execute SQL queries, browse schema information in ER diagrams, and visualize data relationships. With SQL Edge, users can use only one query to retrieve data in a master table, and then browse data in all related detail tables. Users can al...

I am converting an Access 2000 MDB Database to SQLExpress 2005 using the SSIS Wizard.I keep getting an error as follows, even if the Table name is a different table at the "64" point - the database is in fact converted and I can use it, but I am getting this error and am just wondering why. Micros...

I am trying to backup my data in SQL 2005 SSMS and it gives me an error saying access denied.<br/> <br/>Why am I denied access to my own database?

In design mode each Field in a Table has a Field Name, Field Type, Field Length etc, and also a "Field Description" .How can I programmatically enter some data into this Field Description and update the Database Table Definitions with the changesI am running SQLExpress 2005Thanks for any ideas...

This query is being executed programatically through ADO on an Access 2000 database. When I execute the query in Access itself, it works as it should. When I execute it through my code, I get a syntax error.CREATE TABLE UsageLog(MNum INTEGER, ReadDate DATE, Reading LONG, Usage LONG)I'm using...

i need to convert my SQL database (on MS SQL 2000) structure to a XML scheme file...<br/>how to do it??<br/>Thanks in Adv..<br/>Cheers..<br/>Venu

hi, I am working on a project in which we have two applications. Both the applications talking with the database server. My requirement is when enver i make a new entry through one application that will be updated in the database and I need something in trigger or something which will call a pro...

Hi, I'm having some trouble with my asp.net page and my sql database. What I'm trying to do is allow the user to upload an number to the database, the number is a money amount like 2.00 (2.00) or 20.00(20.00). I've tried using money and smallmoney datatypes but the numbers usually...

I am using SQL Server 2000.I have a table together with data.Does anyone have idea in getting know the table space together with the data?I can't find it from properties and help..

in sql2000: is this correct?. like to make name as null if games is null:<br/>select firstname, lastname, games, scores, case when (games = null ) then firstname = null end case from playerstable, gamestable,scorestables

I am trying to create a stored procedure and the store it in my databaseI have SQL Server 2005 Express and I am trying to do this by manually using the keyboard and typing in the information, having first done --1) Right Click on Stored Procedures2) Select NEW Procedure3) A Window shows with a Proc...

Using SQL Server 2005 (or Express), what is the standard method of defining a Memo Field (ie, a field which can have unlimited Text stored in it)I thought it was -MemoDetails (nvarchar(max),null)But this is giving error in a database tool I am usingIs there another way to define this type of field ?...

Hi All, I have a table in the database which I use for logging user activity (Database is MySQL 5.0.37, I can upgrade to higher version if needed). I have made a stored-procedure that inserts new row for a user activity. The new functionality I want to add to the stored procedure is ...a. Th...

First, I may state my problem.I am using SQL Server 2005, and participating the 07 kdd cup project.I have a table named VoteScore(UserId int, MovieId int, Score int, Date datetime) which involves over 100 million records in this table. Now I want to add a new column RateIndex, which numbers from 1...

I ran the code below that adds a column to an SQL table.I refreshed Data Sources, but, the new column does not appear.I refreshed Server Explorer and the new column does not appear.I tried running the code again and I got:"Column names in each table must be unique. Column name 'CaseNbr' in...

I'm sure this is really simple, but I can't get it right. I want to populate a DataGrid on my Window with a DataSet from SQL2005. Everything works, I've done it many times before. What I am stuck on, in this issue I want to hide the identity column. I let the programmer decide the nam...

Hi I need a special help with SQL query - accumulative summary on table which is already grouped:id date count1 1/1/2007 452 1/1/2007 123 1/2/2007 134 1/2/2007 255 1/3/2007 24I need accumulative summary per days. Now I use this:SELECT date, sum(count), ( SELECT...

Hi:<br/>In Sql2005, is it possible to perform a wildcard search on an encrypted column?<br/>Many thanks!

I have a table in which items are constantly added with a date and time indicator, but I need to retrieve from it only the last 100 items added.<br/>Any help will be greatly appreciated, thanks!

Hi, I am using SQL Sever 2005 & C#.I met a big problem when accessing the database.My data table has over 100 Million records, and I have created indexes for several columns which are frequently used. But I constantlyget a SQLTimeOutException, even if I set the connection time out as high as 200 sec...

Hello,<br/>i have a datetime like this: "10/5/2007 11:50:37"<br/>I want only to get with sql the date part "10/05/2007" from the datetime string.<br/>How must the sql query look like?<br/>I am using MS Access <br/>Thx for help

While using below SQL statment in 'SQL Query Analyser' i dont get the compelete XML in the result... (there is no columns of type 'Memo' or any long fields more than 1K characters)Problem i'm facing is:1. there are 6 rows in the table, but i'll get only first row in XML...

Dear All, I have been trying to connect to mysql through the command prompt this code below but i can't...I got this error instead that pops up :an error occured:java.sql.SQLException: column index out of range, 2>1Is there something wrong somewhere with the code...? please help...I am using...

I have been reading MSDN trying to figure out what size I need to make my data type in SQL 2005 to hold my SHA512 hash. It's a password hash but I don't think that matters because as far as I understand reguardless of the amount of data put into a SHA512 hash the output is guranteed to alw...

Does anyone know of the procedure, steps that need to be followed to allow installing SQL 2005 Express from a network? Since SQL 2005 express requires .NET 2 and the MSI engine 3.1 and MDAC 2.8 it is a real problem pushing it from a network such as active directory using an AIP (Administrator Instal...