On Apr 25, 6:47 pm, Jeremy Evans <[email protected]> wrote: > On Apr 24, 2:43 am, Gary Doades <[email protected]> wrote: > > Sorted!! > > > You need to use a different provider. I use SQLNCLI10 to connect to both > > SQL Server 2008 and SQL Server 2000 and it all works OK. That's also why > > I hadn't seen any problems. > > > An example uri: > > > ado://sa:test...@localhost/test?provider=SQLNCLI10 > > > an example conn_string: > > > Provider=SQLNCLI10;Uid=sa;Pwd=testing;Database=test;Server=localhost > > > I'm not sure what the default provider is if you don't explicit ask for > > one, but it's broken :( > > If you don't specify one, Sequel doesn't specify one, so it probably > uses whatever the win32ole default is. It's not Sequel's fault that > win32ole's default is broken. > > > Maybe a switch to SQLNCLI10 as the default provider? If it's not already > > installed, it's a free download from Microsoft. > > I'll test this and see what happens if it isn't available. If I can > make it the default without breaking anything, then I will.
Unfortunately, I couldn't get the SQLNCLI10 provider to work on my main test box. The default provider works without me specifying a username and password, but that didn't work with the SQLNCLI10 provider, and attempting to use my username and password didn't work either. The provider did appear to be already installed, though. This is definitely an issue with my setup and not a problem with SQLNCLI10 itself, but since it isn't a drop in replacement, I can't make it the default provider. I was able to get the SQLNCLI10 provider to work with a production database, and it does appear to provide a consistent connection. I'll make sure to add a note to the documentation about the default provider sucking. Also, if you could, please test the patch at http://pastebin.com/q7R3gup8. It should make the ADO adapter work in more cases if you aren't using the default provider. Jeremy -- 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.
