Error Opening a Table in MS SQL Server

[smoi]

Hello... I need help with the error I encounter when I tried to open a Table in MS SQL Server. I have the following code in VB6.

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset
rs.open "TableName", adoConn, adOpenKeyset, adLockOptimistic

where adoConn is my Connection to the Ms SQL Server Database.


The error is:
-2147217900 The request for procedure 'TableName' failed because 'TableName' is a table object.

Is there anything wrong with my line of code? Or something else I miss?

Thank you.
Smoi

[scripto]

check out this kb article

http://support.microsoft.com/kb/173335

[willakawill]

Try this:

rs.open "SELECT * FROM TableName", adoConn, adOpenKeyset, adLockOptimistic

[ITHSC]

This may help...

rs.open "SELECT * FROM TableName", adoConn, adOpenKeyset, adLockOptimistic, adCmdTable

[vijaydiwakar]

Hello... I need help with the error I encounter when I tried to open a Table in MS SQL Server. I have the following code in VB6.

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset
rs.open "TableName", adoConn, adOpenKeyset, adLockOptimistic

where adoConn is my Connection to the Ms SQL Server Database.


The error is:
-2147217900 The request for procedure 'TableName' failed because 'TableName' is a table object.

Is there anything wrong with my line of code? Or something else I miss?

Thank you.
Smoi

basically at a glance it seems to be s wrong code u have to use complete sql qry as given above by all
but.........
u can also use this with the help of command object

check it out