Thanks all for the answers. I don't have time to try the stuff now but I know how to get started when I do. I may well come back with more questions then. Joe
On Thursday, April 25, 2013 11:28 AM, Ted Roche wrote: > >Date: Thu, 25 Apr 2013 11:28:14 -0400 >From: Ted Roche >To: [email protected] >cc: >Subject: Re: [NF] Neat scanner system info and questions > >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 >--- > [excessive quoting removed by server] _______________________________________________ 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/[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.
