Posts by debasisdas

Your code is perfectly fine.

MySQL is used on most web hosts for the simple reason that it is free.

Can't disagree.

..... will this work in VB6..

100%

After successful log in, you need to check the privilege of the same user from database. If the user has desired privileges then enable the password change form else disable that.

if configuration failed, database service will not start.

Welcome to the forum.

No one is going to supply with ready project.

You need to show effort to get any help.

It asks you to set those during the process of installation.

try to rename the table to something else.

USER is predefined keyword.

What about loading all data from .CSV into database using loader and later filtering out all unwanted records.

You need to use same version of EXP/IMP or EXPDP/IMPDP for database export and import.

You need to read books for all that.
If you hit any search engine with proper keywords, will get a lot of online resources.

You need to heck if database is configured and the service is running. To log in into database you need to provide database username and password not windows credentials.

MS Visio usually displays all the table of the database. You need to select tables related to your schema only. Tables of all other schemas will be qualified by respective schema names.

Since you are always concatenating the generated number to a fixed string, you need to generate only the number part from DB. Using the logic of Max(field)+1 should work fine for you.

If you are using IMP command you need to use the parameter DATA_ONLY.

If you are using IMPDP command you need to use the parameter TABLE_EXISTS_ACTION.

How can anyone log in into the database and corrupt the all important data without any access.

Either the data was not important or there was no security for the database. Even if there is some log you will never find the name of the person who did all that.

You need to use a timer.

What about reading books for all those basic information.

Lets see the code that you are working on and make it work.

Your question is of very novice level. You need to read books for all those information.

You can take count of the desired field from DB.

You need to read this and this.

My understanding is army does not have a rank a soldier has.

Need more clarification to answer this.

SELECT Surename , Forename FROM tblData

Hi harry,

Welcome aboard.

Hi harry,

Welcome aboard.

country : country_code ,country_name
Army : army_code, army_name , country_code
Solders : name , ID , rank,country_code

Centralized.

Have you tried something from your side so far ?

Need more information on the exact issue.

how are you writing the record set to excel ?

set the format type of DatePicker1 to custom
and set the format to hh-mm-ss

To edit an existing record you need to use the method .Edit not .AddNew

are there duplicate entries for field book_num in the table booking ?

Welcome to Daniweb.

Why you need to select the color using a label and why 4 buttons just to change the color.

Select the color using a combobox and use a single button.

They are from two different vendors.

what exactly you are trying to do ?

You need to define the constraint at table level not at column level.

That will work.

You need to read a lot of books.

Pleasse give me any vb6 project or source code

Sorry, we don't do that.

Welcome aboard.

Welcome aboard.

Welcome aboard.

Hi Brittany,

Welcome to Daniweb.

If you already have the code the in which part you are struck with ?

How the picture is being stored in the DB.

Is it the actual picture or the path only ?

yes, what you are trying to do is not supported.

You need to plan your backup activity. It must be scheduled in the time when none of the DB processes are running mostly in early hours of weekends.