SQL Connection Web Config Error

Feb 12, 2006

hey guys i keep getting this error and I am not sure how to sort it and google just aint working for me tonight.

Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.






Line 31: SqlDbType.VarChar, 40))
Line 32: objCmd.Parameters("@IssueName").Value = IssueName.Text
Line 33: objCmd.Connection.Open()
Line 34: ' Test whether the new row can be added and display the
Line 35: ' appropriate message box to the user.





[InvalidOperationException: The ConnectionString property has not been initialized.]
System.Data.SqlClient.SqlConnection.PermissionDemand() +852131
System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection) +22
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ASP.newpriority_aspx.submit(Object Source, EventArgs e) in C:Prototypeofficial1html
ewpriority.aspx:33
System.Web.UI.HtmlControls.HtmlInputButton.OnServerClick(EventArgs e) +105
System.Web.UI.HtmlControls.HtmlInputButton.RaisePostBackEvent(String eventArgument) +106
System.Web.UI.HtmlControls.HtmlInputButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102


the web config con string is like so

 

<______________>

<?xml version="1.0" encoding="utf-8"?>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">



<connectionStrings>

<add name="GeolinkSupportdb" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|ASPNETDB.MDF" />

</connectionStrings>



<system.web>



<authentication mode="Forms" />

<roleManager defaultProvider="SqlProvider"

enabled="true"

cacheRolesInCookie="true"

cookieName=".ASPROLES"

cookieTimeout="30"

cookiePath="/"

cookieRequireSSL="false"

cookieSlidingExpiration="true"

cookieProtection="All" >

<providers>

<add

name="SqlProvider"

type="System.Web.Security.SqlRoleProvider"

connectionStringName="GeolinkSupportdb"

applicationName="SampleApplication" />

</providers>

</roleManager>



<membership defaultProvider="CustomizedProvider">

<providers>

<add name="CustomizedProvider"

type="System.Web.Security.SqlMembershipProvider"

connectionStringName="GeolinkSupportdb"

minRequiredPasswordLength="5"

minRequiredNonalphanumericCharacters="0" />

</providers>

</membership>

 

</system.web>

</configuration>

 

<------------------------------>

code

 

<% @Import Namespace="System.Data" %>

<% @Import Namespace = "System.Data.SqlClient" %>

<% @Import Namespace="System.Text" %>

<% @Import Namespace="System.IO" %>

<% @Import Namespace="System.Web.UI.HtmlControls" %>

<script language="VB" runat="server">



Dim strConnection as string = ConfigurationSettings.AppSettings("GeolinkSupportdb")

Dim sqlConn = New SqlConnection(strConnection)

Sub Page_Load(sender as Object, e as EventArgs)



End Sub

 

Sub submit(Source As Object, e As EventArgs)

'assign the user entered information

Dim objCmd As SqlCommand

'Dim dbIssueName = IssueName.Text

'You must open the connection before populating the DataReader

Dim strSQL1 = "Insert into Support_Issue Values @IssueName"

'SqlConn.Open()

objCmd = New SQLCommand(strSQL1, SqlConn)

objCmd.Parameters.Add(New SqlParameter("@IssueName", _

SqlDbType.VarChar, 40))

objCmd.Parameters("@IssueName").Value = IssueName.Text

objCmd.Connection.Open()

' Test whether the new row can be added and display the

' appropriate message box to the user.

Try

objCmd.ExecuteNonQuery()

Message.InnerHtml = "<b>Record Added</b><br>" & strSQL1

Catch ex As SqlException

If ex.Number = 2627 Then

Message.InnerHtml = "ERROR: A record already exists with " _

& "the same primary key"

Else

Message.InnerHtml = "ERROR: Could not add record, please " _

& "ensure the fields are correctly filled out"

Message.Style("color") = "red"

End If

End Try

objCmd.Connection.Close()

End Sub

</script>

database looks like this

IssueID      UniqueIdentifer

IssueName   varchar(50)

 

Any idea on why I cannot get my connection string to work have I missed something or trying to connect to it wrongly?

View 9 Replies


ADVERTISEMENT

SSIS Connection Error When Using Config File

Dec 17, 2007

Hi

I am developing one SSIS package to migrate an Oracle Database to SQL Server 2005 DB through ODBC. My problem is with configuration. I have to use configuration file so that in production environment the end-user must be able to change the user credentials to connect both database servers. I am trying xml configuration file. When I try to use xml configuration, my odbc connection is giving error. But if I disable the configuration through "Package Configurations Organizer", it works fine. Using an XML Editor I checked the .dtsconfig file and entered both passwords for the both connections.

I tried logging and below are the few text from log file related to error.




Code Block
User:Diagnostic, Nebu, BLRDOMNebu, DestOdbcConnection,{E3535ED4-1D21-41B9-9796-E9F5B47FFD5B}, {6820E259-18FF-4FCA-B820-73EE931D2095},12/17/2007 8:16:39 PM,12/17/2007 8:16:39 PM,0,0x,ExternalRequest_pre: The object is ready to make the following external request: 'IDbConnection.Open'.

User:Diagnostic,Nebu, BLRDOMNebu, DestOdbcConnection,{E3535ED4-1D21-41B9-9796-E9F5B47FFD5B},{6820E259-18FF-4FCA-B820-73EE931D2095},12/17/2007 8:16:41 PM,12/17/2007 8:16:41 PM,0,0x,ExternalRequest_post: 'IDbConnection.Open failed'. The external request has completed.






I am using Protection level = EncryptSensitiveWithPassword for the package.

Please help me.

Thanks & Regards

Charmis

View 4 Replies View Related

SSIS - Excel Connection Error When Using Config Files

Mar 26, 2008

I have several SSIS packages, some of which retrieve data from excel files - they work fine from th VS designer until I try to store configurations in a SQL database - then I get the following error:


SSIS package "ITAMdiv2.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.

Error: 0xC0202009 at ITAMdiv2, Connection manager "ExcelDIV2": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

Error: 0xC020801C at Data Flow Task, Excel Source [84]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ExcelDIV2" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "Excel Source" (84) failed validation and returned error code 0xC020801C.


any ideas?

Thanks in advance@!

Bob

View 1 Replies View Related

Get SQL Connection For SQL Config From XML

May 30, 2007

Hi

In toder to make my SSIS packages portable, I need to be able to set connection string to sql package configuration. I thought I can do that via XML package, problem is, at execution time SQL server package configuration is queried first, then variables from XML.
This way, I have no chance to set connection via XML.
Any ideas on how to aproach this ?
(I want to have as much configuration on SQL server so I can modify it easily from future GUI application.

best regards

View 4 Replies View Related

Connection Strings In Web.config

May 31, 2007

What am I doing wrong?
This works:
SQLConn.ConnectionString = "Data Source=McD_DB;Initial Catalog=McDFeelGood;User ID=uuu;Password=ppp"
Now I want to put it in my web.config, but these don't work ("ConnectionString property has not been initialized"):
SQLConn.ConnectionString = ConfigurationSettings.AppSettings("McDFeelGoodConnectionString") (VS IDE says this method is obsolete)SQLConn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("McDFeelGoodConnectionString")
<connectionStrings>    <add name="McDFeelGoodConnectionString" connectionString="Data Source=McD_DB;Initial Catalog=McDFeelGood;Persist Security Info=True;User ID=uuu;Password=ppp" providerName="System.Data.SqlClient" /></connectionStrings>

View 1 Replies View Related

Config And Connection String

Apr 26, 2007



I want to store my connection string in a configuration file, however when I create the config file the connection string password is not stored. I can manually edit my config file and add the password to my connection string but I am sure that BIDS has a better solution. What is the best practice for storing connection string passwords in my SSIS Configuration files?

View 12 Replies View Related

Can't Retrieve Connection String From Web.config - ASP.NET 2.0

Aug 1, 2007

All,
 I don't know what is the problem, i am not able to retrieve connection string from web.config  in my code behind page
I used every solution provided by people in differents forums.
can anybody help me with this.I used
WebConfigurationManager.OpenWebConfiguration("/TimeSheetApplication").ConnectionStrings("TimeSheetConnectionString").ConnectionString;
WebConfigurationManager.ConnectionStrings("TConnectionString").ConnectionString;

View 5 Replies View Related

Using The Web Config File To Set The Connection String In Asp.net 1.1

Sep 26, 2007

Currently we have a 1.1 app that sets the connection string as a Application variable, we are wanting to change that and place it in the web config file, when I do this  in 2.0 it's a simple process but in 1.1 it's different.  It doesnt seem to like the <connection string> tag, does it go in the appsettings tag and if so what should it look like and how is it referenced.

View 2 Replies View Related

Config File/ Connection Strings

Sep 27, 2007


Hello


I made certain changes in the properties in my Config file and by Change the ServerName and Database Name.
below is the example

When i execute the package it still runs. I mean theer is no server or database with that name but it still works.


<Configuration ConfiguredType="Property" Path="Package.Connections[ConManName].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=UHS137;Initial Catalog=UH_IntegrationStaging;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;</ConfiguredValue>
</Configuration>



Changed to


<Configuration ConfiguredType="Property" Path="Package.Connections[ConManName].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=NOSvr;Initial Catalog=NOdB;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;</ConfiguredValue>
</Configuration>


Then I created a new config file in which I checked in the box for ServerNam and when i change the name teher in the Config file

EXAMPLE


<Configuration ConfiguredType="Property" Path="Package.Connections[ConManName].Properties[ServerName]" ValueType="String">

<ConfiguredValue>NoSvr</ConfiguredValue>

and when executed teh package its fails.

Thats what I neede


SO coming to my question.
1)What is it doing. I mean how is the package talking to this config file
2) Irrespective of what I do in the Connection String the package executes fine, which It should not do as far as my understanding goes. Why is it doesn't matter whats in String. where as it matter in later.









View 5 Replies View Related

Sybase Connection In Xml Config File - Help

Jan 31, 2007

Hi all

I'm trying to connect to a Sybase DB using an OLE DB connection. Now, it works fine when I run the project without the package config enabled, but when I add the Sybase connection to the xml config file, & enable it the connection fails.

This is the error I see in the progress Tab

[Connection manager "AcidPrd.basketUser"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "ASE OLE DB Provider" Hresult: 0x80004005 Description: "Login Failed. Check for valid user ID, server name and password.". An OLE DB record is available. Source: "ASE OLE DB Provider" Hresult: 0x80004005 Description: "[Native Error code: 4002] [DataDirect ADO Sybase Provider] Login failed. ".

Can anyone help.

Thanks,

Jon

View 6 Replies View Related

How To Change The Connection String In A Web.config File

Mar 9, 2007

I've recently uploaded my website, http://www.bigredsongbus.com, to my host. Unfortunately, they don't support the use of SQL Server Express. So, I've purchased an addon through my host - discountasp.net. I've attached my database file to their server, now all that I need to do is to change the connection string in my .config file so that it points to the SQL Server. I don't know how to do this. Any help, please?Jeffrey Way 

View 2 Replies View Related

Referring To Sql Connection String In Web.config From Code Behind

May 15, 2007

Every time I move my project from my computer to the testing server I have to change the connection string references in the aspx side and in my code behind.
For the code behind I declared the SqlConnection string at the top of the code-behind page for both connection strings and comment out the one not in use. Obviously I then comment out the string not in use in the WebConfig as well.
Being superlatively lazy I always look for the easiest and quickest way to do most anything - connection strings included. Having to comment out strings twice brought rise to the question of whether I can refer to the connection string in the web.config file from the code-behind page. I'm sure it can be done, and I did a good amount of hunting around, but I couldn't find any examples of code that would do that.
Currently, as I said above, I have two connection strings declared at the top of my code-behind. Here's an example of one:Private sqlConn As New SqlConnection("Data Source=DATABASESERVER;Initial Catalog=DATABASE;User ID=USER;Password=PASSWORD")
 Then, I just use sqlConn as usual in my binding without having to "dim" it in every sub:sdaPersonnel = New SqlDataAdapter(strSqlPersonnel, sqlConn)
 Then there's the SqlConnections set up by the wizard on the aspx side:<asp:SqlDataSource ID="sqlDataSourcePayrollCompany" Runat="Server" ConnectionString="<%$ ConnectionStrings:DATABASECONNECTIONSTRING %>" ...>
 And for the connection in the web.config:<add name="DATABASECONNECTIONSTRING" connectionString="Data Source=DATABASESERVER;Initial Catalog=DATABASE;User ID=USER;Password=PASSWORD" providerName="System.Data.SqlClient" />
 So, what would be the code in the code-behind page to refer to the connection string in the web.config file?
Thanks!

View 2 Replies View Related

Using Web.config Connection Strings In Code Behind Files

Jul 2, 2007

in asp usually i have code behind files those .aspx.vb file.can i make use of connection strings in there? i am not really familiar with connection strings. actually shouldn't code behind files "simulate" code being in the .aspx file themselves? i seem to not able to share variables between them? 

View 2 Replies View Related

Windows Authentication Connection String In Web.config

Sep 1, 2004

How to add windows authentication connection string in web.config? My SQL server is WebServer, database is ORDER

View 1 Replies View Related

String Connection... At DataAccess Tier Or Web.config???

Mar 4, 2006

How can
ConfigurationManager.ConnectionStrings.Item("ConnectionString").ConnectionString
be embedded in the declaration of sqldatasource?
Thanks.

View 1 Replies View Related

Web.config, ConnectionStrings And SQL Named Instances Over A VPN Connection

Aug 29, 2007

Ok, here's the deal. This has been killing me for months now.

Here's the setup - SQL 2000 database on a Shared Infrastructure (cluster). I have a database on a named instance. My port number is xxxxx. I have dbo (through Windows Auth) permissions on my database. When I connect at the office, I get through fine, no question. When I connect at home, I get error 26 in my asp.net 2 app (using System.Data.SqlClient), cannot find SQL Server database. I can connect through the SQL 2005 Management Studio using the same servernameinstance name I use at the office. I can connect through the SQL 2000 Query Analyzer using servernameinstancename;(semicolon)portnumber. I've tried all sorts of combinations in my web.config -
servernameinstancename,(comma) portnumber
servernameinstancename;(semicolon - causes web.config to blowup) portnumber
ipaddressinstancename, (comma) portnumber

and i still get nothing. usually it's 'error 26' - but if i use this:


Data Source=ipaddressinstancename,portnumber;Network Library=DBMSSOCN;Initial Catalog=xxx;Trusted_Connection=Yes;

I get 'Login failed for user domainuser'

I've tried making an alias. I've tried using ODBC. I've even tried a freakin' DSN. No dice.

Nothing seems to work - I'm at the end of my rope. Can someone please help?

View 4 Replies View Related

Retreiving Connection Strings From Machine.config

May 12, 2006

Hi,

I'm trying to figure out how to retreive connection strings from the machine.config instead of storing the conn strings in a *.dtsconfig file. The reason that I'm trying to use the machine.config is for the simple reason that I'll be able to manage all of the conn strings in one location on each server. (Instead of mutliple dtsconfig files.) Is it posible to utilize the machine.config in SSIS? If so, could someone explain how, or better yet, have an example?

thanks for the help!

View 11 Replies View Related

Storing Connection Strings In Machine.config In SP2?

Mar 8, 2007

Is there now any way to store connection strings for use in SSIS packages in the machine.config with SP2?

View 4 Replies View Related

Dynamic Connection String (config File)

Dec 8, 2005

Hi,

View 3 Replies View Related

Web.config Connection String Being Used Based Off Enviroment Or Domain?

Feb 20, 2007

I used 3 seperate web.config files - one for Development seerver, one for Certification server, and one for Production server.  The only difference between these three is the within the <connectionStrings> tags. 
For Example:
<connectionStrings><add name="strConn" connectionString="server=xxx;uid=xxxx;pwd=xxxxx;database=yyy;"/></connectionStrings>
Within Development the connectionString points to the Development SQL server, Cert to cert SQL, and Prod to Prod SQL.  I do not have permissions to copy new Web.Config files into Cert or Prod, so when I have a change within my web.config I have to have another group manually add these files.
Is there a way to identify the domain I am curernt within and use a specific set of connections string within the web.config based off this information.  If so, can anyone post an example of how to do this...
 

View 3 Replies View Related

Dynamic Database Connection In SSIS Without Using A Config File

May 1, 2008

I'm a newbie to SSIS so this question may cause people to point and laugh. I apologise if that's the case.

I have a configuration database that holds connection details to a remote database. I want to use these connection details to dynamically create a new connection to some remote database.

I usually work in with C# where this would be simple but I can't find how to do this using SSIS.

I have found people using configuration files but as I already have my connection data in a table I don't really want to strip it out. (Also, is it a security risk to have database connection strings stored in a config file?)

I have been able to implement a custom script object to build the connection string and assign it to a user variable within the package but can't find any way to then use that variable to connect to the remote database.

Can anyone help?

View 6 Replies View Related

Synchronize Connection Strings Dialog Box With XML Config File

Aug 17, 2006

Hello,

This has been happening to me since I started using Configuration files.  I
use one XML config file that stores Machine Specific settings and one
connection string to my Metadata database.  The problem is the database
connection.

When I set the conection in the Configuation file, save, close and reopen
the package, a dialog box opens with the title "Synchronize Connection
Strings".

To reproduce the problem:

1. Ceate New SSIS Project
2. New Data Source Localhost.Adventureworks
3. In Package.dtsx  create an New Connection from Data Source...
4. Choose AdventureWorks
5. Save Package
6. Close Package
7. Open Package

There is no problem at this point.

8. Enable Package Configurations
9. Create a new XML Configuration File
10. Give it a name and a location
11. Click Next
12. Under Connection Managers Click Adventure Work
13. Click Next
14. Give it a Name
15. Click Finish

16. Save
17. Close
18. Open

Uh-Oh!

"Synchronize Connection Strings" Dialog Box
Hare is what it tells me.

Connection
Adventure Works

Data Source
Adventure Works

Old Connection String
Data Source=.;User ID=;Initial Catalog=AdventureWorks;Integration
Security=True;

Old Connection String

Data Source=.;Initial Catalog=AdventureWorks;Integated Security=True

19. Press OK

20. Save Package
21. Close
22. Open

Uh-Oh, still there.

Has anyone else run into this?  If so, how can I get around it?

Thank you for your help.

View 7 Replies View Related

How To Use ProviderName, User ID, Password, And Connection Saved In Web.config And SqlDataSource

Jun 1, 2008

Just downloaded and installed the VS 2008 Express and created/tested some websites.   I have done several aspx websites using VS 2005 during the last 2 years.  Still I don't quite understand the details of coding the database connection and DataBing.  For example, what does 'providerName',and Integrated Security really mean?Why in the Web.config file these are providerName="System.Data.SqlClient" and Integrated Security=True?  Why in Default.aspxthere are both ntegrated Security=True;and USER ID=WEB; Password=webwebweb1".  I know these may deal with the authentication mode of my SQL Serverdatabase.For the VS 2008 Express and SQL Server 2005 Express, I installed in my XP home PC, I used the file system websites,  If I upgrade to XP Pro and install IIS web server, and use SQL Server 2005, what might be different? Jeffrey Web.config <connectionStrings>        <add name="NorthwindConnectionString" connectionString="Data Source=D5MRY6G1SQLExpress;Initial Catalog=Northwind;Integrated Security=True"            providerName="System.Data.SqlClient" />    </connectionStrings>Default.aspx <asp:SqlDataSource ID="SqlDataSource1" runat="server"         ConnectionString="Data Source=D5MRY6G1SQLExpress;Initial Catalog=Northwind;Integrated Security=True; USER ID=WEB; Password=webwebweb1"         ProviderName="<%$ ConnectionStrings:NorthwindConnectionString.ProviderName %>"MasterDetail.aspx <asp:SqlDataSource ID="SqlDataSource2" runat="server"         ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"               

View 1 Replies View Related

SQL Jobs Calling SSIS Packages Within MSDB Not Referencing Connection Info In Config Files

Nov 13, 2007

I have deployed to production a number of nested packages (parent packages that call child packages) to the SQL msdb via the Save As option rather than building a deployment utility. These packages reference configuration files in a static location off of the c: drive on the production server. In the development environment, when connection changes are made and I run the Reload with Upgrade option the connection manager takes on the new server and user id settings. However, out on the production side I get the following error from the SQL job log:

Cannot load the XML configuration file. The XML configuration file may be malformed or not valid.

As a result the SQL job uses the default connection information which references the development database rather than the production database. I did research the error but found no good solutions. Is there a way to ensure the configuration files are formed correctly and that the packages are correctly referencing the configuration files? We are trying to run the ETL updates via a SQL job.

Any suggestions? Thanks.

T

View 3 Replies View Related

Config Error

Nov 23, 2006

I get this error. Does any body came across this and found some solution?





Compiler Error Message: CS0433: The type 'Microsoft.Web.UI.ScriptManager' exists in both 'c:WINDOWS.000Microsoft.NETFrameworkv2.0.50727Temporary ASP.NET Fileswebsites_hrdbms3acda2bba63d28c5assemblydl332deaeca05606e1_3759c601Microsoft.Web.Atlas.DLL' and 'c:WINDOWS.000assemblyGAC_MSILMicrosoft.Web.Extensions1.0.61025.0__31bf3856ad364e35Microsoft.Web.Extensions.dll'




I have created the application with ATLAS July CTP . currently upgraded to ASP.NET AJAX BETA 1. I face the above problem

View 1 Replies View Related

Reports.config Error

May 31, 2007

Dear All,

Recently i have installed Ms CRM 3.0 on a server wich uses IIS as platform and CRM application as default website. And, the Report Server is running when i access it using Ms internet explorer but when i try to using the application I receive an error message that says " Reports.config has invalid schema and could not be loaded " any Ideas!!! I need a solution ASAP so your help is highly appreciated and thx

All regards,

View 1 Replies View Related

WMI Config Error On Vista

May 15, 2008

I've not found the answer to this one as it applies to Vista. When installing SQL Server Express which was downloaded from the microsoft website, I get the message "SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine....."
I have tried the wmifix program with no results. Also followed a link to another fix that wasnt appropriate for Vista.
Any help would be appreciated. I am logged in as an administrator, and am running Vista Home Basic.
Thanks for your help.

View 10 Replies View Related

Why Is It I Keep Getting An Error 40 When Trying To Config ASP.NET 2.0 To Use SQL Server 2000

Mar 2, 2007

I'm trying to configure  ASP.NET2.0 Application to use SQL Server 2000  and yes i did make sure all my setup in configuration manager is setup and  the surface area
Whenever i ran the REGSQL .EXE CMD it works until i get to  where it suppose to give you a list of data instance to choose from base on ScottGu article  in step 4
I'm running SQLEXPRESS ADVANCE
VWD EXPRESS 05
Thanks

View 2 Replies View Related

Config Error (Oracle 10g Source)

Sep 10, 2007

Hello All

I was trying to configure my package. I have a Oracle 10g DB as source. I used "Oracle provider for OLE Db" as provider in connection manager. I entered user name and password.

When I set my package protection level to : DontSaveSensitive and executed the package
it gives me this error:

[Connection manager "WDEV.wuser1"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005: null password given; logon denied".

When i go back to connection manager I see the blank password. I retype it but again when I execute I get the above error.

I configured the package with same setting and in the config file I mentioned the passwords and all details but again I when I execute the package i get the below error:

[Connection manager "WDEV.wuser1"] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".



Since it was not storing password OR not executing without password I set the Protection Level to : "EncryptAllWithPassword"

and excute it I works Great. and runs Awesome. Except I get this Warning
[OLE DB Source [1]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Question 1: "CAN I IGNORE THIS WARNING?'
Question2: "THE PACKAGE RUNS GOOD WHEN I SET THE PROTECTIONLEVEL =EncryptAllWithPassword. With this settings when i configure my package it gives me error. Why is it so Any Help please Below plz find the config file?"

[OLE DB Source [1]] Error: The AcquireConnection method call to the connection manager "WDEV.wuser1" failed with error code 0xC0202009.
[Connection manager "WDEV.wuser1"] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".


x<?xml version="1.0" ?>

- <DTSConfiguration>


- <DTSConfigurationHeading>


<DTSConfigurationFileInfo GeneratedBy="AWM" GeneratedFromPackageName="Package1" GeneratedFromPackageID="{289810A-ASD0-4698-BAC5-3270D3E5D17D}" GeneratedDate="9/9/2007 10:18:10 PM" />
</DTSConfigurationHeading>

- <Configuration ConfiguredType="Property" Path="Package.Connections[WDEV.wuser1].Properties[ConnectionString]" ValueType="String">


<ConfiguredValue>Provider=OraOLEDB.Oracle.1;Data Source=WDEV;User ID=wuser;Password:XYZ;</ConfiguredValue>
</Configuration>

- <Configuration ConfiguredType="Property" Path="Package.Connections[WDEV.ccuser1].Properties[InitialCatalog]" ValueType="String">


<ConfiguredValue />
</Configuration>

- <Configuration ConfiguredType="Property" Path="Package.Connections[WDEV.wuser1].Properties[Name]" ValueType="String">


<ConfiguredValue>WDEV.wuser1</ConfiguredValue>
</Configuration>

- <Configuration ConfiguredType="Property" Path="Package.Connections[WDEV.wuser1].Properties[Password]" ValueType="String">


XYZ<ConfiguredValue />
</Configuration>

- <Configuration ConfiguredType="Property" Path="Package.Connections[WDEV.wuser1].Properties[ServerName]" ValueType="String">


<ConfiguredValue>WDEV</ConfiguredValue>
</Configuration>

- <Configuration ConfiguredType="Property" Path="Package.Connections[WDEV.wuser1].Properties[UserName]" ValueType="String">


<ConfiguredValue>wuser</ConfiguredValue>
</Configuration>

- <Configuration ConfiguredType="Property" Path="Package.Properties[PackagePassword]" ValueType="String">


<ConfiguredValue /> AWM
</Configuration>
</DTSConfiguration>




Thanks a lots

View 2 Replies View Related

Sql Agent Throwing Config Error I'm Not Using

Feb 20, 2008

OK so I have this SSIS package that uses a connection call "Conn1". I added this to my configuration file (which also contains connections called "Conn2" and "Conn3" which are used by other packages. Works fine in DEV when run via SQL Agent. I moved SSIS package and config file to prod server. SQL Agent now throws error on this package saying it cannot resolve path to "Conn3". This package doesn't use "Conn3"... I opened both the SSIS package and the Config file in notepad and verified Conn3 wasn't referenced in the package... HELP !!!!

View 3 Replies View Related

WMI Config Error Installing SQL2K5 Standard Edition

Jun 1, 2007

I am dealing with the same issue posted in this other thread that seems to have died with no solution found:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1131407&SiteID=17

Almost as soon as I start to install SQL 2005 on my Windows XP Pro Version 2002 Service Pack 2 machine at work it pops up a dialog with one of the following 2 error messages (they alternate randomly):

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine PCF092191 Error:2147500034 (0x80004002).

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine PCF092191 Error:2147749907 (0x80041013).

After clicking OK the installation just closes.

I also discovered when I load wmimgmt.msc and click Properties on the WMI Control, I get the following errors on the General tab, AND it does not allow me to click on any other tabs:

Failed to initialize all required WMI classes.
Win32_Processor: <Null>: No such interface supported
Win32_WMISetting: Successful
Security information: Successful
Win32_OperatingSystem: <Null>: No such interface supported

I have been searching online for days and tried doing virtually everything I found that I could understand and nothing works. Reinstalling WMI off the XP CD doesn't work, rebuilding the WMI repository doesn't work, registering all the WMI DLLs and MOF files doesn't work, running all the various scripts to fix WMI that are posted all over online doesn't work.

I downloaded the Microsoft WMI Diagnostics tool and ran it. It printed a ton of errors in a 466-line report that I can't make head or tail of. 6 here, 33 there, 27 over there...almost too many to count. The suggestions it gives to fix them range from vague and incomplete to incomprehensible. I'll paste those error results into a followup post.

I installed the WMI Tools package and can't figure out what to do with any of the tools at all. The only thing I noticed is that when examining a section under Win32_Processor, most entries for various properties are marked <empty>, while I have seen people discussing what I think are those same properties online and talking about seeing stuff typed into theirs (such as the HostingModel having LocalServiceHost typed in and ImpersonationLevel having 1 typed in). But there are so many properties and I'm not sure what should be typed into all of them or if I'm even looking in the right place.

I've seen some suggestions in WMI documentation that not all WMI errors may be related to WMI itself at all, which I think might be the case here, but I don't know. Some material said DCOM may be the problem, but I didn't have much luck figuring out how to fix that either. From the WMI Diagnostics it looks like there may be multiple errors of different kinds, but if it's that bad, I don't know how my computer's been working at all.

I've been using this computer for 9 months and had no major problems with it, although I did have a problem installing Microsoft Windows Genuine Advantage Notification, for which Microsoft sent me a script that fixed it. One other person here at work is suffering from this same WMI error, but most people have been able to install SQL 2005 here with no problem.

My boss does not want me to just do a full XP reinstall. He wants me to identify the specific problem and fix it. If this was my home computer I wouldn't spend so much time banging my head over this incomprehensible problem. But a full reinstall is not really an option for me in this case, unless maybe Microsoft says that's the only way to fix it.

I am available to deal with this issue during 9 to 5 eastern time Monday to Friday.

Thanks in advance for any help...
Eric

View 3 Replies View Related

WMI Config Error Installing SQL2k5 Standard Edition

Jan 19, 2007

This is (some of) the output from the Core(Local)log:

If possible, determine action
Machine = DJONES-XP, Article = WMIServiceWin32OSWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceWin32CompSystemWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceWin32ProcessorWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = DJONES-XP, Article = WMIServiceWin32DirectoryWorking, Result = 70347 (0x112cb)
Machine = DJONES-XP, Article = WMIServiceCIMDataWorking, Result = 70347 (0x112cb)
Machine = DJONES-XP, Article = XMLDomDocument, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: DJONES-XP
*******************************************
Article: WMI Service Requirement, Result: Error
Description: Windows Management Instrumentation (WMI) is not functioning properly. Further checks cannot be performed. Action: Please make sure Windows Management Instrumentation (WMI) is functioning properly.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine DJONES-XP Error:2147500034 (0x80004002).
The checkResult returned is 2147500034
The checkResult for local machine returned by CheckSCCResult is 70036
Setup is unable to proceed because one of scc articles failed. Please address those errors before continuing the setup.

Thanks DeWayne

View 14 Replies View Related

Null Reference Error When Using A Custom Assembly That Uses An App.config File

Apr 7, 2008

I have a custom assembly that uses a config file to obtain database connection settings. This dll is then used by my sql report. I have added refrerenced to all the required dll's in my report and added the required code groups to all the necessary files. I have also placed my app.config file in C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer and C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies
However when I actually run the report in the designer (vs2005) I am receiving Null reference exceptions when my code tries to read my config file because it is reading the machine.config file and not my app.config file. If I hard code my connection string everything works fine.

Can anyone tell me why the machine.config file would be referenced instead of my app.config file and how I can stop it from doing this?

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved