ODBC Problem

rosmiq
11-15-2006, 03:55 AM
Hi,

Really hoping somebody can help me, I've looked everywhere for this error but not having any luck.

I am creating an ASP.NET application using Visual Studio 2003 and I am connecting to a Vortex Database using ODBC. This program runs fine locally on my laptop but when I publish onto the web server i get the following error..



ERROR [S1000] [TOD][ODBC Driver]DLLLOAD: VTX3, The specified module could not be found. ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [S1000] [TOD][ODBC Driver]DLLLOAD: VTX3, The specified module could not be found. ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[OdbcException: ERROR [S1000] [TOD][ODBC Driver]DLLLOAD: VTX3, The specified module could not be found.

ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).]
System.Data.Odbc.OdbcConnection.Open() +638
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
RR.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\RR\WebForm1.aspx.vb:400
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

Has anybody seen this error before?

ODBC drivers are installed on the webserver, I have tested connection is ok to database by using MSQuery via Excel and it connects fine.

Please can somebody help?

Thank you,
rosmiq

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum