|
Home > Archive > MS SQL Server > March 2006 > To link tables from Visual Fox Pro to SQL SERVER 2000
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 |
To link tables from Visual Fox Pro to SQL SERVER 2000
|
|
| pabloov 2006-03-05, 8:23 pm |
| Hi everybody, i have a problem, i'm trying to link some tables from Visual
Fox Pro to SQL Server. I'll try it with Access and is very easy but i can't
do the same with SQL SERVER. If someone will do it, I would be very grateful
for help.
Thanks in advance. (Sorry about my english).
| |
| Cindy Winegarden 2006-03-05, 8:23 pm |
| Hi Pabloov,
I assume you're trying to create a linked server. Are you using ODBC or OLE
DB? Be sure you have the latest version; both are downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates. What steps have you tried?
What happened?
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"pabloov" <pabloov@telefonica.net> wrote in message
news:%23n3uBWiPGHA.2628@TK2MSFTNGP15.phx.gbl...
> Hi everybody, i have a problem, i'm trying to link some tables from Visual
> Fox Pro to SQL Server. I'll try it with Access and is very easy but i
> can't do the same with SQL SERVER. If someone will do it, I would be very
> grateful for help.
| |
| pabloov 2006-03-05, 8:24 pm |
| Thanks for the information about "Linked Server", i didn't know this kind of
server. I found information about it and i've got it.
greetings.
"Cindy Winegarden" < cindy_winegarden@msn
.com> escribió en el mensaje
news:eqj7a1mPGHA.4956@TK2MSFTNGP09.phx.gbl...
> Hi Pabloov,
>
> I assume you're trying to create a linked server. Are you using ODBC or
> OLE DB? Be sure you have the latest version; both are downloadable from
> msdn.microsoft.com/vfoxpro/downloads/updates. What steps have you tried?
> What happened?
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn
.com www.cindywinegarden.com
>
>
> "pabloov" <pabloov@telefonica.net> wrote in message
> news:%23n3uBWiPGHA.2628@TK2MSFTNGP15.phx.gbl...
>
>
| |
| pabloov 2006-03-05, 8:24 pm |
| underprocessable | |
| Cindy Winegarden 2006-03-05, 8:24 pm |
| Hi Pabloov,
Here's what works for me in SQL 2005 using the Linked Server dialog:
Providers list: VFPOLEDB shows as an entry
Linked Servers > New Linked Server ...
Linked Server: MyLinkedServer
Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro"
Product name: Visual FoxPro (I think this is optional)
Data source: "C:\Program Files\Microsoft Visual
FoxPro9\Samples\Nort
hwind\Northwind.dbc" (Include quotes since there's
spaces in the string.)
Provider string: VFPOLEDB.1
Location: (blank)
Catalog: (blank)
Security page and Server Options page take defaults.
A Select statement looks like:
Select * From MyLinkedServer...TableName
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"pabloov" <pabloov@telefonica.net> wrote in message
news:eaPYzjsPGHA.5740@TK2MSFTNGP10.phx.gbl...
> Sorry but i have an erro when i run a simple select like:
>
> select * from PRM...almacen
| |
| pabloov 2006-03-05, 8:24 pm |
| Hi Cindy, thanks for your help but i work with SQL 2000, and i don't have
"Microsoft OLE DB Provider for Visual FoxPro" as a provider in the provider
list of my SQL, how can add this provider to my SQL 2000. I have it as an
Provider when i create a ODBC but not in SQL. This is like i use an ODBC.
"Cindy Winegarden" < cindy_winegarden@msn
.com> escribió en el mensaje
news:uNgmX3tPGHA.3256@TK2MSFTNGP15.phx.gbl...
> Hi Pabloov,
>
> Here's what works for me in SQL 2005 using the Linked Server dialog:
>
> Providers list: VFPOLEDB shows as an entry
>
> Linked Servers > New Linked Server ...
>
> Linked Server: MyLinkedServer
> Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro"
> Product name: Visual FoxPro (I think this is optional)
> Data source: "C:\Program Files\Microsoft Visual
> FoxPro9\Samples\Nort
hwind\Northwind.dbc" (Include quotes since there's
> spaces in the string.)
>
> Provider string: VFPOLEDB.1
> Location: (blank)
> Catalog: (blank)
> Security page and Server Options page take defaults.
>
> A Select statement looks like:
> Select * From MyLinkedServer...TableName
>
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn
.com www.cindywinegarden.com
>
>
> "pabloov" <pabloov@telefonica.net> wrote in message
> news:eaPYzjsPGHA.5740@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Cindy Winegarden 2006-03-05, 8:24 pm |
| Hi Pabloov,
OLE DB is not the same as ODBC. It's a newer technology with better
features. As in my first post, you can download it from
msdn.microsoft.com/vfoxpro/downloads/updates.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"pabloov" <pabloov@telefonica.net> wrote in message
news:uLgF5FuPGHA.564@TK2MSFTNGP10.phx.gbl...
> Hi Cindy, thanks for your help but i work with SQL 2000, and i don't have
> "Microsoft OLE DB Provider for Visual FoxPro" as a provider in the
> provider list of my SQL, how can add this provider to my SQL 2000. I have
> it as an Provider when i create a ODBC but not in SQL. This is like i use
> an ODBC.
| |
| pabloov 2006-03-05, 8:24 pm |
| Hi Cindy, thanks a lot, at last i have solved the problem with your help. I
downloaded the OLE DB for Visual FoxPro from then link you said me and
installed it.
Then it appear in the provider list of my SQL 2000. I put the configuration
you said me and it works fine.
Thanks again.
"Cindy Winegarden" < cindy_winegarden@msn
.com> escribió en el mensaje
news:OoQTrjuPGHA.3408@TK2MSFTNGP12.phx.gbl...
> Hi Pabloov,
>
> OLE DB is not the same as ODBC. It's a newer technology with better
> features. As in my first post, you can download it from
> msdn.microsoft.com/vfoxpro/downloads/updates.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn
.com www.cindywinegarden.com
>
>
> "pabloov" <pabloov@telefonica.net> wrote in message
> news:uLgF5FuPGHA.564@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Cindy Winegarden 2006-03-05, 8:24 pm |
| Hi Pabloov,
I'm so glad it worked!
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"pabloov" <pabloov@telefonica.net> wrote in message
news:%234wwqAvPGHA.3944@tk2msftngp13.phx.gbl...
> Hi Cindy, thanks a lot, at last i have solved the problem with your help.
> ....
|
|
|
|
|