Oracle Client And Networking Components
Apr 30, 2007
hi all.
In my SSIS project, i have to retrieve data from an oracle 10g database. On my personal laptop it works, but on our test-env i get the error below, when i try to test my connection to the oracle datasource.
Could this because i have oracle XE installed yet on my personal laptop, and it is not installed on the computer of our test environment where the SSIS runs? If that's the reason, it sounds very strange, because it would mean i have to install an oracle environment also on the computer with SSIS, just to make a connection to another oracle server...
Error:
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.
------------------------------
BUTTONS:
OK
------------------------------
View 10 Replies
ADVERTISEMENT
May 21, 2004
I have a network of all win2000 machines. The server is win2000 and is a domain controller running sql 2000. I've been having intermittent problems with our software staying connected to sql and found that installing the sql client networking package fixes it. The problem I'm having is that users with admin rights work just fine, but users with just user rights aren't. I set up client neworking by moving named pipes above tcp and setting the alias to the sql server but the user machines doesn't remember the alias.
Here's a list of what I've tried:
log in as admin and enter alias
create .reg file of proper registry settings and import but got a key is in use error, cannot import registry
created shortcut to cmd and set shortcut to run as diff user, log in as admin, run .reg file, imports fine, alias still missing in user computer.
Any ideas what might make the alias not stick? The users cannot install software and there might be some other security setting or restriction keeping it from sticking but I have yet to find it.
View 2 Replies
View Related
Apr 2, 2008
I have a question about client components. I read someplace where if sql client components are preinstalled
(if you delete sql express-client components cannot install, even if they are preinstalled
I have sql express default installation from vs 2008 pro
I have not installed sql express (client components, database components
I wish to install cd standard edition on my computer for reporting services
Also wanted to add enterprise server so I need report manager
office 2007 installed by myself. I came across this article kb909967.
Is there anyway to check make sure I can install client components installs on standard edition
I also read kb 964164 installing sql on vs 2008 vista ultimate Thanks
View 7 Replies
View Related
Jun 20, 2006
I'm trying to do an unattended install of the client components for SLQ2005. I have read the document on doing a install from the command prompt but when I use the "ADDLOCAL" switches I get some components that I don't require. For example, I am using the following command to run the setup - "start /wait <path>setup.exe ADDLOCAL=Client_Components,SQL_Tools90,Connectivity". When I look at the Add/Remove Programs list I can see that it has installed "MSXML 6.0 Parser", "SQL 2005 Backward Compatibilty" and "Office 2003 Web Components". The only components I require are the "SQL Support Files", "SQL Server Native Client" and " CLient Tools". If I run "start /wait <path>setup.exe REMOVE=SQLXML,TOOLS_BC_DEP" it will remove "Office 2003 Web Components" and "SQL 2005 Backward Compatibilty" but not the "MSXML 6.0 Parser". How can I get rid of this?
Thanks for any help.
View 1 Replies
View Related
Jan 8, 2008
I'm building a new server and am having a problem witht he SQL install. It's a Dell 2905 running Windows 2003 SP1 x64 and SQL 2005 x64. I'm able to install everything except for the Client Components, and even upgrade to SQL SP2.
I keep getting the following error:
"There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information"
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643
------------------------------
BUTTONS:
OK
------------------------------
The problem is that I can't find any solutions to this so far. Anyone recognize or have any insight into this?
View 4 Replies
View Related
Jan 29, 2008
When running the GUI client, I chose to install the SQL Server 2005 'Client Components' on F:Program FilesMicrosoft SQL Server, the installation put over 700MB of files on my C: drive, but there were less than 400MB of files in the location I specified. Only about 1/2 of the files I expected were put in the location I specified.
Why?
How can I redirect all of the 'shared' files and other misc. development pieces to install somewhere other than my boot drive? There is no way to specify this when using the GUI, can it be done with a command line install?
Thanks,
Tommy Thompson
Thrivent Financial
View 1 Replies
View Related
Jul 31, 2006
When attempting to install SQL Server 2005 SP1, I receive the error, "a recently applied update, KB913090, failed to install." The Installation complete dialog shows the Client Components product Status as "Failure" with the description detail, "Unable to install Windows Installer MSP file". My Operating System is Windows Server 2003 SP1.
Please advise as to risks and fix.
Thanks,
Rob
View 1 Replies
View Related
Jan 12, 2007
Is it possible to force the SLQ 2005 Client Components to be installed into a diffrent location other than the default location?
What I'm trying to do is run the setup command though the command line to create an unattended client installation with all the client componets to a diffrent location that
Thanks, Any information or examples would be great!
View 1 Replies
View Related
May 25, 2007
I have Windows XP Professional Version 2002 Service Pack2.
I Have:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Service Pack is failing to Install CLIENT COMPONENTS; message is:
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
This situation, I am guessing, also preventing me to run import/export from the SQLServer Client.
Any help is appreciated. Thanks.
View 6 Replies
View Related
Apr 27, 2008
Hello,
I have installed successfully Microsoft SQL server 2005 in MSCS.
However the set up did not install Workstation components (client tools - SSMS etc).
I have successfully installed workstation components in one node of cluster.
However setup is giving following error while installing workstation components on other node. (From this node MS SQL server 2005 was installed).
Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.
I did "C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, /setup".
It executed but no error, no output.
Any gues, help in isolating issue?
Any more information required.(Media is ok. Setup has been tried after reboot. There is enough disk space.)
Regards.
Mahesh
===========
Setup
1) Microsoft Cluster of two nodes.
2) Hardare - HP Blade servers
3) OS - Windows 2003 EE with SP2
4) SQL Server 2005 Standard Edition with SP2.
=============================
MSI (s) (B0:7C) [17:40:20:390]: Note: 1: 1722 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe 4: /setup
MSI (s) (B0:7C) [17:47:23:609]: Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
MSI (s) (B0:7C) [17:47:35:921]: Note: 1: 1729
MSI (s) (B0:7C) [17:47:35:921]: Product: Microsoft SQL Server 2005 Tools -- Configuration failed.
MSI (s) (B0:7C) [17:47:35:953]: Cleaning up uninstalled install packages, if any exist
MSI (s) (B0:7C) [17:47:35:953]: MainEngineThread is returning 1603
MSI (s) (B0:A0) [17:47:36:062]: Destroying RemoteAPI object.
MSI (s) (B0:80) [17:47:36:062]: Custom Action Manager thread ending.
View 1 Replies
View Related
Mar 19, 2008
Can I create ODP.NET connection in my SSIS connection manager. I had downloaded and installed ODP.NET on my server provided by oracle. The idea is I need to test this provider and see what is the difference connecting oracle database and the data load speed.
thank you
View 4 Replies
View Related
Dec 14, 2007
Hi all,
I have downloaded Microsoft SQL Server 2005 Enterprise Evaluation Edition ISO from the following site and burned it onto a DVD.
http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en
Prior to this I have installed Visual Studio 2005 Professional Edtion. During setup I have selected all the native client components i.e. Management Studio, Business Intelligense Studio. But after the install I am not able to see them under All Programs-> Microsoft SQL Server 2005. On further searching I have come across this link
http://channel9.msdn.com/ShowPost.aspx?PostID=142941
First of all, there is no sqlrun_tools.msi under setup folder of the dvd. And also when I tried to change component from Add/Remove programs and following the instructions as specified on clicking Change Installed components all that I see are: Connectivity Components and Software Development kit.
Could someone tell me how can I install Management Studio/ Business Intelligence Studio seperately? I don't want to go through the process of re-installation.
View 4 Replies
View Related
May 29, 2008
Hi,
Pls let me know if SQL Server 2005 Management Studio (client tools only) is compatible with Windows Server 2000 or not?
Thanks in advance.
Regards,
Bhuvana
View 1 Replies
View Related
Feb 27, 2008
I have tried everything I can find online to resolve an ongoing issue with a SSIS package that pulls data from Oracle. I have other servers that can function just fine connecting to the same Oracle database. I have the 10g x64 client installed and I can TNSPing the database from the command prompt. I get varying errors depending on what I am doing. If I execute the package stored in SSIS MSDB from SSMS on my computer, it runs just fine. If I run it from the server I get:
Info: 2008-02-26 23:02:42.59
Code: 0x4004300A
Source: Data Flow Task RT_ADDRESS DTS.Pipeline
Description: Validation phase is beginning.
End Info
Progress: 2008-02-26 23:02:42.59
Source: Data Flow Task RT_ADDRESS
Validating: 0% complete
End Progress
Error: 2008-02-26 23:02:42.65
Code: 0xC0202009
Source: ROCKDBA DATA UPDATE (NEW) Connection manager "Rock"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" H
result: 0x80040154 Description: "Class not registered".
End Error
Error: 2008-02-26 23:02:42.67
Code: 0xC020801C
Source: Data Flow Task RT_ADDRESS OLE DB Source [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAG
ER. The AcquireConnection method call to the connection manager "Rock" failed w
ith error code 0xC0202009. There may be error messages posted before this with
more information on why the AcquireConnection method call failed.
End Error
Error: 2008-02-26 23:02:42.67
Code: 0xC0047017
Source: Data Flow Task RT_ADDRESS DTS.Pipeline
Description: component "OLE DB Source" (1) failed validation and returned err
or code 0xC020801C.
End Error
Progress: 2008-02-26 23:02:42.67
Source: Data Flow Task RT_ADDRESS
Validating: 50% complete
End Progress
Error: 2008-02-26 23:02:42.68
Code: 0xC004700C
Source: Data Flow Task RT_ADDRESS DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2008-02-26 23:02:42.68
Code: 0xC0024107
Source: Data Flow Task RT_ADDRESS
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 11:02:35 PM
Finished: 11:02:42 PM
Elapsed: 7.156 seconds
I tried uninstalling and reinstalling Oracle on this server. I tried the 32bit Oracle Client as well as the 64bit client. I rebuilt the package to use Data Flow Tasks from scratch, and I have the same issues. If I try and build the package on the server itself in BIDS, I get TNS errors in BIDS trying to create connection managers. I am missing something, but I have no idea what it is. If I try and use a DataReader Source, I get:
System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset)
at System.Data.OracleClient.OCI.DetermineClientVersion()
--- End of inner exception stack trace ---
at System.Data.OracleClient.OCI.DetermineClientVersion()
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at STPSendMailData.BaseData.SetConnectionAndTransaction()
It just doesn't add up. I get this exception with the 64 bit client installed. Anyone with ideas, I am getting near to the point of migrating backwards to 32 bit SQL on this server to be rid of this problem.
View 5 Replies
View Related
Dec 6, 2006
Hi,
I've been working with MS XP OS and Oracle Client 9i (9.2) and my project was working properly. In another machine with the OS: MS Windows 2003 Server SP.1 and Oracle Client 10g I'm getting the error "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater " when trying to open a connection.
Please help,
thnx
View 3 Replies
View Related
Mar 20, 2002
if you were running a SQL2k cluster, multiple named instances, would you let someone install the oracle client so DTS packages could be setup ?
I am a bit apprehensive about putting this oracle client on my production box. would appreciate any experience people have in this area.
thanks
Carol
View 2 Replies
View Related
Jul 20, 2005
I have created a DTS package that pulls data in from Oracle into SQLServer. When I run it directly on the server (from EnterpriseManager), it works fine. When I run it from Enterprise Manager on aclient machine that does not have the Oracle client software, it doesnot run, giving me the error: "The Oracle client and networkingcomponents were not found...". I was hoping I wouldn't need to havethe client software installed on a machine other than the server whereSql Server is running. The problem here is that there are a number ofmachines from where I would like to execute this DTS package that I donot want to install/configure the Oracle client software. I don'tquite understand why the configuration of the client is importanthere. In my mind, when I am using enterprise manager from a clientmachine, I am using it sort of like a terminal services client toconnect to the server. I guess there is a lot more happening in thebackground.Thanks for any feedback,Marcus
View 2 Replies
View Related
Feb 5, 2007
Hello,
I was hoping someone had this problem and has a solution... :)
Some background info:
SQL 2005 Enterprise x64
Windows 2003 R2 x64 Enterprise (clustered)
Oracle client 10.2.0.3 (latest as of 2/2/07)
The issue I'm having is I have a link server setup within SQL 2005 connecting to a Oracle 8 database server. The Oracle client I'm using is 10.2.0.3 (latest version from Oracle). From the SQL 2005 server I'm able to query the remote oracle server through the link server I had setup if I query the table directly. If I perform a query to a view on the Oracle server I'm able to see the colum names, but not the data. This only happens when I'm using the Oracle client, if I use the MS client for Oracle it works fine OR if I use SQL Plus.
Now, you're probally asking, why not just use MS's driver... Well, I would If I could, but Microsoft hasn't provided a 64 bit driver for Oracle which I need to create the link server in SQL.
Any help would be appreciated.
View 4 Replies
View Related
Sep 7, 2006
Everything I've read says that custom data flow components are built by inheriting from the Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class.
But the stock components such as the Derived Column data flow transformation must each be implemented by their own class. So how do I base my custom components on those classes? The documentation for the PipelineComponent class doesn't list any such subclasses.
View 1 Replies
View Related
Jun 30, 2006
Hi,
In another thread Jamie Thomson very informatively said "The components in SSIS
are deliberately atomic (i.e. they do something very specific) so that
its easy to put them together to build something greater than the sum
of the parts". Which does make a lot of sense. However, I've been finding that I end up having to create exactly the same "pattern" of combined transform components again and again in order to solve the same problem but in different dataflows (or even within the same dataflow). Cut-and-paste-tastic! In order to obtain real re-use, it seems to me like SSIS is crying out for an easy way to create new components by using composition - i.e. the ability to take commonly-used combinations of existing components and create new "super" components (without having to write Custom Transform Components in C#/VB.Net and handle everything in code).
Does anyone know if this sort of functionality is likely to make it into SSIS in the forseeable future?
Regards,
Lawrie
View 6 Replies
View Related
Aug 10, 2007
Hi all,
We have a small office network consisting of 6 workstations and a server. I want to know if it is possible to be able to run sql server from the workstations and host the created sql databases on the server rather than an individual pc? If so how do i do this?
Thanks
View 2 Replies
View Related
Apr 5, 2008
I've written a program for one of my clients, and they are making alot of changes. Typically when I make a change, I have to go into the office and re-install the updates to every system that uses the application. I would like ot be able to install the application in a central location, and then run shortcuts to everyones PC so when I update the application I just have to install it in one place. How can I do this? Also they clients are running a windows domain in the office. How can I accomplish this task?
View 7 Replies
View Related
Mar 17, 2008
I am currently using SQL Server 2005 Express to run a social networking website on a dedicated server (Windows Server 2003, code is written in ASP.net). Obviously express is too limited to run this site, but for now I am still getting the site operational so the demands are low. Soon I will begin advertising and adding many users to the site - can anyone recommend a version of SQL Server that I would need? My programmers say I should go with enterprise, but that seems overkill (and my hosting provider - theplanet.com does not even offer it). Would workgroup be enough, or should I go with standard edition?
To be honest I do not trust my programmers experience with SQL server which is why I am asking for help here (they are outsourced from India, and I am becoming more and more convinced that I need an onshore IT manager for them - finding that is another issue...). Also, are there built in backup features with SQL Server? My programmers told me recently that they will need to put in significant work to setup a backup system, but it seems to me like one might already be built in.
Thanks for your help,
Greg
View 6 Replies
View Related
Apr 26, 2002
I am using the personal edition of sql server 2000 and i have a number of databases stored on the harddrive, how would i set up a connection with other PC's to be able to view/modify/delete the data through an access 2000 front end. The other PC's will not have SQL server on them but will have Access 2000, they will need to go via the network which is non-microsoft compliant.
Thank you very much for you help it would be very much appreciated.
Britta
View 1 Replies
View Related
Aug 3, 2006
Hi I want to Set up Such Merge Replication, Which can can Synchronize With out Network, Means Syncronization using CD.
Also When the Network connectivity will be available then it should do synchronization
I wants to transfer some file using CD only those changes to database which hasn't been synchronized, thats why Backup will not work.
Pls Help me, or tell me wether it is possible or not.
Tell me some work around, or ask me details,
You got to help me out, Otherwise I will loss trust in MSDN Forums.
Thanks in advance
Vishalgiri Goswami
View 3 Replies
View Related
Jun 10, 2006
hi
i want to know that how to manage the sql server transaction in a
big desktop networking application?
for example
there are 200 tables in
database. many of that tables have relatationship. i have a form in
frontend which holds nere ablut 50 tables deffrent calculated amount. i
want to ADD, EDIT and DELETE, SAVE(commit), CANCEL(roll back) them and
same time another use will do the same work from another pc. if there
are 100 user does the same work (add, edit, delete, save, cancel) how
could i magage my sql server data???
i also want to know that
1 kind of
proffessionsl way to use sql server and vb.net?
2 what kind of septs to
develop a desktop networking application with sql server?
3 how i could
manage the transaction in sql server when there are many-many user
working in the same database(add, edit, delete, save-commit,
cancel-rollback).<img src="images/emoticons/smile_baringteeth.gif">
View 1 Replies
View Related
May 28, 2001
We have 15 clients running our applicaton
14 of then conected to SQL server using TCP/IP and it runs fine
1 of 15 when connected using TCP/IP produce "..Time out error "
but runs fine when swiched from TCP/IP to Named pipes
1.What area should we look to correct problem with Time out using TCP/IP ?
2. Where to get information about using TCP/IP via Named pipes ?
View 1 Replies
View Related
May 10, 2006
Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
View 78 Replies
View Related
May 2, 2006
On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?
View 2 Replies
View Related
Nov 1, 2006
Hi,
I have SQL2000 installed as the default instance, and now I'm trying to install SQL 2005 standard edition as a named instance.
I receive this error :
SQL Server could not connect to database service for server configuration.. [SQL Native client] Encryption not supported on the client. However I'm able to install client tools
The setup works fine on other box with the same config : SQL 2000/Windows XP, is there any work around for this issue ?
In my SQL 2000 client network utilty "Force proctocol encryption " is desabled and did not find the setting for SQL 2005 !
Thank you
View 1 Replies
View Related
Jul 23, 2005
Hello,Is it necessary to upgrade the Client Connectivity Tools on all clientmachines after the SQL Server database server is upgraded from Version7.0 to 2000?Thank you in advance!Eddy
View 1 Replies
View Related
Sep 12, 2007
I have an issue using parameterised reports connecting to Oracle using "ODBC" and "Microsoft OLE DB Provider for Oracle" using parameteried reports. The following error is generated "ORA-01008 not all variables bound (Microsoft OLE DB Provider for Oracle)" and a similiar one for ODBC. It works fine for simple reports. Do these 2 drivers have issues passing parameters for a remote Oracle query?
Thanks.
View 4 Replies
View Related
Apr 2, 2007
Hi!
I'm loading from Oracle using the OraOLEDB.Oracle.1 provider since I need unicode support and I get the following error:
TITLE: Microsoft Visual Studio
------------------------------
Error at myTask [DTS.Pipeline]: The "output column "myColumn" (9134)" has a precision that is not valid. The precision must be between 1 and 38.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0204018 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
For most of my queries to Oracle I can cast the columns to get rid of the error (CAST x AS DECIMAL(10) etc), but this does not work for:
1) Union
I have a select like "SELECT NVL(myColumn, 0) .... FROM myTable UNION SELECT 0 AS myColumn, .... FROM DUAL"
Even if I cast the columns in both selects (SELECT CAST(NVL(myColumn, 0) AS DECIMAL(10, 0) .... UNION SELECT CAST(0 AS DECIMAL(10, 0)) AS myColumn, .... FROM DUAL) I still get the error above.
2) SQL command from variable
The select basically looks like this:
"SELECT Column1, Column2, ... FROM myTable WHERE Updated BETWEEN User::LastLoad AND User::CurrentLoad"
Again, even if I cast all columns (like in the union), I still get the same error.
Any help would be greatly appreciated. Thanks!
View 10 Replies
View Related
