[IM002] [DataDirect][ODBC lib] Data source name not found and no default driver specified (0)

[pmitani]

I'm receiving this error when I try to load a table from access via architect (run remotely).  I also receive the error when trying to load a table via architect from sql server to oracle (run remotely).  Does anyone know what causes this error?  It only happens when trying to run an architect job remotely.

[pmitani]

Forgot to add that this is a dataflux architect issue

[Anotherdream]

It looks like your code is using the odbc driver to specify the connection to the database, and that odbc connection is not set up on the machine it is being run on.

[Helannivas]

Hi,

I am facing the same driver issue in my SAS library.When I am trying to connect through Putty,  I have given dfdbview command , it has listed all the dsn and then selected the required dsn and provided the username and password.Its successfully got connected. But when i am created a library and try to connect to the database.I am getting the same error as mentioned above.

Looking forward for your response.Thanks in advance.

[SASKiwi]

You should really create a new thread for your problem rather than adding to an old one.

Please provide the code you are using to connect plus confirm what operating system you are running on and what database you are connecting to.