Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server does not exist or access denied Expand / Collapse
Author
Message
Posted Sunday, January 20, 2013 4:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 4:25 AM
Points: 143, Visits: 653
hello all.
I run this: declare @h int,@objDBC int,@src varchar(255), @desc varchar(255);


EXEC sp_OACreate 'ADODB.Connection', @objDBC OUT

EXEC @h=sp_OASetProperty 16711422,
'ConnectionString', 'Driver={SQL Server};
Server=WIN-00UO3RQ0BM3;
Database=MaliGilan;
trusted_Connection=Yes'
EXEC @h=sp_OAMethod 16711422, 'Open'
print @h
if @h<>0
EXEC sp_OAGetErrorInfo 16711422, @src OUT, @desc OUT
raiserror('Error 0x%x, %s, %s',16,1, @h, @src, @desc)

but get error :
Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
please guide me to solve this problem step by step.
thanks




Post #1409265
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse