On Fri, 17 Aug 2007 11:28:57 -0700, Mike <mikm524@[EMAIL PROTECTED]
> wrote:
>I dont know which version. At this time we dont have a sql server
>database.
>
>At this time we are looking for more information. With time, I think,
>my boss wants to switch over from VFP database to SQL server.
best to get msde and instlal it (free) -- it's a scaled down version of
sql
server -- I find msde easier to use than sql Express (sql2005's version of
the
desktop/free version)
then you can connect using dsn's (there's even a northwnd database you can
attach to!) or if you get inspired, use dsn-less connections.
If you think of vfp as two parts --
the front end
the back end database
you're just switching out the back end database part.
msde is good if you may go with sql server but if you're not going to go
swith
sql server, mysql is more readialy available; and then I can recommend a
book:
http://www.hentzenwerke.com/catalog/mysqlvfp.htm
I haven't read it -- but i fyou don't currently use sql to update data,
this
might be a good read:
http://www.hentzenwerke.com/catalog/tamingvfpsql.htm
I like all their books -- all well done by vfp'ers for vfpers (you should
recognize some of the regular posters as authors and editors)
while catering to older version of mssql - most of this should still be
valid
>http://www.hentzenwerke.com/catalog/csvfp.htm
if you're looking for books catering to vfp & sql -- you find any that are
better writen and designed around someone familar with vfp
-j
|
