Has any 1 successfully implemented a multi-user application<br/>(using SQLServer) where updates are taken place frequently<br/>and some sort of locking (row level or other) was used..<br/>Could we benefit from your lights on this by sharing a few ideas?<br/>Thanks in advance...

Hi all,I have sco unix 7.1.1 and I have oracle 8i local database.Now the real problem is all my main data are stored in Microsoft SQL server 2000 and I would like to acess the MSQL from my unix.Now I know that we can write a "c" program and establish a odc connection.I guess there are specific libra...

How do you determine if there were no matches when a recordset.find method is used.

My Access database has normal English characters and extended characters like and in a text column. When I try to sort the column, I will get something liketxtCol--A.........B......Is there some way to change the sorting sequence and make the result look liketxtCol--A...B.........Any help is much...

Hi,I am calling a stored procedure with CLOB parameter and I need to pass NULL value to CLOB paramter through ADO in VC++.My problem is when I send CLOB value as NULL a single Digit Binary value is inserted.I am using SAFEARRAY and AppendChunk mechanism to create CommandParameters for Storedprocedur...

How can i call a dll in PL/SQL(Oracle)?

how can a Progress database file be imported into sql server 2000?

Guten morgen,<br/> I would like to take a phone number 7112221111 and put<br/> it in a masked edit field (typical (711) 222 - 1111<br/> When I do maskededitbox1.text = txtfield.text<br/> I get an error... (Invalid Property value)<br/>any idea?

I have.. I can enter the info directly... It seems ok...The problem occurs when I am copying a non masked fieldinto the masked edit box... i.e the masked edit box has theformat (___) ___-____The non masked field has for input something like 7181112222Thanks...

Copying from a text field that has a phone # in it (6172221111)<br/>to a masked edit field which is set to accept the format<br/>(611) 111-1111<br/>Thanks

Hiwhen trying to connect oracle 6i to 8i on the same machine, i'm getting this error message:ORA-12224:TNS: no listeneri think i have to turn the listener on.How can i check the status of the listener?How can i turn it on?i'm running Win98.thank you...

Is there any tool for converting Visual Foxpro to Visual Basic ?:)

I am trying to deploy a student grade status system on an NT server. I have developed and tested the system on my Win 98SE workstation, and I can do the access there. But when I try to deploy the project to the NT system, the Conn.Open fails.I suspect it has to do with NT permissions, but I thoug...

I need a suggestion on what to do about the following problem.I have 13 databases. I need to add 3 tables to each of these databases. Before I have been doing this manually. But this will take alot of time. Is there anything I can do to make this process alot easier. Soon I'll have 15 different...

hi,i am desining a database that have upto 20 tables, many tables have more than 200 fileds.and there will be a huge amount of data that has to be stores there.i am using MS_Access 2000.1. l there aby problem with access becouse of huge amount of data? 2. Maximum how many rows can be stored in ms ac...

hi, i think i am in a correct forum..here is the table in question(salesperson):Name PercentOfQuota Salary-----------Abel 63 120000Baker 38 42000Jones 26 36000Kobad 27 36000Murphy 42 50000Zenith 59 118000How do i write a query to display the name of the person with highest percent of quota? :confu...

Hello Professionals,I am getting error message ORA-03121 when i try to connect my developer 2000 form 4.5 with Personal oracle8 database.what should i do to connect successfully to my personal database through developer 2000.any help will be appriciated.RegardsAbid Malik...

Hi Friends,I have problem, that I have created a ms-access database where it has some queries among that, a query need a criteria action to run number of times.let me explain you with example.... I have query named "covering", in that a field "QuaranitneNo" is given for that I wrote a criteria actio...

How can I retrieve a record by specifing its zero-based index. (ie. The 500th record according to key #1).Currently, I am going around the problem by reading the first record and keep on getting the next till I reach the required record. However, this method has became less effecient since the numbe...

Hello,I'm building a small database to be used with multi user access over LAN, WAN, Internet etc. From what I hear, using Interbase in WAN enviorments can result in a serious degradation of performance since Interbase is using BDE. Does anyone know how to overcome this issue.ThanksHenrik...

Hello,<br/>I have an oracle table and i would like to know if oracle can anyway react if there's a new record inserted in the table? Or just check for new records? And which language would this be easiest to make?<br/>thanks

Hello,<br/> I have a parameter I am sending to a SP, if the parameter is null, I want the SP to return all rows possible (like a wildcard). <br/> I just need to know what the code is in the SP to return all rows if the parameter has no value.<br/>Thanks,<br/>J

Fail Mrs Sheri GriggFail DR. GEORGE WILSON Fail JILL DOAKE Fail MARTIN HUGHES Fail Dave BirdFail Mrs Sheri GriggFail DR. GEORGE WILSON Fail JILL DOAKE Fail MARTIN HUGHES Fail Dave Birdcnt==========10Pass Mrs Sheri GriggPass DR....

Hi!<br/>If I use Oracle, I have to use: TO_DATE<br/>And If I use SQL Server, I have to use: CONVERT<br/>Is there any standard ODBC function to convert character to date?<br/>Thank you in advance.

Sorry for the newbe question but I can't seem to find the answer in any of the 8 t-sql books I bought.I'm running ms sql 2000. I have a table called cart. Some of the items in the cart need to expire after a given amount of time. One of the fields is a datatime field called added. What i n...

Hi Guys, Access 200 & MS SQL Server 7.0 has some differences in Query Syntax (for eg. ORDER BY in Access is not supported in SQL Server 7.0, DISTINCTROW in Access is only DISTINCT in SQL Server, etc..), how does the conversion take place without compatability issues? And after successfully conv...

so does anyone think its bad<br/>if I have 100 different databases that all have the same name<br/>I have 100 folders to keep them seperate.<br/>Guess I am going to have to change the names of all of em... what a pain...

Please Help,<br/>I need to find out the exact timing on R* Trees.<br/>how much time require the basic Insert,Delete,Update,Search functions etc..<br/>please supply relevant documentation !!!<br/>10x <br/>Ran

Hi,I have implemented a relational database to store a tree like database (used a method simular to the one found here codeproject ( http://www.codeproject.com/asp/hierarchicalsql.asp) ). We have that with some very large databases with many levels of trees and found a great db performance problem....

Hi, I would like to insert some text into the DB, the text should include new lines so it would be ready for extracting.something like:------"Dear Friend,bla bla bla.bla bla.yours, "------I tried using '\n' or even concatenating '||chr(10)' or '||chr(13)', but it didnt...

HiI use asp , ado , AccessXP db to make an online registration system.I created an Insert query in the Access database and call the query like this :set con=Server.CreateObject("Adodb.Connection")con.ConnectionString = strConcon.CursorLocation = 2 'Servercon.Open...set cmd=Server.CreateObject("...

:mad: Hi there: how on earth can i retrieve the UID and password for a user as declared in a ODBC DSN. I can get the ODBC admin dlg by calling SQLDriverConnect, and then get the exact name of the DSN by calling SQLGetInfo with SQL_DATA_SOURCE_NAME set, but i can't figure it out how i can get th...

Hi I have the following code dbMessageQueue.AddNew(); dbMessageQueue.SetTextMessage("txt"); dbMessageQueue.SetMessageStatus(1); dbMessageQueue.SetMessageSize(1); dbMessageQueue.Update();Im accessing the record set via "_RecordsetPtr"Now my problem is the fields i have are all "not nulls"From th...

Hi, I have a few questions about printing:1)I have many records in my database, and each one has a date. Now i want to print all records with the date that i typed in an input box.2)I want to print every record where the checkbox's value is "True"Sorry for the bad english :(...

I have an MS Access 2000 db that contains an External Link to an Oracle table.If you start up MS Access, and try to open the Oracle table, you get the standard login dialog box, to enter UserID and Password.I would like my end users to not have to enter that information. I would like to set the Use...

Good morning,In a recent task at my job the issue of DB standards came up. One of the topics is "Naming Conventions". We wanted to nail down standards for naming anywhere from a @variable to a database. Among some of the rules came up: -- Not using the table name as a prefix for the columns. i....

Hi..I use ASP , ADO to open AccessXP databasemy connection string :strCon="Data Source=" & Server.MapPath("db.mdb") & "; Provider=Microsoft.jet.oledb.4.0;password=mypass;"i get the eror :Cannot start your application. The workgroup information file is missing or opened exclusively by another user....

is there a way to represent inheritance in ms access?<br/>e.g. to have a table - "Person", with properties ID, Name, etc<br/>and some child entities such as "Employee" that would automatically have its parent fields, together with some of their own.<br/>thanks.

Hi,<br/>Does anybody know how to connect a MS app to Oracle OLAP cubes.<br/>Is MS OLE for OLAP covering that?<br/>Or is there any other driver?<br/>tx,<br/>Horatiu

Hi, I am new to Sql server in fact i've only been using it for the last two hours , the create database and create table statements worked fine,I am now trying to insert, delete, and update some records on SQLSERVER 2000, and i am getting this error for each insert , update or delete statement...

Hi,I insert a dataset into a CDaorecordset in the following way:pSet->AddNew();pSet->SetBookmark(pSet->GetLastModifiedBookmark());pSet->... pSet->Update();This works once, the second time an exception is thrown by Update.In this way it works:pSet->AddNew();pSet->Update();pSet-&g...

I am working on an application that will need to create a database in MySql. I have not been able to find any reference on how to check to see if a database name exists before I go creating it. I did find the syntax CREATE IF NOT EXIST db_name but if I am creating the database for the firs time th...

I want to access a table in oracle.Code is following:m_pRecordset.CreateInstance("ADODB.Recordset");try{m_pRecordset->Open("SELECT * FROM test",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);}catch (_com_error e){AfxMessageBox(e.Description());return...

Greetings: Well I am little bit confused about the concept of Login and Users in Sql Server Database. The thing is that for Each user of a specific database, you have to attach that user to a specific Login to acces that database. Now if you make another user in the same database, yo...

Hello,I trying to open a text file trough ODBC, with Microsoft Text Driver, but I always get this message: "The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. " What's the probl...

Hi! I have a question about the MFC CDaoRecordset class. I am having some trouble with it and I hope someone out there might know the answer to my question! (Pleeeeaase!) Let me describe the problem... First, I'd like to explain what error I'm getting and then describe a bit how my progra...

I'd like to get the Message From the Database.Example:I Send a sql sunch as:print 'This is a Message'the sqlserver2000 should return Message "This is a Message" to me,but how can I get the Message use ADO in VC++;in oracle the command:DBMS_OUTPUT.PUT_LINE('My Message !')Now,...

Hello,I have posed this question to different people and the answers have confused me all the more.I have a component written in Java using JDBC to talk to different databases (Oracle/SQL Server). I have two queries1) Can i create a transaction with a custom/user defined ID. I would like to use this...

Hi,I have a question about Oracle stored procedure. I have a table that contains fields ITEM1, ITEM2, ... ITEM120. Can I do a loop to go through them following the logic as:totCnt = 0for i = 1 .. 120 fieldname='ITEM' & to_string(i) select count(*) cnt from table1 where fieldna...

Hi I am writing a stored procedure in Microsoft SQL server 2000 as shown below: DECLARE @sql nvarchar(1000)SET @sql = 'SELECT * FROM myTable WHERE name LIKE ' + '%[%]'EXEC sp_executesql @sqlThe SQL analyser gave me the error " Invalid column name '%[%]' ". I think t...