Cant conect with ms sql

hi,

i installed ok, ok conection with mysql, but i need Ms sql...

the error

Unable to connect to the database:The MSSQL adapter "mssql" is not available.


any idea?

thanks
marcelo

Hi,

1. copy ntwdblib.dll to folder where php is installed (e.g. \xampp\php) and also to apache\bin
2. out comment extension=php_mssql.dll in php.ini (delete ; before)
3. try to connect (also try with e.g. SQL server Management Studio if connection is ok)

please see documentation:
si2.php.net/manual/en/mssql.requirements.php
www.helpspot.com/helpdesk/index.php?pg=kb.page&id=13

*if you still cannt connect send me mail This email address is being protected from spambots. You need JavaScript enabled to view it., I will send you my ntwdblib.dll (i think also correct dll version is needed)

if you have mssql 2000 type in DB type: mssql2000

for 2005 or 2008: mssql

Best regards,
Viljem

well, i did what you say, but error change.

Unable to connect to the database:Could not connect to MSSQL server H2ASERVER\SQLEXPRESS

my server is w2003server, sql2005 express.

so i use in your soft.
mssql
H2ASERVER\SQLEXPRESS (same than in sqlmanagement)
adminpinamar (same than in sqlmanagement)
pinamar (same than in sqlmanagement)
******* (same than in sqlmanagement)

i try this running inside my server.

when i use this credentials in sql i can conect, but not in cardview.

thanks,
Marcelo

Hi,

mssql adapter is ok now.

can you check if your credentials to connect to mssql are ok? Case sensitive, user that can connect, ...

Can you replace line 64 with this line below in
\libraries\joomla\database\database\mssql.php

$this->_errorMsg = 'Could not connect to MSSQL server ' . mssql_get_last_message();

well finally migrate to mysql and now works ok !