For some reason I'm unable to connect to the database. I even attempted the to handle the connection string using the following:
mystring="DATABASE=vfp2pg;SERVER=www.smvfp.com; port=5432;UID=VfP2Pg;pwd=HelloWorld;provider=MSDASQLR;DRIVER=postgreSQL;"
oConnection=SQLSTRINGCONNECT(mystring)
oConnection always = -1
Did you get SQLTABLES working. I'm able to work around the problem by creating my own replacement for SQLTABLES but would like figure out how to use foxpro's function.
Also can you create tables or databases using the VFP?
John
John Fabiani
Woodland, CA