Re: Sorting a dataview Numerically

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi!

> I use Microsoft.Jet.OleDB.4.0 to connect with Microsoft Access 2003.

Well, I don't use Access, so I can't check your query... Please try to
execute the query directly under Access.

> I'm not using SQL Server. Does this make a difference with entering
> Transact SQL in .NET?

No, it should not... but you never know with M$.
BTW: you don't have to buy SQL Server to use it: see MSDE - it's SQL
Server engine you can downlaod and use for _free_. There may be some
license restrictions (number of simultaneous connections to database) and
there's no administration tool (as far I know, you can download some free
solutions or 'administrate' the DB from Visual Studio).

> This is the query I use in .Net is:
>
> Dim dbAdapter as New OleDb.OledbAdapter("SELECT * FROM tblISSUE_LIST
> ORDER BY
> CAST(SUBSTRING(tblISSUE_LIST.[Issue_No],2,Len(tblISSUE_LIST.[Issue
> No])-1)) AS INT);",
> Me.oledbConnection1)
> Me.IssueDataSet1
> MyDataTable = Me.IssueDataSet1.Tables(0) dbAdapter.Fill(MyDataTable) dv
> = Me.DataSet1.DefaultViewManager.CreateDataView(myDataTable) . . .

You can try to give columns explicite, not 'select * ...'. It's just a
thought.

> Error occurs when filling the data table to the data adapter. Error is:
> IErrorInfo.GetDescription failed with E_FAIL(0*80004005).

Tricky one, MS SDK says nothing about this one, it seems like it's 'vendor
specific' - I guess it's because Access fails to undrestand the query.

Cheers,
Piotrek

.

Relevant Pages

  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Indexing Service, Openquery and sp_executesql
    ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problem using Access or Query Designer to run queries in SQL Serve
    ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
    (microsoft.public.sqlserver.odbc)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)