#12002/10/21 16:15:34
小弟向各位大哥请教:
当我odbc在connections下的gg.asp建立数据源时测试成功,但在建立记录集时会有以下错误:(我用的数据库是ncr公司的数据库teradata)
whle executing generateDynamicSourceBindings in Recordset,a javascript
error occurred.
gg.asp的代码是:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_gg_STRING = "dsn=gg;uid=cxj;pwd=cxj;"
%>
在建立记录集的页面ff.asp的代码是:
<%@LANGUAGE="VBSCRIPT"%>
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_gg_STRING
Recordset1.Source = "SELECT xkzh FROM SDATA.advertisement"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
Untitled Document
<%
Recordset1.Close()
%>
我在ado数据库连接大全里找到有关连接数据库teradata的描述:
ODBC Driver for Teradata
oConn.Open "Provider=Teradata;" & _
"DBCName=MyDbcName;" & _
"Database=MyDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"
现在我不知道怎么改?请大家该我一些帮助吧!不胜感谢!