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?


Thanks