|
If you can't answer that question yourself you need switch to VB or other languages where you won't hurt yourself.
|
|
|
|
|
Yes, You don't have problem with that.
You only need to use the open method in your class. Your class is derived from the CRecordset class, is for this that you don't have problem.
Cheers!!!
Carlos Antollini.
|
|
|
|
|
I want the AAID to be the BBID but this aint working!
DECLARE @sune int
SELECT @sune = MAX(AAID) FROM TEST_SESSION
INSERT INTO CAB_TEST
(BBID, CabComment, CabName, CabFNum, CabFName, CabSNum, CabEmp, CabRefDes)
VALUES(@sune, Null, 'Kabel1', '222-221', 'Styrkabel', Null, 'Chassi', Null);
Plezz Help
/Bigge
|
|
|
|
|
For the Last 6 hours i have tried to connect to a MSDE database wich was produce on a another computer using Win 2000, When i use the ATL wizard consumer function I get the messeage "Could not open column information"
I have troubel to connect to other sources to, it had work before but something is really wrong now, and Im very frustrated.
I can look at the database in Access 2000 but when i will create a new table i get the mes. "You got no exclusive access to the database at this time".
My questinon to you people are, How should the producer of the DB configure his database(using Access 2000 adp project) so it easy can move it to another machine and system?
Im very grateful for answers.
/Bigge
|
|
|
|
|
Do you have admin priviledges? What are the security settings on the DB? Is it corrupted? Have you run a compact/repair successfully? Do you both have the latest MDAC on your systems?
|
|
|
|
|
When i lanche his DB i change the login ID and Sql server ID under connection in Access. And link the *.mdf file to the catalog om my computer. Thats it
We have admin priviledges, the security settings im not shore of. compact/repair were is this option?
I have only installed MSDE and i tried to use servicepack 3 for SQL server 7 to uppgrade MDAC and more. But i got some failurs. Do you now witch pack i should uses to uppgrade?
Thanks alot
/Bigge
|
|
|
|
|
After 8 hours it worked, the MSDE server was corrupt. SH*T HAPPENS!
|
|
|
|
|
Hi there,
I was wondering if there is any open source Database project where one
could participate in. I am refering to an actual Database Development
Project as opposed to SQL.
If not, is there any site where you can get some headstart into the
design of relational databases?
|
|
|
|
|
There are lots of open source projects on freshmeat.net and sourceforge.net.
|
|
|
|
|
IMHO, PostgreSQL is the best thing out there.
It basically kicks arse on all the other free RDBMSes and the vast majority of commercial offerings.
I have recently started using MS SQL server at work and I must say, Postgres compares very favourably.
http://www.postgresql.org
You'd have to be pretty hard core to wanna get into this source code 
|
|
|
|
|
|
Objectives
The objectives of this project are: to design a conceptual database schema (Entity-
Relationship diagram or any other conceptual modeling notation) for a given
specification of a sample database domain, to translate a conceptual schema into
object classes and associations of object-oriented database, to specify the object
classes and associations in Object Definition Language, to implement and to load a
sample contents of object-oriented database and to implement few database
applications using Object SQL and C++ bindings.
|
|
|
|
|
I don't see a question here so I'm assuming you are just keeping everyone updated on your current homework project.
|
|
|
|
|
I have a database set up where some columns might have no data entered like in the following example
<br />
record [Column1Data : Column2Data]<br />
record [Column1Data : Column2Data : Column3Data]<br />
I would like to differenciate between the two records by querying the first record that has no data for column3.
I figured on trying
SELECT * FROM TABLE1 WHERE Column1 LIKE 'Column1Data' AND Column2 LIKE 'Column2Data' AND Column3 LIKE ('')
but this returned no records. Is something like this possible or might this be an issue of database setup?
Thanks!
|
|
|
|
|
Nevermind! Found the solution I believe.
for those with curiousity...
Is Null for empty fields
Is Not Null for not empty fields
So for example
SELECT * FROM TABLE WHERE COLUMN1 LIKE 'DATA1' AND COLUMN2 Is Null
This will return all records where column1 is DATA1 and column2 is blank.
"Why are we hiding from the police, Daddy?"
"We use VI, son. They use Emacs."
|
|
|
|
|
I'm pretty new to ADO and need some guidence. I'm using MS Access 2K. I have
three tables. The tables looks as follows:
UserAccounts
------------
UserAcctID (key, autonumber)
UserAcctData
Queues
------
QueueID (key, autonumber)
QueueName
QueueRights
-----------
UserAcctID (foreign key)
QueueID (foreign key)
Rights
I'm using ADO and DCOM so there's potential of multiple admin users trying
to access and modify the tables at one time. I need to ensure that referential
integrity is ensured, and wondered if developers typically use locking mechanisms
or the referential integrity tool in MS Access, or both.
I also, have the following situations, and am not sure of the best way to resolve
them in terms of locking and ensuring that the keys/data won't be out of sync:
1) When one admin is editing another user's account, another admin cannot edit that
user's account. What's the best way to lock the account? Add a lock timestamp
column to UserAccounts?
Also, is this a user-friendly restriction? Do other administration program lock
another user from editing the same account, or do they allow them to edit it and
then notify them that it has changed when it's time to update and for them to reload
and redo what they've done?
2) When an admin is about to update another user's queue rights, I would need to
lock the entire "Queues" table from being added to while records are being added
or updated to the QueueRights table. What's the best way of accomplishing that?
3) Also are there any good websites and/or books that discusses how to resolve
issues with multiple users and databases?
Thanks in advance for any help!
|
|
|
|
|
Hi
I have came across a strange situation . I have an application in VB which I have used ADODB:Command to call Stored procedures in SQL Server . at the beginnig of application I create Commands and set them in Connection .
Set c = New ADODB.Command
c.Name = "DeleteProjIX"
Set c.ActiveConnection = cn
c.CommandText = mPrefix & "DeleteProjIX"
c.CommandType = adCmdStoredProc
c.Parameters.Append c.CreateParameter("@ID", adInteger, adParamInput)
( cn is a valid open ADODB::Connection and mPrefix is a valid String )
This application used to work well until we upgraded to SQLServer 2000 .
using this server and a machine which we have installed client tools of SQLServer 2k , the application seems to 'loose' these stored procedures after a while , so after a completely random cycles ( less than an hour ) we get a message notifying of unrecognised command . stepping through code reveals that there is no command in the connection . this problem does not produce in any specific sequence of actions or specific time . with higher load of server it happens more often . running the application on a SQLServer7 and a client loaded with SQLServer7 client tools , all the problems disappear .
What is the cause of this change ?
I would really appreciate your help
Thanks in advance
|
|
|
|
|
Hi,
I want to create some kind of catalog, where people can look up stuff. There will be approx. 1,000,000 items. The whole thing is supposed to be shipped on a CD. The Database that stores the information needs to be safe, i.e., only viewable with my application. MS Access is not safe enough.
Unfortunately, I have no idea how to develop my own DB. Does anyone know a DB or some code I could use?
Help is greatly appreciated!
Regards,
Dominik
Again, the main points:
- desktop-based
- 1,000,000+ records
- safe
|
|
|
|
|
Actually, I've been involved in creating a simple DBMS.  The hard part is making the index file, and it is usually done by some kind of B-TREE data structure. If I were you, I wouldn't bother to develop my own B-TREE implementation, because there is some free code on the Internet  . If you can't find any, ask me for a sample.
I vote pro drink
|
|
|
|
|
Have you considered using SQL Server? You can use the MSDE for the desktop and get the benefits of SQL Server. This would also provide an upgrade path. For a 1,000,000 record db I wouldn't even consider Access.
|
|
|
|
|
You need a database that stores the info in an encrypted format. I'm sure you could write one from scratch but there's got to be a database that has some kind of encryption layer built in. Unfortunately I don't know of any offhand but then I'm new to databases myself. Try searching for database + encryption.
|
|
|
|
|
Hi,
I want to create some kind of catalog, where people can look up stuff. There will be approx. 1,000,000 items. The whole thing is supposed to be shipped on a CD. The Database that stores the information needs to be safe, i.e., only viewable with my application. MS Access is not safe enough.
Unfortunately, I have no idea how to develop my own DB. Does anyone know a DB or some code I could use?
Help is greatly appreciated!
Regards,
Dominik
Again, the main points:
- desktop-based
- 1,000,000+ records
- safe
|
|
|
|
|
Hi,
I want to create some kind of catalog, where people can look up stuff. There will be approx. 1,000,000 items. The whole thing is supposed to be shipped on a CD. The Database that stores the information needs to be safe, i.e., only viewable with my application. MS Access is not safe enough.
Unfortunately, I have no idea how to develop my own DB. Does anyone know a DB or some code I could use?
Help is greatly appreciated!
Regards,
Dominik
Again, the main points:
- desktop-based
- 1,000,000+ records
- safe
|
|
|
|
|
Can you write Active Server Pages for a UDB backend? Is there a known white paper on this topic?
|
|
|
|
|
Of course you can. With ASP you would be using ADO to connect to the database. All that you would have to do is change the connection string so that it uses the ADO driver for UDB.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
