brandonmckee
New Member
Hello everyone,
I took a good long look around for an answer for this but haven't found anything solid.
We have a Progress 9.1D database on one of our servers, and we want to replicate that data using SQL's Data Transformation Services. We are using the Merant ODBC driver (3.60, 32-bit) to currently establish a connection between the two databases. The progress database is a mapped drive connected to the other data server.
When I run the DTS package manually, everything works fine. But when I execute the DTS from outside (dtsrun command line, ASP, or PHP) it fails.
Now, I understand this seems more of a SQL DTS issue, but here's where I need some Progress Experts to help - The main issue involving this is that SQL 7 is NT-based, thus does not support mapped drives. I have tried placing a UNC path in the driver's registry key, but that didn't help.
Is there some way to establish a connection to a Progress 9.1D database without us having to use a mapped drive, or a way to change the driver so we don't have a problem connecting to it from outside the SQL database?
Thank you for your help,
Brandon
I took a good long look around for an answer for this but haven't found anything solid.
We have a Progress 9.1D database on one of our servers, and we want to replicate that data using SQL's Data Transformation Services. We are using the Merant ODBC driver (3.60, 32-bit) to currently establish a connection between the two databases. The progress database is a mapped drive connected to the other data server.
When I run the DTS package manually, everything works fine. But when I execute the DTS from outside (dtsrun command line, ASP, or PHP) it fails.
Now, I understand this seems more of a SQL DTS issue, but here's where I need some Progress Experts to help - The main issue involving this is that SQL 7 is NT-based, thus does not support mapped drives. I have tried placing a UNC path in the driver's registry key, but that didn't help.
Is there some way to establish a connection to a Progress 9.1D database without us having to use a mapped drive, or a way to change the driver so we don't have a problem connecting to it from outside the SQL database?
Thank you for your help,
Brandon