Re: [pywin32-bugs] odbc and dbiDate!

[Andre R. <re...@in...>]

On Sat, 21 Feb 2004 19:29:56 +0100
"Andre Reitz" <re...@in...> wrote:

> hi all,
> 
> we need a way to connect to mssqlserver with python.
> 
> there is a big problem with dates:
> 
> then odbc-module / dbi-module cann only handle dates (dbiDate timestamps)
> as Integers (under windows it is not possible to select dates like
> 1950-03-20).
> 
> Is there a better way to connect mssql than with odbc?
> 
> 
> If not, my idea would be to patch the odbc/dbi modules?
> 
> any suggestions, how to implement the dbiDate object?
> 
> 
> 
> Greetings,
> and thank you very much in advance,
> 
> Andre'
> 
> 

OK I found a solution,
I am thinking about using ADO:

connection=win32com.client.Dispatch('ADODB.Connection')
connection.ConnectionString="Driver={SQL Server};Server=%s;Database=%s;UID=%s;PWD=%s" 
....etc.


What is the real difference between odbc.odbc("Driver={SQL Server};Server=%s;Database=%s;UID=%s;PWD=%s"...)?

Is ADO slower?



Greetings, Andre'


> 
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> pywin32-bugs mailing list
> pyw...@li...
> https://lists.sourceforge.net/lists/listinfo/pywin32-bugs