On Thu, Apr 25, 2013 at 10:43 AM, Joe Yoder <[email protected]> wrote:
> Finally - how do I get started talking directly to the Neat SQL server? > You need to create a connection, a handle, that FoxPro would use. The easiest way when starting out, is to create a System DSN using the built-in ODBC tools. It should have a Test button built into the ODBC Administrator to confirm you've configured it correctly. Later, you may find you want to use connection strings and Adaptors and all sorts of cool tools, but they just get in the way to start out with. The specifics of how to create a DSN depend on which OS you are running, and whether it's 32- or 64-bit. You'll need to have a 32-bit ODBC driver for SQL Server installed. It's likely Neat has already done that, although not certain. Once you've created the DSN, use the DSN name to connect to the server in FoxPro. lnConnect = SQLConnect(cMyDSNName) if lnConnect is a positive integer, you're connected. aData = ADATABASES(lnConnect) && returns a list of databases There's a lot of material on the internet on how to do this. Searching on "FoxPro Client Server" returns such useful links as the manual on your computer, in the help file: http://msdn.microsoft.com/en-us/library/aa690493(v=vs.71).aspx If you read through the basics in that set of topics, it should give you the essentials you need. Please ask some more specific questions if you run into trouble. In addition, there's a load of topics on the Fox Wiki, http://fox.wikis.com And there's more than one great book from Hentzenwerke http://www.hentzenwerke.com -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4vM9FDxbrOvupvrA_zQVdJaJbWkgC9=xdzkGG4k4jc=o...@mail.gmail.com ** 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.
