asp connectivity error

Junior Poster

188 posts since Jun 2008

Reputation Points: 10

Solved Threads: 9

0

somebody please help....have to move forward.. :(

Junior Poster

188 posts since Jun 2008

Reputation Points: 10

Solved Threads: 9

See here for more numeric values.

0

rstest.Open "test", constr, adOpenDynamic, adLockOptimistic, adCommandTableDirect

aashishn86, you cannot use named parameters without first declaring them.

Try

rstest.Open "test", constr, 2, 3, 512

Alternatively, you can declare the variables first. like so:

DIM adOpenDynamic, adLockOptimistic, adCommandTableDirect
adOpenDynamic = 2
adLockOptimistic = 3
adCommandTableDirect = 512

Then you can use the named arguments in your open stmt.

Junior Poster

153 posts since Jun 2006

Reputation Points: 37

Solved Threads: 18

0

hey thank's..... i tried that too...
but it still gives the same error...

Junior Poster

188 posts since Jun 2008

Reputation Points: 10

Solved Threads: 9

0

hey thank's..... i tried that too... but it still gives the same error...

I usually just use:

rstest.Open "tablename", constr, 2, 2

Junior Poster

153 posts since Jun 2006

Reputation Points: 37

Solved Threads: 18

Show Comments

1

Can you please verify the exact line and highlight it? I havn't see the addnew method used like that before, not saying it won't work, but just to make sure.

Junior Poster

153 posts since Jun 2006

Reputation Points: 37

Solved Threads: 18

0

thank's......
i'll do that tomorrow and post back..
no access to the server at the moment...

Junior Poster

188 posts since Jun 2008

Reputation Points: 10

Solved Threads: 9

0

<% @Language ="VBscript" %>
<html>
<body>

<% 
   DIM adOpenDynamic, adLockOptimistic,    adCommandTableDirect
   adOpenDynamic = 2
   adLockOptimistic = 3
   adCommandTableDirect = 512   

   constr="provider=sqloledb;data source=1.234.5.678,1234;initial catalog = abcd; User Id=abcde; password=abcde"
   
   Set RSObj = Server.CreateObject("ADODB.RecordSet")
   RSObj.Open "test2",constr,2,3,512
   
   RsObj.AddNew.Fields("fname")="aashish"
   RsObj.AddNew.Fields("lname")= "n"
   RsObj.Update
 %>

</html>
</body>

The error i know get is :
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: '[undefined]'
/aashish/db8.asp, line 16

Junior Poster

188 posts since Jun 2008

Reputation Points: 10

Solved Threads: 9

0

well, the problem was
i was suppose to write it as

RsObj.AddNew
RsObj.Fields("fname")="aashish"
RsObj.Fields("lname")="n"
RsObj.Update

Thank's agrothe , for all the help...............

Junior Poster

188 posts since Jun 2008

Reputation Points: 10

Solved Threads: 9

0

well, the problem was i was suppose to write it as
RsObj.AddNew
RsObj.Fields("fname")="aashish"
RsObj.Fields("lname")="n"
RsObj.Update
Thank's agrothe , for all the help...............

You're welcome! Your previous use of addnew was suspect to say the least! I'm glad your up and running again.

I would now suggest you start using parametrized queries . The method you are using now is very susceptible to SQL Injection Attacks, which I've experience first hand :) .

The provided link is from 4guysfromrolla website and is an excellent way to update your database (very simple) and provides much greater security.

Cheers.

PS: please mark the thread as solved.