Showing posts with label SQL server. Show all posts
Showing posts with label SQL server. Show all posts

Sunday, 25 November 2012

the setup routines for the sql server odbc driver could not be found

error "the setup routines for the sql server odbc driver could not be found. please reinstall the driver"

error: "data source name not found and no default driver specified"

The Magic solution is 
windows start>run>regsvr32 odbcconf.dll

everything will be OK In sha' Allah

Sunday, 28 August 2011

SQL server Cast and Print


DECLARE @VariableName varchar(30)
SET @VariableName = 'Ring'
BEGIN
   SELECT CAST(@VariableName as NVARCHAR(1))
 PRINT @VariableName;
END
GO
--------------------
out put:
R