[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

unable to connect to ms sql server.

avinash404

6/3/2006 5:37:00 AM

I get the following error message when trying to connect to ms sql
server:

Open
OLE error code:80040E4D in Microsoft OLE DB Provider for SQL Server
Login failed for user 'XXXXXXXX'.
HRESULT error code:0x80020009
Exception occurred.

I google'd for those error codes but nothing useful so far. To set up
ruby for ms sql server, I followed the instructions here:

http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosof...

I followed the first 2 steps (copying ado.rb and modifying
database.yml) but I cannot get it to connect to the sql server.

Any tips, thoughts?
thanks in advance,
--
avinash
2 Answers

avinash404

6/3/2006 5:44:00 AM

0

And yes, I have made sure that the credentials I am using are valid and
I am able to connect to the server from other interfaces.

BTW, is there a way to force ruby to use windows authentication for
connecting to the sql servers?
--
avinash

avinash...@gmail.com wrote:
> I get the following error message when trying to connect to ms sql
> server:
>
> Open
> OLE error code:80040E4D in Microsoft OLE DB Provider for SQL Server
> Login failed for user 'XXXXXXXX'.
> HRESULT error code:0x80020009
> Exception occurred.
>
> I google'd for those error codes but nothing useful so far. To set up
> ruby for ms sql server, I followed the instructions here:
>
> http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosof...
>
> I followed the first 2 steps (copying ado.rb and modifying
> database.yml) but I cannot get it to connect to the sql server.
>
> Any tips, thoughts?
> thanks in advance,
> --
> avinash

greg.kujawa

6/3/2006 2:59:00 PM

0

If you are creating the connect string you can use the
Trusted_Connection option. Something like:

'DBI:ADO:Provider=SQLOLEDB;Connect Timeout=5;Data
Source=myServer;Initial Catalog=myDatabase;Persist Security
Info=True;Trusted_Connection=Yes;'

This way the SQL Server username and password aren't being passed
along. Just the logged on network username on the workstation/server
you run the script from.

Hope this helps!

avinash404@gmail.com wrote:
> And yes, I have made sure that the credentials I am using are valid and
> I am able to connect to the server from other interfaces.
>
> BTW, is there a way to force ruby to use windows authentication for
> connecting to the sql servers?
> --
> avinash
>
> avinash...@gmail.com wrote:
> > I get the following error message when trying to connect to ms sql
> > server:
> >
> > Open
> > OLE error code:80040E4D in Microsoft OLE DB Provider for SQL Server
> > Login failed for user 'XXXXXXXX'.
> > HRESULT error code:0x80020009
> > Exception occurred.
> >
> > I google'd for those error codes but nothing useful so far. To set up
> > ruby for ms sql server, I followed the instructions here:
> >
> > http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosof...
> >
> > I followed the first 2 steps (copying ado.rb and modifying
> > database.yml) but I cannot get it to connect to the sql server.
> >
> > Any tips, thoughts?
> > thanks in advance,
> > --
> > avinash