General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I dont know what you are trying to do, is this an operation that needs to carried out more than once, if so look at hooking in the MDB as a linked server this will allow you to access it more easily than the OPENROWSET. If the Openrowset doesnt work directly look at puttin it into an SQL SP to and then call that.
Also you could look at ADO, something like..
loconnection = createobject("adodb.connection")
loconnection.open("DBQ=g:\products\ppwin\dev32\data\test2.mdb;DefaultDir=g:\products\ppwin\dev32\data\test2.mdb;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;PWD=619238")
>Hi Jon,
>
>I've tried the OPENROWSET of SQL and it worked!... I tried it in query analyzer but could'nt make it work in vfp.
>
>I've tried using sqlexec but won't work. Please help...
>
>Thanks in advance...
Previous
Next
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