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_hrdbms3acda2bba63d28c5assemblydl332deaeca 05606e1_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
ADVERTISEMENT
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:Prototypeofficial1htmlewpriority.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
View Related
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
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
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
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
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
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
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
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
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
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
Jul 2, 2007
Hi
While trying to build SSIS Package Project, the following error is thrown. I have added configuration file recently to fetch the dynamic values such as connection string, output path etc.
I tried manually cleaned up the debug folder and tried build but still the error occurs.
Can any one help in suppressing this error?
Error 1 System.ApplicationException: Could not copy file "D:ExportExport.dtsConfig" to the deployment utility output directory "D:ExportinDebug". ---> System.IO.IOException: The file 'D:ExportinDebugExport.dtsConfig' already exists. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) --- End of inner exception stack trace --- at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CreateDeploymentUtility(IOutputWindow outputWindow) 0 0
Thanks in advance,
Prabha
View 1 Replies
View Related
May 14, 2007
I have been using Sql server Reporting services 2000 and i never had these
problems
I tried firing up my Sql server Reporting services 2005 today i went
through the reporting services conf manager
and then got to the "database setup" stage and bingo can't get through this
error below
* On my PC i have Reporting services 2000 and Reporting services 2005 installed and my
is working ok
ReportServicesConfigUI.WMIProvider.WMIProviderException: An error occurred
when attempting to connect to the report server remote procedure call (RPC)
end point. Verify that the Report Server Windows service is running, and
then retry the operation.
---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC
server is not listening. (Exception from HRESULT: 0x800706B3)
--- End of inner exception stack trace ---
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]&
serverInfos)
Looked for some info and got a hint here at:
http://blogs.msdn.com/bimusings/archive/2005/08/23/455263.aspx
But still can't get it to fox it..
Also with the Encription Keys i anytine i try to delete it BINGO again i
get the error above..
These error has been given people nigtmares and it isn't new does anyone
know the fix for this error..
Hope someone from Microsoft could help
View 7 Replies
View Related
Sep 2, 2015
Currently have a single hard coded file path to the SSRS config file which parses the file and provides the reporting services web service url. My question is how would i run this same query against 100s of servers that may or may not share the same file path as the one hard coded ?
Is there a way to query the registry to find the location of the config file of any server ? which could be on D, E, F, H, etc.
I know I can string together the address followed by "reports" and named instance if needed, but some instances may not have used the default virtual directory name (Reports).
Am I going about this the hard way ? Is there a location where the web service url exists in a table ? I could not locate anything in the Reporting service database. Basically need to inventory all of my reporting services url's.
View 2 Replies
View Related
Apr 4, 2007
Hello all,
I'd like to know what's considered a best practice in the following scenario...
We're in the process of converting DTS to SSIS, our current SQL2K setup has one DTS package per database, each database and package are mirror images of each other, with the exception of connection properties and the files path's they pull from. (Occasionally there may be a one off Execute SQL Task that differs from package to package...but this will be handled in a different manner outside of the package from this point on)
From a administration perspective this has been somewhat cumbersome, as every time there is a schema change we need to update the transformations in each individual package...after updating 120 packages my index finger has a bad case of carpel tunnel!
My thought with SSIS is that I can create one package, with many configuration files (one for each database).
Now my question is, 1) is this a good idea? 2) Anytime we create a new database (New Customer = New Database) and need to create a new xml config file, do I have to create the config in BIS/SSIS package then redeploy the package?...or Can I simply add a new config file to the appropriate directory and reference this config in the scheduled job?
Any suggestions are greatly appreciated!
View 1 Replies
View Related
Oct 31, 2007
Hi,My application is acting weird and the research I've done leads me to an answer why it's breaking, but not how to fix it.My web app is hosted by a remote company. I have the main website sitting in the root web directory and in a subfolder I have another application that will handle login and updating the content in the SQL 2K5 backend (not an Express DB).The website itself is able to pull in informaiton from the DB without any trouble, so I know it's able to connect to the DB and everything is peachy. The login app though is acting as though it can't get to the DB. I've applied the ASPNET schema to the DB using the aspnet_regsql.exe from the framework and the login application is using the same connection string as the main website.One thing to note here is that the website and the login app have seperate web.config files since they were developed as different projects.With my customized provider defined in the web.config for the login app I get this error on page load:"Parser Error Message: It
is an error to use a section registered as
allowDefinition='MachineToApplication' beyond application level. This
error can be caused by a virtual directory not being configured as an
application in IIS." If I comment out the custom provider, the page loads but when I try to create a user it tells me that "...the SQL Server couldn't be contacted. This may be because it doesn't accept remote connections." Thing of it is that it's not a remote connection and it's the same connection string and db as the other site.Now, the research I've done points at the two different web.config files, which makes sense. But how do I make the one web.config work for both the website and the subdirectory with the login app? Keep in mind that I can't create any new virtual directories or modify IIS since this is a remote hosting company.Can someone help me understand the fix with a little more clarity?
View 1 Replies
View Related
Mar 30, 2007
Hi,
I'm kind of the first person at my new company to start a project using SSIS. My question(s) revolves around setup and configuration, maybe even best practices.
1. Connection Manager Config - What are some of the methods you use to config your connection managers? I was planning on creating a folder (C:SSISConfig or something) and keeping a config file for each connection there. That way it would be fairly trivial for each developer to also put said folder on there box for deving.
2. Solution set up - Are people creating solutions for each package or just using one Master solution and adding all the packages to that? Or maybe some combination, like having solutions for different areas of functionality or something..? I'm trying to figure out what the pain points are with different approaches.
If you have any other information or horror stories about SSIS that you think might help, feel free to pass them along.
Thanks,
-Ryan
View 1 Replies
View Related
Mar 10, 2007
I want to make an application using a distributed database (single logical database, parts of which are located at more than one location or more than one server). It acts as a single collection of data but the database itself is geographically in separate locations.
How do I make it in SQL Server 2005?
View 4 Replies
View Related
Jul 10, 2006
Hello All,
I am trying to use a custom C# dll from within a script task. The C# dll relies on the Enterprise Library 2.0. Where do I put the enterprise library configuration when I am debugging a package and then when I have the package in production. I cannot find any documentation anywhere on this.
Thanks for any help,
Justin
View 5 Replies
View Related
May 24, 2007
Does anyone have an example of a web.config file that works with Dynamic Data controls? I asked because I can't seem to arrange my "config sections" in any working order. I use 1 connection string in the web.config to establish a conversation with the database. Thanks in Advance.
View 1 Replies
View Related
Nov 15, 2007
I am using vs2005 and have a solution file with 4 projects, 2 of which are presentation layers (admin sections), 1 is a business logic layer, the other a data access layer.
The data access layer project is simply a class library that will provide data access functionality. Im using a dataset (xsd) to create my data access objects. My question is how do I select a connection string from the web config file (which is in each of the presentation layer projects) as the data access layer is a class library there is no web.config. Using the connection string selector in the dataset wizard doesnt show any available connection strings.
View 1 Replies
View Related
Feb 21, 2008
Hi the data connectionstring will be generated automatically in web.config file after dragging a data table from database into webpage.for example: <configuration> <add name="SQLProfileConnString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|MSPetShop4Profile.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </> But what if I have to write the connectionString part myself, I mean where I can get the syntax of it? Thanks a lot
View 1 Replies
View Related
Nov 21, 2003
When I connect locally, my app runs fine. But when I try to connect via FTP to a dedicated server, I can't connect at all. My connection string is in the web.config file. I noticed that the sessionState in web.config is automatically generated with the standard sa blank pwd. I still can't connect even when I change this to the correct uid and pwd. Does anyone know what I need to do? My conn string's data source is "." Please help.
Thank you,
Tina
View 22 Replies
View Related
Apr 6, 2006
I've defined my connection string in the web.config file:
<add name="RealtorXConnectionString" connectionString="Data Source=localhostSQLExpress;Initial Catalog=RealtorX;User ID=sa;password=welcome" providerName="System.Data.SqlClient" />
Now I want to get that string and use it in some code where I'm going to run a query against the database. This query happens in PageLoad, and won't be bound to any UI component. How can I replace XXXXX below with the value stored in web.config?
Dim strConnection As String = XXXXX
Dim cn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(strConnection)
cn.Open()
View 4 Replies
View Related
Aug 6, 2007
This was directly from BOL.
/Conf[igFile] filespec
(Optional). Specifies a configuration file to extract values from. Using this option, you can set a run-time configuration that differs from the configuration that was specified at design time for the package. You can store different configuration settings in an XML configuration file and then load the settings before package execution by using the /ConfigFile option.
Does this mean that I can specify which configuration file to use during runtime?
Or is just because I'm too desperate for that, I understood that way
Thanks
View 14 Replies
View Related
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
Feb 19, 2008
I have a simple SSIS Package where the Connections are specified in Configuration files, which was built locally and I wanted to deploy it to a server. Looking at the different options I decided to try the "Import Package..." from Management Studio (SSMS), since I have limited access to the server (and no access to the file system). It does appear to have imported the package from the local file system to the servers "SSIS Package Store".
My question is, what happened to the Configurations files when a package is imported?
When I "Run Package" from SSMS, the Execute Package Utility shows Connection Managers with only part of the connection info, but it executes just fine. Also, it shows no Configurations at all.
My impression is that during "import" the connection managers are created from a snapshot of the current Configurations, so what ends up in SSIS are static connection managers, not Configurations. However I can't seem to find any documentation one way or the other. Also, I suspect that the only reason the partial connection info actually works is due to dtexecUI (?) running locally under my own account.
Any information is greatly appreciated.
Thanks
View 3 Replies
View Related
Mar 25, 2008
I have a simple SSIS package which includes one Analysis Services Processing Task. I have created a connection manager object (cmo) and assigned it to the AS task. Within the cmo I selected a specific user name and
password to log on to the server with. Tested this [domain][user account] and it works. Now here is the problem. When I run the package either in debug mode or from a command line, the packages ignores the connection manager and
attemps to use the account I am logged into the server with.
Using a config file to hold the credentials does not work either. When DTEXEC is used, the package attempts to use the credientials used to log in to the server.
Does anyone have any ideas why this is happening?
View 4 Replies
View Related
Dec 12, 2007
Hi All!
I've been struggling with a problem I have. When I use DTEXECUI to run a package and manually add the config file, it gets ignored and there is no warning as such.
Here's the set up:
1) create SSIS package that uses a DB connection
2) enable config, add XML config, export the connection string, disable config
3) edit config file, change connection string
4) open package from Windows Explorer (double click)
5) add config file created in step 3
All of that works fine, but there are times when it doesn't. I think it depends on the editor used in step 3. If I use textpad and "pretty format" the XML (from the huge one-line built from within Visual Studio), then sometimes the changes aren't picked up. I can tell this because the "default" server in development is not accessable in production. When we "reformatted" the XML back to one line, the correct server was connected to.
I have no idea what the problem with the formatted XML was. I thought it was CRLF vs LF, but I have at least one config that formatted that way and it works fine. My current thought is character encoding when using TextPad.
My biggest problem is that DTEXECUI doesn't tell you that the config file isn't going to be used. It just ignores the "bad" config format and goes on its merry way using the information in the package itself. That really scares me.
Has anyone else seen this? What is the problem being introduced into the config file?
Thanks,
Frank
View 3 Replies
View Related
Jul 10, 2007
Hi,
I have configure our ssis project that will take the connection string from the database
but when i change the connection string so the pckg will take the data from another server with exact tables name it fails.
what do you think the problem is ??
View 7 Replies
View Related
Mar 30, 2006
I am new to SSIS. I created a XML configuration file for my package. I found lots of data on how to do this but I can't find anything on how to get the values back out. I am trying to get them out in a Script file. Any help and maybe examples would be appreciated.
View 4 Replies
View Related
Nov 20, 2006
Hello all
I need to know the best way to work with databases (Sql Server) in my app.config.
I have an VB application that binds data from a SQL server (All Customers install these application and retrieve data via VPN). I use two databases for each customer. The first DB has some commun tables/data and the second one is its ID (Until now I setup manually the connections because we don't have more that 10 Customers but we need improve that for next year). I know that a connection string is created in the app.config file .
I don't know if it is possible from this way or if there is another way to do it.... but the goal is:
1. Customer is logged in the application -User Name, ID, Password
2. Customer retrieve a database with commun data and his own database (that is his ID). (From the app.config???) How can I setup my app.config in order that every customer retrieve his database automatically when it is logged?
Thaks, I don't know if it's clear but I didn't find another way to explain my trouble
View 1 Replies
View Related
