closing a database after opening it..... 1

[inteleserve]

I am opening a database and updating records; What command could I type to close out a database after updating it? Is their a way to open the database shared?




Ross

"life is like a box of chocolates, you never know what your gonna get"

-Forrest Gump

 

[mwolf00]

set cn=server.createobject("adodb.connection")cn.open application("connectString")
'be consistant with the connection string
'and you will have connection pooling

..
..
..

'close the open connection
cn.close()
set cn = nothing



Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[lovejaeeun]

what is connection pooling?

 

[mwolf00]

http://www.4guysfromrolla.com/webtech/110598-1.shtml

http://www.15seconds.com/issue/970531.htm

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[inteleserve]

My website opens the database and displays the information in a form. Then submits changes to the data via the submit button. Both of these procedures require a ODBC connection to the VisualFoxPro database (.dbc)
However, while this is happening I need to beable to append or insert new records into the table in my (.dbc) file.

Right now, I am not able to get exclusive access with visual foxpro to this database while also viewing/updating from the webpage.


Any suggestions?

Computers are like women. They act up atleast once a month.
-Aaron Hammershinder