Viewing 15 posts - 1,501 through 1,515 (of 2,051 total)
The recordset has more than one parameter for the open-command.
By default it requests the data in read-only mode.
See
http://www.w3schools.com/ado/met_rs_open.asp
for the available parameters.
Rs2.Open"Select * from [V2] where Flag=1",,adOpenKeyset
March 15, 2006 at 6:00 am
I only needed WHILE @@FETCH_STATUS = 0
Checking for other conditions would complicate my code.
*
| 0 | FETCH statement was successful. |
| -1 | FETCH statement failed or... |
March 14, 2006 at 12:53 pm
Ado opens a cursor to the view ( rs2.open)
with Rs2!Flag=3 you try to update it via the cursor.
What are you trying to do (only viewing or also updating)?
March 14, 2006 at 12:48 pm
Very weird indeed.
How do you check the size of non-clustered indexes?
March 14, 2006 at 12:11 pm
Can we see that piece of code?
Is there a linked server involved?
March 14, 2006 at 10:35 am
What ODBC driver is it? Oracle, Mysql ,...
March 14, 2006 at 9:54 am
The following applies to sp3a but most likely also to sp4a (number 3):
To install SQL Server 2000 Analysis Services Service Pack 3a, see
http://go.microsoft.com/fwlink/?LinkId=28434.
N
March 14, 2006 at 6:51 am
I thought you tried to connect to your access db with odbc drivers.
1) Does your query work from the Access-database itself using the odbc connection to sql server with the...
March 14, 2006 at 12:16 am
Just a quick question.
Is the user connecting the database owner/sysadmin/...?
March 13, 2006 at 12:15 pm
Thanks for posting the solution.
March 13, 2006 at 12:06 pm
I assume appseq is the identity field?
Is IDENTITY_INSERT set on/off for the particular table? (see SET IDENTITY_INSERT in the books online)
What is your insert command?
March 13, 2006 at 12:06 pm
The "command" is sent directly to the ODBC source without parsing from sql server.
March 13, 2006 at 12:01 pm
sp_settriggerorder @triggername= 'tI_Table1' /*quotes!*/,@order= 'Last', @stmttype ='INSERT'
*second you can put SET NOCOUNT ON at the beginning of your triggers to reduce...
March 13, 2006 at 11:58 am
*You haven't put replace nor quotes in WHERE pkid = " & Me.txtpkid.Text & ""
assuming pkid is (n)varchar
*What connection technology are you using?
If VB6,Access... you can...
March 13, 2006 at 11:54 am
Viewing 15 posts - 1,501 through 1,515 (of 2,051 total)