sql server odbc: ODBC Error when running DTS directly on the server -- sql server odbc

ODBC Error when running DTS directly on the server

Dominic Feron
6/10/2005 1:22:14 PM

sql server odbc:

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.

Re: ODBC Error when running DTS directly on the server

Sue Hoegemeier
6/13/2005 6:08:00 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"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.