MS SQl 2012

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server:localhost

Posted on 23 januarja, 20133 aprila, 2013 by admin

ENGLISH Together with PHP and Apache server I was using MS SQL 2000 database. After upgrading database to MS SQL 2012 aplication (which was using db) start to show error at connecting to db: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server…After longer search I fund the solution – the library file ntwdblib.dll . For…

Identity problem v MS SQL 2012

Posted on 23 januarja, 20133 aprila, 2013 by admin

ENGLISH One month ago we upgraded old MS SQL 2000 to 2012 version. It was all ok until I didn’t found out that in one table the serial number jumped for 1000 places! This was important for program who was using this table. The serial numbers has to be one after another. And how to…