Posts by debasisdas

You need to format the DateTimePicker1.Text before passing the same into database for inserting.

what you have tried so far ?

you have to create a procedure / function for that.

I am only getting results for converting a MS Accss 'database' to a SQL 'database'. ...... I just want to convert one MS Access 'table' to SQL Server (2008) 'table'.

What is the difference ?

so, what is the problem ?

You need to use ADO library in VB 6.

Read more here and here.

for that you need to frame the query dynamically at run time.

try this.

PREPARE sql_stmt FROM "your query";
EXECUTE sql_stmt;

you need to round off the value to the desired decimal places.

how to insert a pdf file in database

Read the file into a binary stream and store the same into a database table.

You need to read this.

The concept is same for all databases.

What exactly you mean by disable a cell of datagrid ? Are you trying to make it read only ?

declaring variables and assigning values to those.

This may help.

also try --- Shell "shutdown -s"

The following links may help.

http://www.vbforums.com/showthread.php?t=350570
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=1&txtCodeId=8224
http://www.winpim.com/anigif.htm

From where you got this error ?

What code , which application, which database ?

you can search for those. Most of them are not free to use.

You need to use some third party tools / components to generate barcode.

That will depend how the value is stored.

Sql Server and MySql may behave differently to the exact same piece of code, after all they are two different databases from two different vendors.

check for date format.

4. How does it happen that people here misunderstand each other frequently?
There.

We do it frequently for some serious fun and to confuse others.

Your code is horrible.
Columns names are qualified by table name not the reverse as mentioned by you in the SQL.

Using the owner argument with the Show method ensures that the dialog box will be minimized when it’s parent is minimized, or unloaded should the parent form be closed.

Using the Show method with both style and owner arguments.

For example:

' Display frmAbout as a modeless child of frmMain.
    frmAbout.Show vbModeless, frmMain

You can go ahead and implement the approach if you have proper back up and recovery mechanism. Remember you are putting all the eggs in a single basket.

What exactly you are trying to do ?

ADODC is not a database, it is a control to connect to database.

use ADODB and try this code

cn.begintrans  ' cn--adodb connection object
cn.execute "your update command goes here"
cn.committrans

If it is one value or more always better to store securely , preferable in DB.

What about using database for the purpose.

Have you tried as i suggested in my previous post ?

Consider this and check if this suits your requirement.

Tables structure

Person
(id,
name,
field3,
field4,
..........
static_energy,
se_status)

1. Initially insert al other details into the Person table except statis_energy column and set the se_status to 0.
2. when the external process runs creat the output into a text file with name same as ID of the person and update the status in the table to 1.
continue this process for all other person details.
3. Run a procedure to read the text file and update the static_energy column of the corresponding record (based on ID).

Is that being stored anywhere in the DB ?

How the application knows what is the status of the execution of external process ?

Are you setting any flag ?

Generally how you determine if the external process executed properly or not ?

Are you going to insert every thing from the text file into a table or update a single field of a table based on data in text file ?

which part you are struck up with ?

1. read the content from the text file.
2. write to database.

it should be that simple.

What exactly you are trying to do ?

Try this sample code.

Dim cn As New ADODB.connection
 
cn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\data\DataBaseName.mdb"

cn.BeginTrans
cn.Execute "your insert statement goes here."
cn.CommitTrans

i think that is what i suggested.

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.

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.

Find more connection stings here.

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.

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 ?