Viewing 15 posts - 316 through 330 (of 966 total)
Just to help me clarify:
You installed the missing 64-bit 10g client?
Is the linked server working now?
May 26, 2015 at 1:12 pm
Seems like a collation conflict. What happens if you specify the collation of the table variable?
Ex:
Declare @v_Temp_School Table (School Varchar (250) SQL_Latin1_General_CP1_CI_AS, Currency Varchar (20) SQL_Latin1_General_CP1_CI_AS)
Insert Into @v_Temp_School (School...
May 26, 2015 at 9:56 am
I installed 11g 32-bit then 64-bit...
Is the SQL Server you have the clients installed on 64-bit or 32-bit? You mention installing both for the 11g client. I believe the client...
May 25, 2015 at 1:58 pm
SSIS is a feature of SQL Server. You need to go to either SQL Server Installation Center or Control Panel > Programs and Features and select SQL Server. Then you...
May 22, 2015 at 3:42 pm
Here are some of the generic benefits of SSRS in SharePoint mode:
- Security is controlled via SharePoint security
- Reports are stored primarily in document libraries on content databases
- Reports are...
May 22, 2015 at 3:26 pm
Just to make sure, if you use an Oracle client utility like SQL*Plus can you connect to the Oracle 8i database?
Hard to say but you might be right about the...
May 22, 2015 at 3:10 pm
8 or 8i? What specific version of Oracle are you trying to connect to and what version of the Oracle 10g client do you have?
May 21, 2015 at 8:36 am
You can also refresh the cache IntelliSense uses using Ctrl+Shift+R. It might take a little bit to reload.
May 20, 2015 at 4:35 pm
Doesn't Oracle have metadata views like ALL_TABLES, ALL_TAB_COLUMNS and ALL_USER_TABLES? Can you query those?
May 20, 2015 at 4:29 pm
I think that might be tough. I had a similar issue a couple of years ago with a project to convert an old Oracle 8.0.5 db to SQL Server. The...
May 20, 2015 at 4:27 pm
Normally you can tell PowerShell if you want to include directories or not.
Ex:
Get-ChildItem D:\Data\Load -Filter "*.zip" -Recurse | where {$_.psiscontainer -eq $false} | Rename-Item -NewName {$_.name -replace ' ','-' }...
May 20, 2015 at 4:10 pm
I am trying to get an old SQL2000 DB to run on at least SQL2005. Can't move it up to SQL2008 because it uses deprecated features in the SQL procs...
May 20, 2015 at 4:05 pm
Is the job type CmdExec? If so wouldn't a failed PowerShell job still show as success since the CmdExec is just calling it and the call itself is succeeding?
What happens...
February 22, 2015 at 4:47 pm
I agree with the previous responses. Email subscriptions and DSNs (Data Sources) are different things. Do the reports themselves work when you go to view them? Are you troubleshooting a...
February 22, 2015 at 4:28 pm
Nevermind. I found it. Still deprecated.
April 25, 2014 at 8:51 am
Viewing 15 posts - 316 through 330 (of 966 total)