none
無法配置環境控制代碼 RRS feed

  • 問題

  • 請問

    我原本在vs2003(vb.net)中透過odbc去取得informix的資料, 這裡是ok的

    但將程式移至vs2005卻發生"無法配置環境控制代碼"的錯誤訊息

    以下為2005內的程式碼

            Dim strConn As String = Me.TextBox1.Text.Trim
            Dim str As String = "DSN=test"
            Dim Conn As New Odbc.OdbcConnection(str)

            Dim da As New Odbc.OdbcDataAdapter(strConn, Conn)
            Dim ds As New DataSet
            da.Fill(ds)
            Me.DataGridView1.DataSource = ds.Tables(0)

    請問那裡有問題呢????

    2007年1月22日 上午 05:48

解答


  • For this issue, it may be caused by the ODBC error. Please follow the KB article 274551 to enable the ODBC trace for case troubleshooting.http://support.microsoft.com/kb/274551/en-us
    You can refer to the kb article 139655 to learn how to read the ODBC trace log file.
    http://support.microsoft.com/kb/139655/EN-US/

    Reminding: The ODBC trace will slow the performance and Consume All Space. Please disable it after you finish the troubleshooting.

    Otherwise to connect to Informix database, you also can use Informix provider which is included in Informix
    Client Software Developer's Kit (SDK) by IBM. Here is an article about How to
    connect to Informix with ADO.NET.
    http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0510durity/

    The IBM Informix .NET Provider is a .NET assembly that lets .NET applications access and manipulate data in IBM Informix databases. It does this by implementing several interfaces in the Microsoft .NET Framework that are used to access data from a database.

    Using the IBM Informix .NET Provider is more efficient than accessing the an IBM Informix database through either of these two methods:

    1.) Using the Microsoft .NET Framework Data Provider for ODBC along with the IBM Informix ODBC Driver 
    2.) Using the Microsoft .NET Framework Data Provider for OLE DB along with the IBM Informix OLE DB Provider

    Supported databases

    You can use IBM Informix .NET Provider to connect to these database servers: 
    1.) IBM Informix Dynamic Server (IDS) Version 7.31 and higher, Version 9.x, and Version 10.x.
    2.) IBM Informix Extended Parallel Server (XPS) Version 8.4 and higher.

    Supported programming environments

    The IBM Informix .NET Provider can be used by any application that can be executed by the Microsoft .NET Framework. Here are some examples of programming languages that create applications that meet this criteria:

    Visual BASIC .NET
    Visual C# .NET
    Visual J# .NET
    ASP.NET

    The IBM Informix .NET Provider runs on all Microsoft Windows platforms that provide full .NET support.
    You must have the Microsoft .NET Framework SDK, Version 1.1, or later, installed on your machine. You must have Version 2.90, or later, of the IBM Informix Client SDK installed.
     

    2007年4月11日 上午 11:27

所有回覆

  • Hi,

    可以請您提供您的聯絡用email嗎?

    2007年3月21日 上午 07:10
  • ok 呀

    2007年3月22日 上午 02:00

  • For this issue, it may be caused by the ODBC error. Please follow the KB article 274551 to enable the ODBC trace for case troubleshooting.http://support.microsoft.com/kb/274551/en-us
    You can refer to the kb article 139655 to learn how to read the ODBC trace log file.
    http://support.microsoft.com/kb/139655/EN-US/

    Reminding: The ODBC trace will slow the performance and Consume All Space. Please disable it after you finish the troubleshooting.

    Otherwise to connect to Informix database, you also can use Informix provider which is included in Informix
    Client Software Developer's Kit (SDK) by IBM. Here is an article about How to
    connect to Informix with ADO.NET.
    http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0510durity/

    The IBM Informix .NET Provider is a .NET assembly that lets .NET applications access and manipulate data in IBM Informix databases. It does this by implementing several interfaces in the Microsoft .NET Framework that are used to access data from a database.

    Using the IBM Informix .NET Provider is more efficient than accessing the an IBM Informix database through either of these two methods:

    1.) Using the Microsoft .NET Framework Data Provider for ODBC along with the IBM Informix ODBC Driver 
    2.) Using the Microsoft .NET Framework Data Provider for OLE DB along with the IBM Informix OLE DB Provider

    Supported databases

    You can use IBM Informix .NET Provider to connect to these database servers: 
    1.) IBM Informix Dynamic Server (IDS) Version 7.31 and higher, Version 9.x, and Version 10.x.
    2.) IBM Informix Extended Parallel Server (XPS) Version 8.4 and higher.

    Supported programming environments

    The IBM Informix .NET Provider can be used by any application that can be executed by the Microsoft .NET Framework. Here are some examples of programming languages that create applications that meet this criteria:

    Visual BASIC .NET
    Visual C# .NET
    Visual J# .NET
    ASP.NET

    The IBM Informix .NET Provider runs on all Microsoft Windows platforms that provide full .NET support.
    You must have the Microsoft .NET Framework SDK, Version 1.1, or later, installed on your machine. You must have Version 2.90, or later, of the IBM Informix Client SDK installed.
     

    2007年4月11日 上午 11:27