[sqlite] FW: SQLite (1.0.97) access via LAN

2015-06-26 Thread Joe Mistachkin 

Takashi Fukuda wrote:
>
> string dataFile =  "PC-Name\\C\\FolderName\\data.db
>  " ;
> 
> // 
> 
> // For x32 target compilation with System.Data.SQLite-x32-1.0.97.dll
(.NET4)
> 
> // The application works fine.
> 
> //
> 
> // For x64 target compilation with System.Data.SQLite-x64-1.0.97.dll
(.NET4)
> 
> // Error message: "unable to open database file"
> 

Are you using a NuGet package?  If so, which one?  What is the processor
architecture of the machine involved?  Is there more than one machine?
What System.Data.SQLite related files are present in your "bin" directory?

--
Joe Mistachkin

[sqlite] FW: SQLite (1.0.97) access via LAN

2015-06-26 Thread Adam Devita 
What happens if you map a network drive to \\PC-Name\C\FolderName
(say drive X:) and then try to open the file as x:\data.db ?

Adam


On Thu, Jun 25, 2015 at 10:24 AM, Takashi Fukuda
 wrote:
> Donald Griggs tried to help this problem, and we looked at the Jean C's
> advice. However the problem remains. The actual codes using are as follows:
>
>
>
> ===
>
> string dataFile =  "PC-Name\\C\\FolderName\\data.db
>  " ;
>
> //
>
> // For x32 target compilation with System.Data.SQLite-x32-1.0.97.dll (.NET4)
>
> // The application works fine.
>
> //
>
> // For x64 target compilation with System.Data.SQLite-x64-1.0.97.dll (.NET4)
>
> // Error message: "unable to open database file"
>
>
>
> using (SQLiteConnection cnn = new SQLiteConnection(dataFile))
>
> using (SQLiteCommand cmd = cnn.CreateCommand()
>
> {
>
> cnn.Open();   < causing error !
>
> ===
>
>
>
> Can anybody help ?
>
>
>
> Best regards,
>
> Takashi Fukuda
>
> takashifukuda at comcast.net
>
>
>
>
>
> From: Takashi Fukuda [mailto:takashifukuda at comcast.net]
> Sent: Thursday, June 18, 2015 11:35 AM
> To: 'sqlite-users at mailinglists.sqlite.org'
> Subject: SQLite (1.0.97) access via LAN
>
>
>
> We are developing Windows applications with SQLite.dll. The current
> situation with VisualStudio-2010 is as follow:
>
>
>
> For x32 target compilation with System.Data.SQLite-x32-1.0.97.dll (.NET4)
>
> My application works fine.
>
>
>
> For x64 target compilation with System.Data.SQLite-x64-1.0.97.dll (.NET4)
>
> Error message: "unable to open database file"
>
>
>
> This problem happens when our applications access to the SQLite data file
> "data.db" via LAN, with "PC-Name\\C\\FolderName\\data.db
>  " format. The local access with
> "C:\\FolderName\\data.db" works fine. As described above, the x32 version
> works fine both local and LAN access.
>
>
>
> Best regards,
>
> Takashi Fukuda
>
> takashifukuda at comcast.net
>
>
>
>
>
> ---
> ??E ?
> http://www.avast.com
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



-- 
--
VerifEye Technologies Inc.
151 Whitehall Dr. Unit 2
Markham, ON
L3R 9T1

[sqlite] FW: SQLite (1.0.97) access via LAN

2015-06-25 Thread Takashi Fukuda 
Donald Griggs tried to help this problem, and we looked at the Jean C's
advice. However the problem remains. The actual codes using are as follows:



===

string dataFile =  "PC-Name\\C\\FolderName\\data.db
 " ;

// 

// For x32 target compilation with System.Data.SQLite-x32-1.0.97.dll (.NET4)

// The application works fine.

//

// For x64 target compilation with System.Data.SQLite-x64-1.0.97.dll (.NET4)

// Error message: "unable to open database file"



using (SQLiteConnection cnn = new SQLiteConnection(dataFile))

using (SQLiteCommand cmd = cnn.CreateCommand()

{

cnn.Open();   < causing error !

===



Can anybody help ?



Best regards,

Takashi Fukuda

takashifukuda at comcast.net





From: Takashi Fukuda [mailto:takashifuk...@comcast.net] 
Sent: Thursday, June 18, 2015 11:35 AM
To: 'sqlite-users at mailinglists.sqlite.org'
Subject: SQLite (1.0.97) access via LAN 



We are developing Windows applications with SQLite.dll. The current
situation with VisualStudio-2010 is as follow:



For x32 target compilation with System.Data.SQLite-x32-1.0.97.dll (.NET4)

My application works fine.



For x64 target compilation with System.Data.SQLite-x64-1.0.97.dll (.NET4)

Error message: "unable to open database file"



This problem happens when our applications access to the SQLite data file
"data.db" via LAN, with "PC-Name\\C\\FolderName\\data.db
 " format. The local access with
"C:\\FolderName\\data.db" works fine. As described above, the x32 version
works fine both local and LAN access.



Best regards,

Takashi Fukuda

takashifukuda at comcast.net





---
??E ?
http://www.avast.com