General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Trouble opening my SQL tables in my program
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
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