Hi all,
A question,
when i precompile my .pc file it generates .c file successfully with this line
extern sqlcxt (/*_ void **, unsigned long *,
struct sqlexd *, struct sqlcxp * _*/);
It...
I get this message:
Server: Msg 7391, Level 16, State 1, Line 9
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[O...
Hope someone can help.
We have been using CA-SuperDB version 2.2 for DOS since 1990. We have now upgraded our PC to XP and require a way to convert our data into a more recent Windows applica...
Hey everyone,
I need a step by step procedure for mounting tnsnames.ora.
I am running Win 2000 and Oracle 8i personal edition.
I try logging on through sql plus using
scott/tiger
...
Hi again,
I have another client who is ready to move to a new ISP for their Web hosting for various reasons. I am to choose an ISP for them based on their current and future needs, which ar...
how can I select the ¦ character from oracle?
select
'¦' or chr(166) or '''¦'''
from dual;
doesn't work it always results in selecting the character ¿
Hi im a programmer and im doing a stupid technical report for my company and im looking for a site online which has done a proper database comparison on the following databases:
* Sql Serv...
Hi
I am working on a conversion of an existing application where we use MSAccess as both frontend and back end. We have forms and reports in Access. Since the size has grown big we are mig...
Hi
I need to do a running difference instead of a sum. I have a continuous form set up and want to get the difference of the numbers instead of the sum. I am using the SUM function but there...
How to select the SECOND highest value from a field ?
Example :
Table staff consists of salary , and staff_id fields . how to select the second highest value of the salary ?
Can we write Database level triggers in SQL SERVER 2000 like we can in Oracle
i.e trigger on the database (not a particular table)
Requirement - database has more than 500 tables. whenever...
I have an Oracle DB used by only a handful of people. I am the only developer/maintainer, etc. In case I get hit by a bus, I want to have a nice schema diagram for my replacement to use. Go...
Hello.
On an MS Access form, is it possible to make a checkbox bigger?
I have tried adjusting the properties and using some code like below. This can make is smaller, but not bigger. I...
I've 'inherited' an LDAP issue.
I need to make some additions to certain schema in this existing LDAP.
Basically, it's something like this:
for all "ou=People", add the "nsAccountLock" at...
I am using Developer 6i
I want That all icons be in a specified folder,and specify only icon name in
button Icon Filename Property.what should be done pls suggest.
I have been studying this for ages and my mind has just become a mess...But here goes
I want to create a database in access 2000. The database will store details of customers, employees, veh...
Using ADO, after fetching all rows from an Access table to a recordset, I try to use Find
to select the relevant records and get the above error. The statement that produces the error is:
r...
I have created one sp_delete strored procedure...if i pass deptid in that department should deleted...It works fine...But i want to pass this value at query analyser in sql server to test at b...
Hi
I am trying to execute the query for rownum() in DB2 7.2 on OS390.
The query is
" select TEMP_ID, rownumber() OVER(order by TEMP_ID) as ROWNUM from TAB_NAME "
the function rownum() is ...
I am in the process of designing a database that will house a great deal of existing information. I have been asked to estimate/predict the size of the database and nomatter how hard I look, ...
Hi!
I have read the advert, I have almost all the quallifications but they say applicant must have a knowledge of project-related software, such as Epilnfo.
can you help me out, can i le...
Can I format a column of data that is all Caps (e.g MICROSOFT EXCEL ) to Mixed, First letter Upper Case and the rest Lower Case....eg MICROSOFT EXCEL to Micosoft Excel.
I have two servers one is running oracle 7.3 and another running oracle 8.0. Now I would like to create the full dump of the version 8.0 database using EXP73 (OF VERSION 7.3). Whwn i tried cre...
Is there any utility, third party software or anything that can open any kind of databases?
Quite simply, I have an external application that needs data from my database. This is on a Unix box. It's only interface is through a socket connection. The application is for displaying e...
