Dear SQLers:

The subject about says it all. How do I do this?

My SQL Server 2008 Express system is LOOP\SQLEXPRESS.

Apparently, I should create an ODBC connection. I have no idea
how to do this.

If you only know the SQL Server side, please reply with that
side. That is more than what I know.

Sincerely,

Gene Wirchenko

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
You use sp_addlinkedserver to define a linked server. If authentication
is requireed, you may also need to set up login mapping with
sp_addlinkedsrvlogin.

Once you have this set up, you can query the FoxPro database using
four-part notation, for instance "SELECT * FROM SERVER.db..tbl".

If there is an OLE DB provider for Foxpro, use that one. Else you can
use the MSDASQL provider - that is OLE DB over ODBC - and any the ODBC
driver for Foxpro there might be.

I suspect that Google can be helpful.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On Sat, 12 Mar 2011 13:00:16 +0100, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

I want to query *from* VFP *to* SQL Server.

(Why is it that so many people do not read the title of posts?
Why is it that I forgot this?)

No. I do not know enough to know what to look for, so it just
gets me swamped.

Sincerely,

Gene Wirchenko

Gene Wirchenko wrote:
I haven't used Visual Foxpro, but I have used VB with SQL Server. I'm
pretty sure it's similar.

You don't say whether you're trying to connect to SQL Server on a local
or remote machine. In either case, you'll probably want to configure the
TCP/IP protocol. You will probably also want to enable remote connections.

There are plenty of articles that discuss the above. For example:
http://www.linglom.com/2009/03/28/en...-2008-express/
http://blogs.msdn.com/b/bethmassi/ar...-on-vista.aspx

Part 10 of the above article discusses connection strings.

More information about connection strings can be obtained at:
http://www.carlprothman.net/Default.aspx?tabid=81
http://www.connectionstrings.com/

I tend to use ADO with an OLEDB provider, rather than ODBC.

HTH

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
Because this is an SQL Server newsgroup, and your question is about Visual
FoxPro?

I have no idea how you connect to remote data sources in Visual FoxPro. In
fact my knowledge about FoxPro is about zero.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi Gene,

You should have a dbc created for all work with that sql server.
On the dbc you can create manually a connection to your server or using the
following command only once (with the dbc open)

create connection yourconn connstring "DRIVER=SQL
Server;SERVER=yourservername;UID=username;PWD=pass word;DATABASE=yourdatabasename"

Once you have the connection created you can create remote view on the dbc
and use like regular foxpro tables or use the following command to get data
from sql server on foxpro cursors
Open a connection to sql server
myconn = sqlconnect('yourconn')
To verify if connection is ok
? myconn
If positive is ok
If negative be sure that you enabled remote connection and at least the
TCP/IP protocol on the sql server.
Get data from sql server
=sqlexec(myconn, "select * from somesqltabel", "vfpcursor")

You can reuse the connection for multiple commands.

When you do not need it anymore close the connection with
=sqldisconnect(myconn)

If you need any other connection just pay a visit to
http://www.connectionstrings.com/


Regards,

Viorel


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

On Mon, 14 Mar 2011 08:53:03 +0000 (UTC), Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

My question is about both. You just got the direction wrong.

I figure that it is similar between different languages, but I do
not know that it is not necessary to do something in SQL Server first
to make the data accessible. I need both pieces.

Sincerely,

Gene Wirchenko

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
Connecting from Visual FoxPro is nothing different than connecting from
SQL Server Management Studio or any other application. You need to
have a valid login and if you connect from a different machine, SQL Server
must accept connections over TCP/IP or named pipes, and there must not
be any firewall in the way.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On Mon, 14 Mar 2011 22:35:16 +0100, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

Thank you. Some of the blur that I tried to follow seemed to
indicate the opposite. Sometimes, the Web is rather sticky.

Sincerely,

Gene Wirchenko

In microsoft.public.sqlserver.programming Gene Wirchenko <genew (AT) ocis (DOT) net> wrote:
Search VFP help for "ODBC". You should get more that enough information.
--
JS