View Complete Post
I have installed Sybase 12.5.1 OLE DB Driver and have also registered by running
We are also able to create System DSN from ODBC Administrator in Windows 7. I am
also able to import data in the MS Access. Here is the System DSN I created, successfully.
I would really appreciate you can help us out.
I just got assigned to a project to link two servers. The information I am trying to obtain is in a "Lawson LDAP application" and I'm transfering it to a SQL 2008 DB.
I went through the linked server wizard but I dont really understand the depth of it.
I have the Host name, protocol, port, Base DN, User DN information.
I did some research on the Lawson software that the company is using but what Provider should be selected in the wizard for this type of program.
As you can see I'm quite lost, Any help would be greatly appreciated.
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.
When i want to Call
http://BDCRWSS/_vti_bin/BdcAdminService.svc Bdc AdminService in SharePoint Foundation 2010
the binding i use:
closeTimeout="00:01:00" openTimeout="00:01:00" receiveTimeout="00:10:00"
sendTimeout="00:01:00" allowCookies="false" bypassProxyOnLocal="false"
messageEncoding="Mtom" textEncoding="utf-8" transferMode="Buffered"
<readerQuotas maxDepth="99" maxStringContentLength="999999" maxArrayLength="999999"
maxBytesPerRead="999999" maxNameTableCharCount="999999" />
<transport clientCredentialType="Ntlm" proxyCredentialType="None"
<extendedProtectionPolicy policyEnforcement="Never" />
I'm tried SELECT * INTO XXX FROM OPENROWSET alongwith Microsoft.ACE.OLEDB.12.0.
Apparently the query requires the sql account to have SYSADMIN privileges.
Considering that SYSADMIN should not be provided to a database account on a Production Server, I tried using the Linked Server method.
Following is my code.
Exec sp_addlinkedserver 'AB2','Ace 12.0','Microsoft.ACE.OLEDB.12.0','\\18.104.22.168\sagarr\Test1\cpc\c2\AB2.xlsx',NULL,'Excel 12.0;IMEX=1'Exec sp_addlinkedsrvlogin 'AB2','false',NULL,NULL,NULLgoSELECT * INTO [CPCAB2.xlsx] FROM OPENQUERY([AB2] ,'SELECT * FROM [Sheet1$]')Exec sp_dropserver 'AB2','droplogins'
Now i get the following error
Error.15247-User does not have permission to perform this action
My Excel file, Database and Windows Application run on separate machines.
i have provided the following privileges
GRANT ALTER ANY LOGIN TO sqlaccountGRANT ALTER ANY LINKED SERVER TO sqlaccountEXEC sp_configure 'show advanced options', 1RECONFIGUREEXEC sp_configure 'ad hoc distributed queries', 1RECONFIGUREThe DisAllowAdHocProcess in