On Sunday 15 February 2009 12:32:03 pm Ricardo Aráoz wrote:
> import pymssql
>
> >>> conn = pymssql.connect(user='usr',
> >>> password='pass',host='Host',database='DBase')
> >>> print conn
> >>> crsr = conn.cursor()
> >>> print crsr
> >>> crsr.execute("select table_name from INFORMATION_SCHEMA.TABLES where
> >>> table_catalog ='DBase' and table_type = 'BASE TABLE' order by
> >>> table_name" ) mytables =cur.fetchall()
> >>> for tables in mytables:
> >>> print tables
I'm sorry Ricardo I not the person to determine was is wrong with a program
using SQLite. I do not use it normally. I do recall that most of the issues
had something to do with where the connection file and the database were
located.
If you could do what I asked for - that is the out put from my little test
program. After you provide the information I can do a little more testing.
Then I'll provide a simple hand coded app for you to test. I'd also like a
list of the fields (and the data types) of one the tables. This will allow
me to create a simple Bizobj for testing.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
