|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Dell PowerEdge Servers
|
|
#1
May 5th, 2003, 12:30 AM
|
|||
|
|||
|
ADODB connection question
I am trying to figure out the meaning of something. I have
Code:
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.open "Query1", objConn, 2
Note the 2 at the end. What does it mean? When I change it to 1 and 3, it also works. What is the proper setting? Any link to find more info on this would be appreciated.
|
|
#2
May 5th, 2003, 07:42 AM
|
|||
|
|||
|
the third argument is the Cursor Type, and the Fourth argument is the LockType. If you include an adovbs.inc file in your asp pages then you can define these by a name rather than by a number which is much more difficulte to remember. As for a page with reference, i just i did a search in google for "ASP Recorset open method", and the first page was this.
http://www.devguru.com/Technologies...rdset_open.html
|
|
#3
May 17th, 2003, 05:09 AM
|
|||
|
|||
|
If you want to have a play around with connection strings.
make an empty text file on your desktop or somewhere handy. rename it test.udl or anything else as long as it has a .UDL as the extension then double click on it. Select the connection parameter you need then select ok. Then go to word pad or some other text editor and take a look inside the file. Sort of handy really.
__________________
-- ngibsonau
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > ADODB connection question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
