Jump to content

Using ODBC and System DSN


Sanjay

This topic is 7277 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am using one of the proprietory ODBC driver to access DB2 data located in a server at a remote location. I am developing this application on my local machine and have installed the driver on my machine. But when I start hosting files from my machine, the import script step fails to run from any other machine because it does not have the odbc driver installed on it. I tried creating the System DSN but it is not accessible to the other machines. Is there any solution by which I don't need to install the drivers on each workstation.

I want that the import script step should run once in the morning so that all the updated data gets imported from a remote location.

If someone could suggest me a solution, it would be very helpful.

Thanks,

--Sanjay

Link to comment
Share on other sites

This topic is 7277 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.