Configuring SQL Server with kagemai

[Gandhi]

Can any one provide me the detailed procedure to configure SQL Server
with kagemai


I am using sa user for my kagemai
i have created a system dsn by name bts

In the global settings i have given the following

mssql_dsn - > Provider=SQLOLEDB;DSN=bts;Server=abc
\MSSQLSERVER;Database=Kagemai
mssql_user - > sa
mssql_pass -> *****

abc is my server name
I am getting this error

Following errors occurred. Please contact administrator.

Could not load driver (no such file to load -- DBD/ADO/ADO). Note that
in SAFE mode >= 1, driver URLs have to be case sensitive!
(DBI::InterfaceError)

Regards
Gandhiyappan

[FUKUOKA Tomoyuki]

Hi,

2008/12/4 Gandhi <gandhi...@gmail.com>:

> Following errors occurred. Please contact administrator.
>
> Could not load driver (no such file to load -- DBD/ADO/ADO). Note that
> in SAFE mode >= 1, driver URLs have to be case sensitive!
> (DBI::InterfaceError)

You have to install ruby-dbi ADO driver, but latest version of ruby-dbi
does not support ADO. You can install version 0.2.2 (with ADO driver)
from http://rubyforge.org/projects/ruby-dbi/

tar xfvz dbi-0.2.2.tar.gz
cd dbi-0.2.2
ruby setup.rb config --with=dbi,dbd_ado
ruby setup.rb setup
ruby setup.rb install

--
FUKUOKA Tomoyuki

[Gandhiyappan parasuraman]

Hi,

 

Thank you very much for your response.

 

I have tried the solution you have provided and now i am getting a different error

 

Following errors occurred. Please contact administrator. Open OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Invalid connection string attribute HRESULT error code:0x80020009 Exception occurred. (DBI::DatabaseError)

 

Sorry for disturbing again.

 

If you know the solution for the above problem please let me know

 

Regards

Gandhiyappan

[FUKUOKA Tomoyuki]

Hi,

2008/12/5 Gandhiyappan parasuraman <gandhi...@gmail.com>:

> Following errors occurred. Please contact administrator. Open OLE error
> code:80004005 in Microsoft OLE DB Provider for SQL Server Invalid connection
> string attribute HRESULT error code:0x80020009 Exception occurred.
> (DBI::DatabaseError)

check your mssql_dsn setting.
if you are trying connect to database "Kagemai" on server "abc":

Provider=SQLOLEDB;Server=abc;Database=Kagemai

if you use named instance:

Provider=SQLOLEDB;Server=abc\instancename;Database=Kagemai

--
FUKUOKA Tomoyuki