Orion here onec again...
can u plze help me 2 solve this error
ORA-01810: format code appears twice
update MF_QA set OFFR_DUE_DT = to_date (to_char(OFFR_DUE_DT,'MM/DD/YYYY')||(substr(OF...
hi,
I am executing the sqlloader through forms with host built in, the sqlloader loads up to 50000 records in to various tables. this takes some time to do.
when i execute this form s...
I am getting an error that I need to prevent, in an ASP Web Application that I am writting.
I get it when I save an ADO2.8 RecordSet (From SQL7) to an XML DOMDocument40 using adPersistXML
...
I am trying to import a comma delimited file (.CSV) into our SQL Server 2005 Database. I am trying to use BULK INSERT. The CSV file is a FEDEX report. It has fields such as "Mon, May 1, 2008"....
I am using Ms Access database, I have a query which gets the month and year of the date. to do so I use
Format([Date],"mm") AS [Month], Format([Date],"yyyy") AS [Year]
where date is the da...
Hi,
I'm looking for the MS foodmart db for OLAP. I've heard it is for Access but would like to use it in SQL Server. Where can I find a copy of the foodmart sample db? Is it part of any ...
Hello experts
I am using Oracle9i.
Need SQL statement to get number or rows affected by previous Select/Insert/Update/Delete query.
Thx.
Hi all,
I have Office 2003 installed on Desktop. When I try to open an access file, which is on the server, I get message "Security Warning: Unsafe expressions are not blocked " but i ca...
I have created a linked server to our AS400. Some tables come through fine, others have the data all mangled, appearing like 0x404040404040404040F4F0F4 when the value should be 404.
When I ...
I am running this code in MSAccess 2003 Professional. but I keep getting the following error : Provider cannot be found. It may not be properly installed.
Dim con1 As ADODB.Connection
Dim ...
Hi,
I have a table called EMPLOYEE like this ...
ENO(number) EName(varchar) USRID(number) OwnerList
---------------------------------------------------------------...
I need to get a PDF print-out of an entity relationship diagram created with ERwin (now published by Computer Associates). The file extension is .er1
I do not own a copy of ERwin, and don't...
Hello there,
I wanted a er diagram software where it can draw er diagra for my already build oracle db model.but i dont know what do you enter in the dbms connection box which appears whe...
How can I create a database in SQL Server 2000 and 2005 with character set UTF - 8 . Can someone please post sql script that I execute in Query Analyzer to create such database.
Thanks.
I'm trying to write data to excel from Oracle Form.
Everytjing works fine if I specify parameter DDE.APP_MODE_NORMAL or DDE.APP_MODE_MAXIMIZED.
For DDE.APP_MODE_MINIMIZED I'm getting erro...
Dental office has all new hardware and new cabling for a 12-workstation client/server network. Workstations use Pentium D 3.0ghz processors with 1-gig DDR2 RAM, and the server is a quad core X...
I am using Crystal Reports 10 with a Windows Visual C++ application.
We use and odbc connection to access the database.
The database we are using now is SQL Server 2000.
I have downloaded ...
Hi,
I hope someone here can answer my questions because I don't find the info I need on Internet.
First, is there a better way to automate the creation of an ODBC other than a logon scrip...
I need to move the ACT version 8.0 database .ADF and ALF files from one server to anther.
Only 2 users having access to the files. I made sure both of them are not using it.
I keep hav...
Is there any tool in this world that can convert T-SQL code(SQL Server) to PL-SQL(Oracle Code)?
I want to connect to a Informix database through ODBC. Pl. tell me from where I can download Informix ODBC drivers (for Windows XP)
I want to download 'IBM INFORMIX 3.82 32 BIT' driver
Th...
Hello experts,
i want to know which of codd's 12 rules is not satsified by oracle 8, 8i and sqlserver .
Is there any RDBMS that satisfy all the rules threotically or practically.
please an...
I am new to Toad and need help in understanding basic navigation,features and capabilities.
hi
i have sql developer on my machine...can i view all the schemeas that are there on the database?
thanks
In 9i, when I used dbms_metadata.get_ddl package to get a view's DDL. but in SQLPLUS, there many lines were broken. I have to re-format the scripts in my editor, which is really a tedious job....
