Hi,

Is it possible in VFP 9 - to query data from MS SQL using OLE DB?
Today we hold data in MS SQL and use ODBC to connect:
DRIVER=SQL
Server;SERVER=CompName\SQLEXPRESS;UID=Somebody;PWD=XXXX;APP=Microsoft® Visual
FoxPro®;WSID=MyCompName;DATABASE=RapidPlus;Trusted_Connection=No

They say, that OLE DB is newer and better? Is it so?

Thanks in advance,
Rein

software used :sqlserver 2000 SP4,vb sp6
The follwing code works fine for select and update accordingly.

I need to know if there is a single sql query to do both together i.e.
select and update as a single query and not like two sql statements as below.

SQL = "SELECT SUM(d.FreeSampleQty) FreeSampleQty, p.Itempackage,
p.PromotionID "
SQL = SQL & "FROM InvoiceDetail d, ItemMaster i, t_BulkPromotionDetail p "
SQL = SQL & "Where d.ItemCode = i.ActualItemCode And p.ItemPackage =
i.PackageCode And IsNumeric(d.CoopID) = 1 "
SQL = SQL & "And d.CoopID = p.PromotionId group by p.Itempackage,
p.PromotionID"
Set rsTemp = mainDb.Execute(SQL)

commander acomplia en France en ligne
acheter acomplia commander en ligne
acheter acomplia generique
acomplia suisse par email
acomplia belgique soft en ligne

jamba videos fuer handy kostenlos
jamba videos in handy format umwandeln
witzige jamba handy videos
jamba handy video abspielen
jamba handy video party

+
+
+
+ + + JAMBA HANDY VIDEOS + + + JAMBA HANDY VIDEOS + + +
http://jhku.net/JAMBA-HANDY-VIDEOS/
http://jhku.net/JAMBA-HANDY-VIDEOS/
http://jhku.net/JAMBA-HANDY-VIDEOS/
+
+
+ + + JAMBA HANDY...

acheter acomplia canada concernées par cette
acheter du acomplia canada cinq
Acheter acomplia canada en ligne sur internet
comprimes de acomplia en France
commander acomplia us usa en ligne

acheter lipitor suisse sans ordonnance
generique pharmacie us usa
acheter lipitor canada bon marche en linge
comprimes de acheter lipitor
acheter lipitor canada bon marche en linge

+++ Cholest

Hi All

I am making odbc connection to Tally Software from VFP

However while trying to retrieve information on following columns the data
returned is zero or null.

45 __OPENINGBALANCE_ B 8 2

46 __NAME_ M

Data which is return as null is ok however there are values which are
negative or positive but those are returned as 0.00 how can I get correct
data

While trying to fetch data with Excel it gives correct information

Regards

Samir