Hi Wong,

If the right files are already installed on the client machine, an ODBC
connection is nothing more that a couple of registry settings so if that
makes it easy, you can take a look at that.
Some installation programs, I'm pretty sure Installshield-Express does, can
make the settings etc. for you.
At last but not least you can make a connection without the ODBC settings...

lcSrcFile1 = lcSrcDir + [XXXXXX.MDB]

lcConnectString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" +
lcSrcFile1 + ";UID=xxxxx; PWD=xxxxx"
lnHandle = SQLSTRINGCONNECT(lcConnectString)

IF lnHandle > 0
  SQLSETPROP(lnHandle,"BatchMode",.t.)
  SQLSETPROP(lnHandle,"Asynchronous",.f.)

 SQLEXEC(lnHandle, "SELECT * FROM Inventory", "Source")
  SQLDISCONNECT(lnHandle)
 ENDIF

Hth,

Gerben Kessen

connection of sql server.

I do not need to set the data sources for each machine?

Hi W. Wong:

Take a look at this article and see if it helps:

155392 How To Creating a Connection to SQL Server Without a Datasource
http://support.microsoft.com/?id=155392

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/   

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
  http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
  http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
  - VFP5 Mainstream Support retired June 30th, 2003
  - VFP6 Mainstream Support retired Sept. 30th, 2003

you can use either use sqlstringconnect() or call SQLConfigDataSource API

connection of sql server.

I do not need to set the data sources for each machine?

HEya W.
you can also make a vb script object that will stuff the keyboard in the
right places , emulating a manual system dsn creation.
taking this a step further, you can encapsulate the Windows Scripting Host
in VFP 8 and
do the same thing.

Others have mentioned using a sqlstringconnect - i'm a big fan of it as
well.
hth - mondo regards [Bill]

--
William Sanders / Electronic Filing Group  Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

connection of sql server.

I do not need to set the data sources for each machine?