Using client Access ODBC on a SQL 200 Cluster.



Hi everybody, at this moment I'm trying to use a client access odbc on a
sql server 2000 cluster. I use this odbc in dts, to download data from
as/400.

If i execute the dts that was created on another sql server that is not
the cluster it runs fine, but I can´t see the transform data task
properties. Even if I create a new task, I can´t configure the
properties.

Do you know if it´s possible to use this odbc in a cluster escenario??
or not??

do you know any issue i have to considere to use it??

Thanks a lot for your help.



*** Sent via Developersdex http://www.developersdex.com ***
.



Relevant Pages

  • Error at source for row number 7576705 .Error encountered so far in this task: 19
    ... While trying to migrate a table using ODBC into ... SQL SERVER 2000, DTS always fails with error ...
    (microsoft.public.sqlserver.dts)
  • Re: Turbo Delphi and PROGRESS
    ... I use ODBC drivres from DataDirect for ODBC access. ... dataaccess can be real slow, ... is to make a dump at night via ODBC with DTS to SQL Server. ... SQL server if I am not mistaken. ...
    (borland.public.delphi.non-technical)
  • Re: Turbo Delphi and PROGRESS
    ... I use ODBC drivres from DataDirect for ODBC access. ... dataaccess can be real slow, ... do is to make a dump at night via ODBC with DTS to SQL Server. ...
    (borland.public.delphi.non-technical)
  • Date Errors
    ... We're doing a simple copy through odbc from a legacy database to sql server using DTS. ...
    (microsoft.public.sqlserver.dts)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)

Loading