DTS problem

Results 1 to 2 of 2

Thread: DTS problem

  1. #1
    Join Date
    Dec 1969

    Default DTS problem

    I am using DTS to pump data from a Sybase DB to MSSQL DB. I am using ODBC to connect to sybase and OLEDB to SQL.<BR> I could execute a sybase stored procedure with &#039;source SQL statement&#039; of DTS. But unfortunately I can not pass any parameter to it. For ex: <BR><BR>exec sp_getcases() <BR><BR>will work great. <BR><BR>But <BR><BR>exec sp_getcases &#039;Jan 1 2002&#039; <BR><BR>is giving me Problems. It says "Null accessors are not supported by this provider". <BR><BR>The DTS is <BR><BR>Win2000 / SQL 7.0 / Service pack 3 / MDAC 2.5 <BR><BR>Any idea folks ? <BR>

  2. #2
    Join Date
    Dec 1969

    Default let me give you an example

    Set rsDelayed = Server.CreateObject("ADODB.Recordset")<BR><BR>page d = "DECLARE @ThisPage int, @RecsPerPage int, @CUSTID int EXECUTE sp_DelayShip "& currentPage & "," & iRecordsPerPage & ","& f<BR><BR>Set rsDelayed = conntemp.Execute(paged)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts