SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
New Contributor
Posts: 2

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

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.

New Contributor
Posts: 2

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

Forgot to add that this is a dataflux architect issue

Super Contributor
Posts: 418

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

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.

Frequent Contributor
Posts: 101

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

Posted in reply to Anotherdream

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.

Super User
Posts: 3,254

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

Posted in reply to Helannivas

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.

Ask a Question
Discussion stats
  • 4 replies
  • 1246 views
  • 0 likes
  • 4 in conversation