Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #81205 > unrolled thread

Re: *.sdf database access

Started byNikhil Joshi <nyjoshi@gmail.com>
First post2014-11-21 05:59 -0800
Last post2014-11-21 05:59 -0800
Articles 1 — 1 participant

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.


Contents

  Re: *.sdf database access Nikhil Joshi <nyjoshi@gmail.com> - 2014-11-21 05:59 -0800

#81205 — Re: *.sdf database access

FromNikhil Joshi <nyjoshi@gmail.com>
Date2014-11-21 05:59 -0800
SubjectRe: *.sdf database access
Message-ID<91bac545-c0f7-47b4-ad78-ee5340d0b55e@googlegroups.com>
On Saturday, April 21, 2012 6:55:55 AM UTC-4, Alex Willmer wrote:
> On Apr 19, 9:18 pm, Page3D <pag...@gmail.com> wrote:
> > Hi, I am trying to connect and access data in a *.sdf file on Win7
> > system using Python 2.7. I have three questions:
> >
> > 1. What python module should I use? I have looked at sqlite3 and
> > pyodbc. However, I can seem to get the connection to the database file
> > setup properly.
> 
> I assume you mean SQL Server Compact by *.sdf. However please note
> that there are several several file formats matching SDF
> http://en.wikipedia.org/wiki/SDF#Computing and explicit is better than
> implicit.
> 
> The sqlite3 module won't help - that's for sqlite files, which an
> entirely different file format. Wikpedia says of SQL Server Compact
> "An ODBC driver for SQL CE does not exist, and one is not planned
> either. Native applications may use SQL CE via OLE DB"
> http://en.wikipedia.org/wiki/SQL_Server_Compact. I believe the
> adodbapi module, part of PyWin32 http://sourceforge.net/projects/pywin32/files/
> can connect over OLE DB.
> 
> > 2. How can I determine the appropriate connection string? I have
> > opened database file in Visual Studio and can see the tables. I don't
> > understand where to find the connection string in Visual Studio.
> 
> These look promising http://www.connectionstrings.com/sql-server-2005-ce
> 
> > 3. Assuming a module from (1) above, does anyone have a code snippet
> > for connecting to the database and then accessing a varbinary (image)
> > in one of the tables of the databese?
> 
> Pass, I'm afraid
> 
> Regards, Alex

Thank you for the pywin32 link, I assume the problem/issue must have been resolved as there were not posts further. I could successfully ping to the database and get the desired results, let me know if anybody still needs the connection code.

[toc] | [standalone]


Back to top | Article view | comp.lang.python


csiph-web