[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Re: DotNet, Informix, Merant, DataDirect (Resolved)

Steve Schroeder

10/14/2002 8:28:00 PM

Actually, the solution is false. From the .Net Framework Help on
SqlConnection Class:

A SqlConnection object represents a unique session to a SQL Server data
source. In the case of a client/server database system, it is equivalent to
a network connection to the server. SqlConnection is used in conjunction
with SqlDataAdapter and SqlCommand to increase performance when connecting
to a Microsoft SQL Server database. For all third-party SQL server products,
as well as other OLE DB-supported data sources, use OleDbConnection.

So..the issue still exists. If anyone has any ideas, please post. I've also
contacted the vendor, Merant.

Thanks

"Steve Schroeder" <sschroeder@merchant-gould.com> wrote in message news:...
> Actually, this is resolved, see bottom of message for solution.
>
> ******************
> Trying to make an ODBC Connection to Informix using the DataDirect
4.0.0.00
> driver version (thru Microsoft OLE DB Provider for ODBC). See attached
> screen shot image.
> I get this message when trying to save the connection string property on a
> Web Form in a .Net Webservice Project.
>
> Error message:
>
> "The .Net Data OLE DB Provider(System.Data.OleDb) does not support the
> MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers."
>
> Now I did a search and there are recommendations to install the latest
.Net
> ODBC drivers...which I did. Got them from here:
>
>
http://www.microsoft.com/downloads/release.asp?ReleaseID=35715&area=se...
> rdinal=3
>
> Unfortuantely that appears to do nothing to resolve the error.
>
> I did an ODBC trace at the point of saving the ODBC string, and found the
> following:
>
> DIAG [01004] [Microsoft][ODBC Driver Manager] Data truncated (0)
>
> DIAG [01004] [MERANT][ODBC Informix driver]String data, right
truncated.
> (0)
>
> That led me to an semi-offical descripption of the error code 01004: The
> buffer *OutStatementText was not large enough to return the entire SQL
> string, so the SQL string was truncated. The length of the untruncated SQL
> string is returned in *TextLength2Ptr. (Function returns
> SQL_SUCCESS_WITH_INFO.)
>
> So, it's clear the buffer is not large enough to hold the commplete
> connection string.
> ******************
>
> Solution:
>
> In the desgin view of a web form, vb form, etc use the connection object
> from the Data panel titled: SqlConnection, as opposed to OleDbConnection
>
>
> Steve Schroeder
>
>