Prev: using Ms OutlookView
Next: VO Beginner: how to use Oracle with VO 2.6?
From: Meinhard Schnoor-Matriciani on 13 Oct 2006 10:23
Geoff,

I have no clue what you're talking about, neither I see any relation to my
reply to Geoff Chambers. Take a break.

Meinhard


From: Geoff on 13 Oct 2006 21:56
Meinhard,

Sorry. When you wrote 'are you allowed to modify these databases ?' I
thought you were questioning my suggestion to use the available
mechanism of SetRelation in VO2Ado servers. This solves Geoff's original
problem quite neatly.

Geoff



"Meinhard Schnoor-Matriciani" <meinhard(a)appfact.de> wrote in message
news:452fbb4e_2(a)news.arcor-ip.de:

> Geoff,
>
> I have no clue what you're talking about, neither I see any relation to my
> reply to Geoff Chambers. Take a break.
>
> Meinhard

From: Geoff Chambers on 14 Oct 2006 15:11
I get the following error

The OLE DB provider ASAProv.90 for linked server "test" returned an
invalid schema definition


Meinhard Schnoor-Matriciani wrote:
> Hi Geoff,
>
> ok, so here we go. I have the german version of sql express installed, so
> hopefully I am using the right translations. First of all,
> if not yet done, get yourself a copy of Microsofts SQL Server Management
> Studio Express. Then go ahead, start it and choose your database.
> In the tree you have database, security , server objects , replication and
> management. Click on >>server objects<< and expand it. Then you
> should see backup media, linked server and server trigger, or something
> similar ( as I said I only have the german version ... ). Now right
> click on linked server ( the second node ) and choose new linked server.
> You'll get a dialog window where you can define a linked server
> with all information neccessary to make your other database server
> accessible to your SQL Express engine. Let's say your SQL Engine is
> installed
> on Machine SQLExpress and the name of your just defined linked server is
> SQLAnywhere, then you're able to access the tables inside your SQL Anywhere
> database by simply qualifying the table with the name of the linked server.
> Here are some samples ( you can test this from the Management Studio
> by open the database node and right clicking one of the databases and choose
> new query ) :
>
> select * from SQLAnywhere..dba.employee -- accessing the
> employee table in the asademo
>
> select * from SQLServer2000.Northwind.dbo.Employees -- accessing the
> employee table in the northwind sample database on an SQL Server 2000
> installation
>
> Watch out for the .. in the frist sample. This is neccessary because
> Anywhere does know the concept of database qualification.
>
> Now after you've done the, you can do things like
>
> create view MixedAccess
> select *
> from SQLServer2000.Northwind.dbo.Employees as Emp1
> join SQLAnywhere..dba.employee as Emp2 on
> Emp1.EmployeeID = Emp2.Emp_id
>
> go
>
> select * from mixedaccess
>
>
> This would work with all kind of databases which can be access by the
> machine where SQL Express is running on, as long as you have the neccessary
> driver installed. We constructed a datawarehouse for a large customer, where
> we're using this technique to access different databases : Oracle, AS
> 400/DB2
> Informix, MySQL, ADS and even Excel or DBF. Works like a charme.
>
> Regards,
> Meinhard

From: Meinhard Schnoor-Matriciani on 15 Oct 2006 05:41
Can you tell me in detail what you've done ? I've just tested it and had no
problems.


From: Meinhard Schnoor-Matriciani on 15 Oct 2006 05:49
Me again ;-)

I just read that there have been some fixes in this area, do you have the
latest EBF's installed ?

Regards
Meinhard


First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: using Ms OutlookView
Next: VO Beginner: how to use Oracle with VO 2.6?