you need to create a check constraint with the desired values on the desired column of the table.

is the entry available in TNSNAMES.ORA ?

you are trying to create a new database or trying to log in to existing database.

try the following code, make changes as desired


Dim CN As New ADODB.Connection
Dim RS As ADODB.Recordset
Dim DataFile As Integer, Fl As Long, Chunks As Integer
Dim Fragment As Integer,...

you need to add a do event to your code.

Try to use set operator, that should solve your Qry1 and Qry2.

for the third qry try to join both the tables.

would you mind to post here what are the different things that you have tried ?

what is a minor project .you need to decide first what you want to do.

you need to read books for all the details.

I will think of reading your post only if you are ready to pay for it.

What exactly is a LAN search engine ?

have you started working on that ?

you need to format the value of DTPicker.

you are struck in which part ?

since you are going to design , you should have the requirements. You need to gather all information before starting design of the system

you mean to say , u want to include media files to database ?

Only the owner of the object has the permission/access on the object. Other users needs to be granted permissions by the owner/dba for access which is taken back by the REVOKE command.

If...

i don't think i understood your last question.

kindly post your table structure.

is the items stored in database ?

the following might be helpful.

Save image to database. (http://bytes.com/topic/visual-basic/insights/641548-blob-save-image-database)
Retrieve image stored in database....

You need to use CDO library.

You need to connect to SMS gateway for all that. Contact your Service provider.

missing CONSTRAINT key word on line 8.

what the project is all about ?
Is it only a database projects ?

once you start installing 10/11 g you will get the list of pre-installed oracle homes/products. You need to uninstall the existing 9 version before installing the higher version.

There is no one other than you in my world and you are not there for me.

kindly post your table structures.

you can always do that , just use sysdate that will handle your date problem.

ORACLE will not come in that list of installed software. Uninstall from oracle main menu from start button or use the oracle CD.

Do you want to store and retrieve images in database ?

better install any latest version and set the passwords carefully.

Can you kindly post what have you done so far.

try log in as

sys/ as sysdba
password----change_on_install

If you are planning to reinstall better use any advance version .
Current version for windows is 11.1

try something like this

rs.open "select count(student_id) from students where student_id=" & std_id

if it returns >0 then proceed further.

Try to use DELETESETTINGS to delete any entry from registry.

Are you sure a non-existing application is still running ?

do for the device that has inbuilt file locking system.

as already discussed you just need to use that as a plug play device like any keyboard.

what playable ?

all mp3 files are playable , if your usb drive is a player it will definately play the file.

are you talking about any application developed in VB 6.0 ?