我试图从C＃.NET调用foxpro存储过程 [英] I'm trying to call a foxpro stored procedure from C#.NET

问题描述

我收到此错误

错误[42000] [Microsoft] [ODBC Visual FoxPro驱动程序]语法错误或访问冲突

 using（OdbcConnection conn = new OdbcConnection（constants.connetionStringRetailBodega580））{
 conn.Open（）; 
 var result = new object [1]; 
 string sqlProcedure =" {call stkdisponible（）}" ;; 
 
 System.Data.Odbc.OdbcDataAdapter da = new OdbcDataAdapter（）; 
 
 
 da.SelectCommand = conn.CreateCommand（）; 
 da.SelectCommand.CommandType = CommandType.StoredProcedure; 
 da.SelectCommand.CommandText = sqlProcedure; 
 
 OdbcDataReader dr = da.SelectCommand.ExecuteReader（）; 
 // OdbcDataReader dr = cmd.ExecuteReader（）; 
 
 ............ 
 ........... 
} 

解决方案

我不确定它是否有帮助，但尝试使用OleDb而不是ODBC。并且，请查看正确的连接字符串：

https ：//www.connectionstrings.com/dbf-foxpro/

I'm getting this error

ERROR [42000] [Microsoft][ODBC Visual FoxPro Driver]Syntax error or access violation

using(OdbcConnection conn = new OdbcConnection (constants.connetionStringRetailBodega580)) {
                        conn.Open ();
                        var result = new object[1];
                        string sqlProcedure = "{call stkdisponible()}";

                        System.Data.Odbc.OdbcDataAdapter da = new OdbcDataAdapter ();


                        da.SelectCommand = conn.CreateCommand ();
                        da.SelectCommand.CommandType = CommandType.StoredProcedure;
                        da.SelectCommand.CommandText = sqlProcedure;

                        OdbcDataReader dr = da.SelectCommand.ExecuteReader ();
                        //OdbcDataReader dr = cmd.ExecuteReader ();

............
...........
}

解决方案

I'm not sure whether it will help or not, but try using OleDb instead of ODBC. And, take a look here for the proper Connection Strings:

https://www.connectionstrings.com/dbf-foxpro/

这篇关于我试图从C＃.NET调用foxpro存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！