>Hello Community.
>
>I recently changed my tables in a program from foxpro to sql 2005 (upsized them)
>
>while i can create remote views fine an all im trying to convert this piece of class code
>
>it used to be
>
>USE datamain.dbc!useracess.dbf
>
>but that cannot work cause im trying to get rid of .dbf
>
>so im trying to use
>
>Handle = SQLStringConnect ("driver={SQL Server};server=HP6PQ8\SQLEXPRESS;database=MYDATA;pwd=;uid=;")
>
>
>USE Datamaia!dbo.useracess.USERACESS CONNSTRING handle
>
>this new code tells me it cannot find "dbo.useracess.USERACESS" in the path of my foxpro program.
>
>1) not sure why thats the path its looking for, shouldnt the connection string deal with the path?
You can't use the USE command with tables on a server. You have to send commands to the server to bring the data into local cursors. For example, if you want to bring the entire UserAccess table into a local cursor (which isn't really a good idea unless the table is quite small), you'd do something like:
IF SQLExec(m.Handle, "SELECT * FROM UserAccess", "UserAccess")
ELSE
ENDIF
Tamar