bug: attached databases

pniklaus · Post by **pniklaus** » Thu 29 Apr 2010 10:50

using dotconnect 2.80 with VS2008, i tried to attach a 2nd database but it seems to be impossible read the sqlite_master - table of the attached DB.

ErrorCode=-2147467259
Message=[b]"2nd parameter to sqlite3_bind() out of range bind or column index out of range"[/b]

i attached the DB two ways, via connectionstringbuilder.attach="..." and directly via SQL.
"pragma database_list" shows the db, reading other tables causes no problems.

SQL to read sqlite_master has been tested on 3d Party SQLite tools, too.
"SELECT * FROM upd.sqlite_master"

so what's about that ?

Peter

to whom it may concern:

Devart.Data.SQLite.SQLiteException wurde nicht behandelt.
ErrorCode=-2147467259
Message="2nd parameter to sqlite3_bind() out of range bind or column index out of range"
Source="Devart.Data.SQLite"
StackTrace:
bei Devart.Data.SQLite.a3.a(bt A_0, Int32 A_1, String A_2) bei Devart.Data.SQLite.bt.a(Int32 A_0, SQLiteParameter A_1) bei Devart.Data.SQLite.bt.c() bei Devart.Data.SQLite.p.j() bei Devart.Data.SQLite.SQLiteDataReader.c() bei Devart.Data.SQLite.SQLiteCommand.InternalExecute(CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords) bei Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) bei Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) bei Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) bei System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) bei Devart.Data.SQLite.SQLiteCommand.ExecuteReader() bei BLE.Helper.Data.DBUpdater.updateDB() bei BLE.frmBW2010.mnOpen_Click(Object sender, EventArgs e) bei System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) bei System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e) bei System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) bei System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) bei System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met) bei System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met) bei System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) bei System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea) bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) bei System.Windows.Forms.Control.WndProc(Message& m) bei System.Windows.Forms.ScrollableControl.WndProc(Message& m) bei System.Windows.Forms.ToolStrip.WndProc(Message& m) bei System.Windows.Forms.ToolStripDropDown.WndProc(Message& m) bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) bei System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) bei System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) bei System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) bei System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) bei System.Windows.Forms.Application.Run(Form mainForm) bei BLE.clsMain.Main(String[] args) bei System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) bei System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) bei Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() bei System.Threading.ThreadHelper.ThreadStart_Context(Object state) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) bei System.Threading.ThreadHelper.ThreadStart()
InnerException:

StanislavK · Post by **StanislavK** » Fri 30 Apr 2010 14:13

I've send you a test project, please check that it was not blocked by your mail filter. Please specify what needs to be changed in it or send us a sample with which the problem can be reproduced. At the moment, we couldn't reproduce it.