Posts by debasisdas

You need to store the details of the room in database with a flag for empty/occupied.

dates are in which file ,is it in a database ?

How MS Access 2007 is in .MDB format ? It should be .ACCDB.

No.

i think that is what i suggested.

are you sure the database is MS Access 2007 format ?

go and read books

you can't

You can use either crystal report or form.

To display in Vb forms , you need to use Move methods of the ADO.

To display CR , you need to insert page brakes after each record.

before AddNew method.

You need to insert new record only if count is 0 (the user id does not exist), for this user id must be primary key of the table.

This may help.

What button you would like to add ?

From where you generate the .csv ?

Why not directly upload the csv into Oracle ?

And i developed the front end from where i wiil take csv which will insert the data to sql server

then what does this mean ?

You want to insert into sql server or oracle ?

Are you doing any other processing in application startup or only database connection ?

What about storing the voting time in DB and allow the user to vote again only after 24 hrs.

Just try once as suggested in the previous post and check if that works.

From MsSQL export data into a .csv file and use SQL Loader to load the same into Oracle. source and destination table fields should be compatible.

Try to call the .nsu file in a batch file and call the .bat file using shell.

I am not sure if Shell supports that file extension.

New question should go to a new thread.

what failed for you, download(as per your 1st post) or install(as per 2nd).

There is no way of downloading sql- pl/sql.

I do not know about what you are trying to say, please let me know.

Any tool that supports reverse engineering should do that for you.

Try using MS Visio for the purpose.

try this

Form2.WindowsMediaPlayer1.URL = "c:\Users\lapi\Desktop\DOWNLOADED\365.wmv"

Lets see your code that you are working on and fix it.

Oracle works on 1521 and 1522 only, using other ports may not help.

It is not the connection string but he driver that you are using to use the connection string internally makes all the difference.

Which port you are going to open ?

The solution in the link will work if you are using some of the basic controls like a textbox and buttons. Other wise backward compatibility is not supported on most of the applications.

Go through the tutorial properly.

Find more connection stings here.

what is the code that you are working on ?

does you dataset refers to your database (i can't find that in your code) ?

No need to connect the Bar code scanner with Visual Basic. What you need to do is use the device to the system and use it. Bar code scanner work like a simple input device (like keyboard) attached to the system. It simply scans the code and puts the code into any control having focus. No need of any special coding for that. You may need to use some library (usually provided by the vendor of the device) to process the code captured from the device.

You need to look into the property pallet of the control, and refer to the property mentioned in the previous post.

tnsping only working on database server

who told you ?

It will work from each and every system that has oracle client installed and has the TNS set, and can access the server over any network like LAN.

ds refers to what ?

type tnsping <database_name> at command prompt and check the response time.

ex---- tnsping orcl

what about tnsping ?

and how fast is the ping request

try using system / server name instead of IP.

You need to write log for each event or each execution step if required .

Tell me first the database is on the same machine from which you are trying to connect or on another server over LAN ?

How fast you are able to connect to oracle server form any client on the same machine as your application . Is is faster than your application connection time ?

What exactly you mean by startup is very slow ?

You need to contact the vendor of API.

changing the data type of a field is a bad idea.

How you populate the data grid ?

is it from database ?

That version of the software is de-supported for over a decade now so is not available any more. It was not a freeware.

before inserting any record into the table take a count of records

Select count(*) from users where id = "txtid.Text"

proceed only if the count returns 0