Under ASP, I have this statement which works:
strSQL="select * from " & Table_Name
objRS.open strSQL, objConn
But when I want to sort according to my column 'Position' (which is of number type under Access 2000) It no longer works. Any Idea?:
strSQL="select * from " & Table_Name & " Order by Position"
objRS.open strSQL, objConn
I have this error:
error '80004005'
Unspecified error
I'm connected this way:
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"&_
"Data Source=o:\teams\pursuit\db\productdb.mdb;" &_
"Persist Security Info=False"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = StrConnect
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.activeconnection = objConn
Help:confused:Don't search, the name'position' for my field was a key word
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment