关于ODBC

[KAMCHIHAU]

$str = "DRIVER={Microsoft Visual FoxPro Driver}; SourceType=dbf; SourceDB=d:\vfpdata";
$conn = odbc_connect($str,"","") or die ("cannot connect to data source");
//到上边还通过
$rs = odbc_do($conn,"SELECT * from table1") or die ("somethings wrongs1");
//到这里就SOMETHINGS WRONGS1;
$rs = odbc_do($conn,"SELECT * from table1.dbf") or die ("somethings wrongs1");
//就算这样都不通过

[敦厚的曹操]

as=' ======================================================================='+CHR(13)+CHR(13)+CHR(13)+CHR(13)+;
' ★★ 系统正在检查网络及远程数据库的连接是否正常，请耐心等候... ★★'+CHR(13)+CHR(13)+CHR(13)+CHR(13)+;
' ========================================================================'

WAIT windows as NOWAIT noclear

*---------------------------------------------------------------------------------- \\ 设置数据库变量和系统环境

PUBLIC GNMYLOGHANDLE&&,connect_temp,Server_temp,uid_temp,Pwd_temp,Database_temp
Sqlsetprop(0,"displogin",3) &&设置环境为：从不显示ODBC登陆对话框
Driver_temp="Sql Server"
* ---------------------------------------------------------------------------------- \\ 赋值变量

Server_temp='Server' && sql服务器名称 sql2005如果有实例要：server\sql2005
Uid_temp='sa' && 数据库用户名
Pwd_temp='126' && 密码
Database_temp='zc' && 数据库名称

*----------------------------------------------------------------------------------- \\ 建立连接变量

connect_temp="driver="+driver_temp+";server="+server_temp+";uid="+uid_temp+";pwd="+pwd_temp+";database="+database_temp
GNMYLOGHANDLE=sqlstringconnect(connect_temp)
IF GNMYLOGHANDLE<=0
MESSAGEBOX(connect_temp)
MESSAGEBOX('网络连接出现故障，请检查本机或远程服务器的网络故障原因！错误连接内容如下：'+CHR(13)+'（'+cennect_temp+'）',48,'众成软件提醒您！')
CLEAR EVENTS
QUIT
ENDIF

WAIT clear

[wwwwb]

提示什么，安装VFP9的OLEDB连接试试

http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en

Provider=VFPOLEDB.1;Data Source=r:\temp;Password="";Collating Sequence=MACHINE

[十豆三]

用oledb for vfp(如9.0 Microsoft OLE DB Provider for Visual FoxPro 9.0)连接,可支持vfp的大部分命令
不是oledb for odbc

oledb for vfp下载地址：
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=14839

Version: 1.2
Date Published: 5/16/2008
Language: English

File Name Size
vfpoledb.msm 829 KB
VFPOLEDBSetup.msi 1.0 MB (安装此项)

安装完oledb for vfp后，建一ado连接，选oledb for vfp,如果是数据库，连接到数据库，如果是自由表，连接到自由表所在目录,然后建一ado command或用ado连接的execute方法

[KAMCHIHAU]

$str = "DRIVER={Microsoft Visual FoxPro Driver}; SourceType=dbf; SourceDB=d:\\vfpdata ;";

连接字符串中要用双杠//分目录