|
Home > Archive > MS SQL Server ODBC > June 2005 > ODBC Error when running DTS directly on the server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ODBC Error when running DTS directly on the server
|
|
| Dominic Feron 2005-06-10, 1:23 pm |
| Hello everyone,
I have just created some DTS package wich pump data from Visual FoxPro
database to SQL Server 2000.
Everything works fine when I execute de package on my local machine or any
other machine that aren't servers.
Things gets ugly when I try to execute these package directly on the server.
I get this error message : "[Microsoft][ODBC Visual foxPro Driver]Exclusive"
and thats it.
As you can guess, we can't schedule any of these task on the server.
I tryed to install the latest ODBC drivers on the server, but i still get
this error message. I also looked at the rights\access on SQL Server, and I
run this thing as a DBO. So I don't think it's a driver issue...
Anyone can help me on this? I just can't find anything on the WEB!
BTW, the VFP database files aren't on the local machine but somewhere on the
network.
| |
| Sue Hoegemeier 2005-06-13, 7:23 am |
| Are you trying to execute this with a job? The job owner
makes a difference and the service account needs access to
whatever location where the foxpro files are located.
Did you try logging onto the server under your windows
account and executing the package?
-Sue
On Fri, 10 Jun 2005 13:22:14 -0400, "Dominic Feron"
<dominic.feron@dessausoprin.com> wrote:
>Hello everyone,
>
>I have just created some DTS package wich pump data from Visual FoxPro
>database to SQL Server 2000.
>
>Everything works fine when I execute de package on my local machine or any
>other machine that aren't servers.
>
>Things gets ugly when I try to execute these package directly on the server.
>
>I get this error message : "[Microsoft][ODBC Visual foxPro Driver]Exclusive"
>and thats it.
>
>As you can guess, we can't schedule any of these task on the server.
>
>I tryed to install the latest ODBC drivers on the server, but i still get
>this error message. I also looked at the rights\access on SQL Server, and I
>run this thing as a DBO. So I don't think it's a driver issue...
>
>Anyone can help me on this? I just can't find anything on the WEB!
>
>
>BTW, the VFP database files aren't on the local machine but somewhere on the
>network.
>
>
|
|
|
|
|