asp code problems

hi,

can any help checking any error existing in the following code, cos when I add this to my pages,
the asp page can't load, when i take this section out, then the pages work fine again. I think there might have error inside teh code, but i don't know.

The Access file is 100% ok and work, the OCBC also set up inside control panel.


<%
SetOrderId = "OrderID"
If Session(SetOrderId)="" Then
set UD_rsId = Server.CreateObject("ADODB.Recordset")
UD_rsId.ActiveConnection = "dsn=now;"
IDtable = "tGetOrderID"
IDName = "OrderID"
UD_sql = "select " & IDName & " from " & IDtable
UD_rsId.Source = UD_sql
UD_rsId.CursorType = 0
UD_rsId.CursorLocation = 2
UD_rsId.LockType = 2
UD_rsId.Open
Session(SetOrderId) = UD_rsId.Fields(IDName).value
UD_rsId.Fields(IDName).value = Session(SetOrderId) + 1
UD_rsId.Update
UD_rsId.Close
set UD_rsId = Nothing
End If
%>

--
====================
www.EngBook.com.hk
網上直銷語言學習教材
====================

技術資訊 (供技術支援人員使&#29992

• 錯誤類型：
  Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
  [Microsoft][ODBC 驅動程式管理員] 找不到資料來源名稱且未指定預設的驅動程式
  /list_n_pay.asp, line 22
• 瀏覽器類型：
  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
• 頁數：
  GET /list_n_pay.asp
• 時間：
  2004年5月18日, 上午 12:14:10
• 其他資訊：
  Microsoft Support

Don't double post, I just answered this question in the other forum area.

Sorry sorry, anyway, thanks for your help