On 30/04/2010 8:40 PM, Jeremy Evans wrote:
On Apr 29, 5:52 pm, Jeremy Evans<[email protected]>  wrote:
Also, if you could, please test the patch athttp://pastebin.com/q7R3gup8.
It should make the ADO adapter work in more cases if you aren't using
the default provider.
That patch was bad, but I committed some recent patches that improve
support if you use the SQLNCLI10 provider.  I also updated the
documentation to make it clear that the default provider sucks.

That explains why my brief attempts with the original patch didn't look good.

From my 3 machines here the default provider seems to be "MSDASQL.1". I'm not sure where that comes from.

DB.synchronize do |c|
  puts c.provider
end

It seems that "SQLOLEDB.1" (we use with SQL Server 2000) or "SQLNCLI10" (we use with SQL Server 2008) always work just fine. You seem to get SQLNCLI or SQLNCLI10 when you install SQL Server 2005/2008

Cheers,
Gary.

--
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sequel-talk?hl=en.

Reply via email to