Sulit koneksi ke SQL Server 2005 Express

Pengalaman saya saat memakai SQL Server 2005 adalah sulit koneksi ke server, pesannya adalah “Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: SERVER\SQLEXPRESS“. Wah sampai kebingungan gak ketemu-ketemu solusinya, di sebagian komputer gak ada masalah tapi kenapa cuma komputer saya yang gak bisa connect (BT deh…..). Saya coba install dulu SQL Server 2000 baru bisa connect. Aneh banget…., masa tiap mau pake SQL Server 2005 mesti install dulu SQL Server 2000. Dan ternyata cara tersebut malah beda ketika di implementasikan ke komputer yg lain. Tapi hari ini baru saja saya menemukan dan baca di http://forum.ragezone.com/f528/share-new-way-to-register-an-account-without-rancp-php-script-564652/. Ternyata berhasil….., aplikasi web yg saya buat bisa connect SQL Server 2005 Express.

Caranya copy ntwdblib.dll [version] 2000.80.194.0 ke:

For XAMPP user:
C:\xampp\php
C:\xampp\apache\bin
C:\WINDOWS\system32

For WAMP user:
C:\wamp\bin\php\php5.2.6
C:\wamp\bin\apache\apache2.2.8\bin
C:\WINDOWS\system32

Untuk yang memili problem yang sama seperti saya, mudah-mudahan ini bisa menjadi salah satu solusi bagi anda. Silahkan download ntwdblib.dll disini (ket. Jangan lupa setelah selesai download ubah ekstensi *.jpg nya ke *.zip) maklum di wordpress gak bisa upload file berekstensi *.zip ^_^.

Mengosongkan isi tabel pada SQl Server

Gunakan procedur berikut.

Create Procedure dbo.sp_EmptyAllTables (@ResetIdentity Bit)

As

Begin

Declare @SQL VarChar(500)

Declare @TableName VarChar(255)

Declare @ConstraintName VarChar(500)

Declare curAllForeignKeys SCROLL CurSor For Select Table_Name,Constraint_Name From Information_Schema.Table_Constraints Where Constraint_Type=’FOREIGN KEY’

Open curAllForeignKeys

Fetch Next From curAllForeignKeys INTO @TableName,@ConstraintName

While @@FETCH_STATUS=0

Begin

Set @SQL = ‘ALTER TABLE ‘ + @TableName + ‘ NOCHECK CONSTRAINT ‘ + @ConstraintName

Execute(@SQL)

Fetch Next From curAllForeignKeys INTO @TableName,@ConstraintName

End

Declare curAllTables Cursor For Select Table_Name From Information_Schema.Tables Where TABLE_TYPE=’BASE TABLE’

Open curAllTables

Fetch Next From curAllTables INTO @TableName

While @@FETCH_STATUS=0

Begin

Set @SQL = ‘DELETE FROM ‘ + @TableName

If @ResetIdentity = 1 AND OBJECTPROPERTY (OBJECT_ID(@TableName),’TableHasIdentity’)=1

Set @SQL = @SQL + ‘; DBCC CHECKIDENT(”’ + @TableName + ”’,RESEED,0)’

Execute(@SQL)

Fetch Next From curAllTables INTO @TableName

End

Fetch First From curAllForeignKeys INTO @TableName,@ConstraintName

While @@FETCH_STATUS=0

Begin

Set @SQL = ‘ALTER TABLE ‘ + @TableName + ‘ CHECK CONSTRAINT ‘ + @ConstraintName

Execute(@SQL)

Fetch Next From curAllForeignKeys INTO @TableName,@ConstraintName

End

Close curAllTables

Deallocate curAllTables

Close curAllForeignKeys

Deallocate curAllForeignKeys

End

Lalu jalankan perintah ini :

sp_EmptyAllTables 1