Can't get the Data with ASP

[oraclec]

Hi,

I'm running on local web server IIS, and using a remote MS SQL Server 2000 Enterprise Manager which houses my database. I have set my ODBC connection.

I'm trying to retrieve data with my ASP pages, but had this errror: (Connection to SQL Server was successful)

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''

My connection string in ASP is:
<%
Function Connection
Dim MyConn
Set MyConn = Server.CreateObject(&quot;ADODB.Connection&quot
MyConn.Open &quot;PROVIDER=SQLOLEDB; DATA SOURCE=myDataSourceName; DATABASE=myDatabaseName;&quot;
End Function
%>

I'm using Windows NT authentication, so no need for username and password.

Do hope someone can help. Is it access rights problem (have to set within SQL Enterprise Manager or something else? Thanks!


|*Oraclec*|

 

[phuctran]

Can you give more info ? from open connection to get recordset code.