General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Accessing data from SQL 2005
Hello, i ported my data from foxpro to mysql 2005
created a few remote views but when i try to access the data in SQL using
USE datamain!useracesscon
(datamain being the name of the foxpro database)
(but Sqlmain being the name of the SQL dataase)
it says useracesscon.dbf isnt found and useracesscon is a remote view IN datamain.
and when i checked the syntax it says database then sQl view
but when i run the form it tells me it cant find useracesscon.dbf and its not a dbf its a remote view
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only