Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE Installation
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00830397
Message ID:
00830502
Views:
32
Well, not sure

In the book I mentioned previouslyt, I'm in Chapter 4, Remote Views.

The book walks me through setting up a connection to Northwind, yet in the ODBC
Dialog, when I get to the database combo, under the "Change the default database to"
checkbox, Northwind is not in the list.

In the list are:
master
model
msdb
tempdb


In the book, they have Northwind selected. It's not there on mine.

They then list the following code:
CREATE DATABASE Northwind

CREATE SQL VIEW VCustomers;
	REMOTE CONNECTION NOrthwind;
	AS SELECT * FROM Customers

USE VCustomers
BROWSE
If I select the default database ('master') above, and run this code
anyhow, I get an error "Invalid object name 'Customers'. So, either the DB
is not there, or I did something wrong.

One other note:
On the page of the ODBC dialog where it deals with authenticity, if I select
"With SQL Server authenticity...", I get the error:

Connection Failed
SQLState '28000'
SQL Server Error: 18452
[Microsoft][OSBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason:
Not associated with a trusted SQL Server connection.

So I used "With Windows NT authenticity..."

And I thought this was supposed to be easy?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform