https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/

Cant conect with ms sql

  • marxxelo
  • marxxelo's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 9 months ago #560

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

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #561

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)

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #562

if you have mssql 2000 type in DB type: mssql2000

for 2005 or 2008: mssql

Best regards,
Viljem

Please Log in or Create an account to join the conversation.

  • marxxelo
  • marxxelo's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 9 months ago #564

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

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #567

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();

Hope we get some more info about your error.

Best regards,
Viljem

Last edit: 13 years 9 months ago by user62.

Please Log in or Create an account to join the conversation.

  • marxxelo
  • marxxelo's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 9 months ago #568

well finally migrate to mysql and now works ok !

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.216 seconds

Contact Us

Contact us on Discord

Contact us on Facebook