Connecting to SQL Server 2008 Express Databases from Visual FoxPro 9

#21

In microsoft.public.sqlserver.programming Gene Wirchenko <genew (AT) ocis (DOT) net> wrote:

Quote:

On Wed, 23 Mar 2011 12:27:18 +0100, Henk van den Berg
hvandenberg (AT) xs4all (DOT) nl> wrote:

On 21-03-2011 05:40, Gene Wirchenko wrote:

What info are you missing?

Error trapping.

How to suppress SS popping up for more data on an error. I would
like to handle these errors programmatically, even if only an error
message.

So what's the latest status? Did you get your problem solved? Or do you
still need pointers to solutions?

Not yet. I have been busy on another job these past few days.

I could still use some pointers. At this point, I would really
prefer pointers rather than answers here. A simple but non-trivial
example that uses many of the features of ODBC would be great.

Failing that, a list of the statements and functions that I need
to know so I can go reading would be useful. (It is sometimes hard to
figure out which ones those are.)

OK. This is about the most simple sample that I know of.
http://fox.wikis.com/wc.dll?Wiki~Bet...QLServer~VF P
--
JS

#22

On 3/11/2011 3:16 PM, Gene Wirchenko wrote:

Quote:

Dear SQLers:

The subject about says it all. How do I do this?

My SQL Server 2008 Express system is LOOP\SQLEXPRESS.

Apparently, I should create an ODBC connection. I have no idea
how to do this.

If you only know the SQL Server side, please reply with that
side. That is more than what I know.

Sincerely,

Gene Wirchenko

It's been a while... let's see what I remember.

In the Administrative Tools control panel, create a system ODBC source
and point it at the SQL server and database you're interested in.

Then in your FoxPro database, create a connection and point it to that
ODBC source. When you create remote views, use that connection.

Alternatively, skip the ODBC source and create a connection in the
FoxPro database using a connection string.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Connecting to SQL Server 2008 Express Databases from Visual FoxPro 9

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: Connecting to SQL Server 2008 Express Databases from Visual FoxPro 9 - 03-24-2011 , 05:54 AM

Re: Connecting to SQL Server 2008 Express Databases from Visual FoxPro9 - 03-27-2011 , 11:10 PM