Linked server to FoxPro - permissions

you'd want to specify the remote login and how local login is mapped.
--Everyone connects via Admin db user
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
-oj
"ddavis" <ddavis@.discussions.microsoft.com> wrote in message
news:AF38060C-1BCB-4A83-86BE-A04068521894@.microsoft.com...
>I set up a linked server and it is working great.....when i'm logged in
> under the same account that SQL runs under (also the account that i set up
> the linked server as, if it matters). However, if i'm logged in as anyone
> else i get the error:
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'VFPOLEDB' reported an error. Access denied.
> OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IUnknown::QueryInterfac
e
> returned 0x80070005: Access denied.].
> It even does this with my account (full sql and domain admin). Help!I set up a linked server and it is working great.....when i'm logged in
under the same account that SQL runs under (also the account that i set up
the linked server as, if it matters). However, if i'm logged in as anyone
else i get the error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'VFPOLEDB' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IUnknown::QueryInterface
returned 0x80070005: Access denied.].
It even does this with my account (full sql and domain admin). Help!|||you'd want to specify the remote login and how local login is mapped.
--Everyone connects via Admin db user
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
-oj
"ddavis" <ddavis@.discussions.microsoft.com> wrote in message
news:AF38060C-1BCB-4A83-86BE-A04068521894@.microsoft.com...
>I set up a linked server and it is working great.....when i'm logged in
> under the same account that SQL runs under (also the account that i set up
> the linked server as, if it matters). However, if i'm logged in as anyone
> else i get the error:
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'VFPOLEDB' reported an error. Access denied.
> OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IUnknown::QueryInterfac
e
> returned 0x80070005: Access denied.].
> It even does this with my account (full sql and domain admin). Help!|||doesn't that map logins from sql server to remote(foxpro) logins? I don't
believe there is any sort of security on the foxpro database (not even sure
that they're capable of that).
If I'm wrong about any of that, please let me know.|||doesn't that map logins from sql server to remote(foxpro) logins? I don't
believe there is any sort of security on the foxpro database (not even sure
that they're capable of that).
If I'm wrong about any of that, please let me know.|||ha can help me out in my prob ...? check out Ravi --> primary Key falling
short sorry for this ..!|||ha can help me out in my prob ...? check out Ravi --> primary Key falling
short sorry for this ..!|||most jet engine has an 'admin' login.
either:
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
or
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, NULL, NULL
should work for vfp. The key is in the 'false' parameter. It tells sql not
use the current executing user credential for accessing vfp.
-oj
"ddavis" <ddavis@.discussions.microsoft.com> wrote in message
news:6D4C43C2-8EFA-4109-BF77-4D1ADE7746D6@.microsoft.com...
> doesn't that map logins from sql server to remote(foxpro) logins? I don't
> believe there is any sort of security on the foxpro database (not even
> sure
> that they're capable of that).
> If I'm wrong about any of that, please let me know.|||most jet engine has an 'admin' login.
either:
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
or
EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, NULL, NULL
should work for vfp. The key is in the 'false' parameter. It tells sql not
use the current executing user credential for accessing vfp.
-oj
"ddavis" <ddavis@.discussions.microsoft.com> wrote in message
news:6D4C43C2-8EFA-4109-BF77-4D1ADE7746D6@.microsoft.com...
> doesn't that map logins from sql server to remote(foxpro) logins? I don't
> believe there is any sort of security on the foxpro database (not even
> sure
> that they're capable of that).
> If I'm wrong about any of that, please let me know.|||Tried both, to no avail.........any other ideas?
Thanks!
"oj" wrote:

> most jet engine has an 'admin' login.
> either:
> EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, 'Admin', NULL
> or
> EXEC sp_addlinkedsrvlogin 'linked_server', 'false', NULL, NULL, NULL
> should work for vfp. The key is in the 'false' parameter. It tells sql not
> use the current executing user credential for accessing vfp.
>
> --
> -oj

Linked Server to AS400 via ODBC Codepage Problem

Hi!
I am connecting to an as400 server (v5r2) from my sql 2000 server
using the oledb provider for odbc. In the provider string i use:
Driver={iSeries Access ODBC Driver};System=myServer;DefaultLibraries
=QG
PL;QUERYTIMEOUT=0;CCSID=1253;UNICODESQL=
1;TRANSLATE=0;
which works fine with english data i try to retrieve. However
some of the data is in greek. All the greek data comes back intelligible.
the codepage on the as400 system is 37.
Could any one please help me?
Thank you all in advance.Well,
In America it's common that when something is illegible, we say "It looks li
ke Greek to me". So maybe they figured if you want it back in Greek, they w
ould just give you junk