Can you show me the code to browse a specific table (or select * from MyTable)
OConn is an object with properties so the code below seems to work. In this dbc
there is a table named m6nmpt.dbf and a view to
look at all the data named vnmpt (the view has the same data you would get
from select * from m6nmpt). Even better, is there a
reference for working with oledb in vfp9 sp2? the Microsoft site has a lot of
information, but it is very superficial and never
(at least I can't find it) shows the code for accessing/updating data.
OConn = CREATEOBJECT("ADODB.Connection")
OConn.ConnectionString = "provider=vfpoledb.1;data
source=U:\ssi\304901\Share\ptshare.dbc"
OConn.Open
----- Original Message -----
From: "Stephen Russell" <[EMAIL PROTECTED]>
To: "ProFox Email List" <[email protected]>
Sent: Friday, April 04, 2008 6:49 AM
Subject: Re: SQL Passthrough and ODBC
On Thu, Apr 3, 2008 at 4:49 PM, Jeff Johnson <[EMAIL PROTECTED]> wrote:
> I just received a question from a dba and I think I know the answer, but
> I really need to make sure. I am accessing MSSQL Server tables using
> SQL passthrough in VFP. I use SQLSTRINGCONNECT() and then send a select
> statement with SQLEXEC. They are moving from SQL2000 to SQL2005 and
> wanted to know if I used any ODBC drivers. I don't think so, but I
> wanted to check with the experts to make sure.
>
-----------------------------------------------------------------------------
www.connectionstrings.com is the best reference for how to use just about
EVERY data source known.
--
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN
901.246-0159
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
