I succeeded in creating a SQL Server 2012 instance on Azure and uploaded two "living"databases that currently run in lan under SQL Server 2012 Express I can connect from VFP to the AZURE SQL Server, read records from a table and add new records to it
However, this does not work: select c.account,c.company,s.salesman,s.commission from database_1.dbo.customers c join database_2.dbo.salesmen s on c.salesrep = s.code I get the following error message: Mens. 40515, Nivel 15, Estado 1, Línea 16 Reference to database and/or server name in 'database_1.dbo.customers' is not supported in this version of SQL Server. Apparently, the AZURE SQL Server cannot retrieve data from two different databases in the same select statement. Both databases reside in the same instance of SQL Server. Database_2 contains "confidential" data, such as managers's salaries, salesmen's commissions and the like Is this so, or I am making some stupid mistake? How can I solve it? Pamechu Umgobwe _______________________________________________ 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.
