Dynamic ConnectionString For SqlDataSource

Mar 20, 2008

I have a datasource on my ASP.NET 2.0 control I want to make dynamic.  I have 6 different connection strings in my web.config file and want to change the connection with the selection in dropdownbox.

Here is my VB code:Protected Sub GetDatabase(ByVal intDb As Integer)
Select Case intDb


Case 1 ' Americas

srcCustomers.ConnectionString = "RWSqlServer"

Exit Sub

Case 2 ' Asia

srcCustomers.ConnectionString = "SGSqlServer"

Exit Sub

Case 3 ' Australia

srcCustomers.ConnectionString = "SYSqlServer"

Exit Sub

Case 4 ' Canada

srcCustomers.ConnectionString = "MSSqlServer"

Exit Sub

Case 5 ' EMEA

srcCustomers.ConnectionString = "NCSqlServer"

Exit Sub

Case 6 ' NE

srcCustomers.ConnectionString = "RUSqlServer"

Exit Sub

End Select

End SubProtected Sub ddlBusinessUnit_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)


If (ddlBusinessUnit.SelectedIndex = 0) Then

panUser.Visible = False

panDistributor.Visible = False

panEndUser.Visible = False

GetDatabase(ddlBusinessUnit.SelectedIndex)

lblDb.Text = ddlBusinessUnit.SelectedIndex.ToString

Else

 

panUser.Visible = True

End If

End Sub

Here is my ASP.NET code:<asp:SqlDataSource ID="srcCustomers" runat="server" SelectCommand="SELECT cm_addr + ' - ' + cm_sort AS [name], cm_addr, cm_sort FROM cm_mstr WHERE cm_type <> 'I'">

</asp:SqlDataSource><asp:DropDownList ID="ddlBusinessUnit"

runat="server"AutoPostBack="True"

OnSelectedIndexChanged="ddlBusinessUnit_SelectedIndexChanged">

<asp:ListItem Value="" Text="Select One"></asp:ListItem>

<asp:ListItem Value="1" Text="Americas"></asp:ListItem>

<asp:ListItem Value="2" Text="Asia"></asp:ListItem>

<asp:ListItem Value="3" Text="Australia"></asp:ListItem>

<asp:ListItem Value="4" Text="Canada"></asp:ListItem>

<asp:ListItem Value="5" Text="EMEA"></asp:ListItem><asp:ListItem Value="6" Text="NE"></asp:ListItem>

</asp:DropDownList>

What am I missing?  Do I need to reference the whole connection string or is there a way I can reference the "NAME" id in the web.config file for the connection string?

View 2 Replies


ADVERTISEMENT

How To Assign ConnectionString To A SqlDataSource Within The Namespace?

Apr 16, 2007

hi
i am trying to assign ConnectionString to a SqlDataSource   within the namespace but i am getting this error
plz advise
 
Object reference not set to an instance of an object. 
namespace myNameSpace{   
    public partial class NRP : System.Web.UI.Page    {            SqlDataSource sds1;
        protected void Page_PreInit(object sender, EventArgs e)        {            sds1= new SqlDataSource();            sds1.ID = "sds1";            this.Controls.Add(sds1);
            sds1.ConnectionString = ConfigurationManager.ConnectionStrings["my_conn_str"].ToString();
        }    }}
 

View 1 Replies View Related

SQLDataSource Dynamic DB

Nov 14, 2006

Hello,
Has anyone used/fiqured out how to set one of the properties below to a variable with a dynamic database.
<asp:SqlDataSource ID="Sql_Imports" runat="server" selectcommand='EXEC <%# Session("CompanyDB") %>..IMPORT_S' ConnectionString=""></asp:SqlDataSource>
You would have thought that Microsoft would have allowed catalog/database on this command.
 Thanks.

View 2 Replies View Related

Dynamic SqlDataSource

May 14, 2007

Ok, here's my situation.
 I have a dynamic page that accepts a "type" query string.  This type query string is the name of a table I want to display on the page in the GridView.  Creating a different SqlDataSource/Strongly typed class for every type isn't possible because I need to make this flexible for future updates.  So therefor I basically need to be able to Sort, Page, Edit and Delete with the Grid View without knowing the table name at compile-time.
 Any help is appreciated,
Thanks!

View 3 Replies View Related

SqlDataSource : Dynamic SQL : Apostrophe

Sep 20, 2007

OK so I need to use a dynamic SQL statement in a SqlDataSource object because I need to pass in the column name.  I'm having trouble accounting for the apostophes I have to interpret literals within the statement.  This is connecting to an Oracle database.
This is what I originally tried...
<asp:SqlDataSource ID="SqlDataSourceMine" runat="server" ConnectionString="<%$ ConnectionStrings:My_Connection_String %>" ProviderName="<%$ ConnectionStrings:My_Connection_String.ProviderName %>" SelectCommand="SELECT m.YIE, :selecteditem, m.ENDTIME FROM MyMAP.MAP_M_SUM m WHERE (m.GROUPID LIKE 'YC%' AND m.GROUPID NOT LIKE 'YCX%' AND m.ENDTIME >= SYSDATE-14)">    <SelectParameters>        <asp:ControlParameter Name="selecteditem" ControlID="itemlabel" PropertyName="Text" Type="String" />    </SelectParameters></asp:SqlDataSource>
And the second column returned as :selecteditem for the column name and the value of itemlabel.text (what I wanted to be the column that was queried) as the value in each of the rows of that column.  So I tried dynamic SQL to put the value of itemlabel.txt as the column to be queried, but I'm not sure how to get the query to read the literals.  How can I accomplish this?
<asp:SqlDataSource ID="SqlDataSourceMine" runat="server" ConnectionString="<%$ ConnectionStrings:My_Connection_String %>" ProviderName="<%$ ConnectionStrings:MY_Connection_String.ProviderName %>" SelectCommand="EXEC('SELECT m.YIE, '+selectedbin+', m.ENDTIME FROM MMAP.MAP_M_SUM m WHERE (m.GROUPID LIKE '+paramlike+' AND m.GROUPID NOT LIKE '+paramnotlike+' AND m.ENDTIME >= SYSDATE-14)')">    <SelectParameters>        <asp:ControlParameter Name="selectedbin" ControlID="binlabel" PropertyName="Text" Type="String" />        <asp:ControlParameter Name="paramlike" ControlID="Label1" PropertyName="Text" Type="String" />        <asp:ControlParameter Name="paramnotlike" ControlID="Label2" PropertyName="Text" Type="String" />    </SelectParameters></asp:SqlDataSource>
This errors to "illegal variable name"
Can someone help me out please?  Thanks a lot.
-steve

View 3 Replies View Related

SqlDataSource And Dynamic SelectCommand

Jan 16, 2006

Good morning.I'm writing an application that allows users to generate Personal Leave requests and route them to their managers.I'm using the integrated Windows Authentication, so I'm able to get the user's username from HttpContext.Current.User.Identity.Name.How do I dynamically generate the SelectCommand?  Right now, I do:Dim strQuery As String = "SELECT * FROM [tblPLRequest] WHERE employee = '" & strUsername & "'"to get the query I want, but when I set my SelectCommand to that, it thinks it's a stored procedure (and can't find it).Am I going about this in the completely wrong way?Thanks.

View 3 Replies View Related

Dynamic SELECT Command In SqlDataSource

Jul 20, 2007

I have a GridView (that uses SqlDataSource1) and a Dropdownlist.  Depending upon the value selected on the DropDownList I need to select different stored procedures for the gridview.  The problem is that I can do it without taking SqlDataSource1 by using DataSet or DataTable.  But, I need to Use SQLDataSource1 for easy way of Header SORTING.  So, is there any way to change the SQLDatasource1.SELECT Command dynamically. So that, I can use different queries for the Single DataGrid. I have attached the sample code of the SqlDataSource1 I'm using.  I need to change the Command i.e. SelectCommand="usp_reports_shortages" to "usp_reports_shortagesbyID" and "usp_reports_shortagesbyDate"     depending on the value selected in the dropdownlist.  So, is there any way to do this????<asp:SqlDataSource ID="SqlDataSource1"
runat="server"
ConnectionString="<%$
ConnectionStrings:TESTDrivercommunication %>"


    SelectCommand="usp_reports_shortages" SelectCommandType="StoredProcedure">


    <SelectParameters>


        <asp:ControlParameter ControlID="lblDriver" Name="date1" PropertyName="Text" Type="DateTime" />


        <asp:ControlParameter ControlID="lblTODate" Name="date2" PropertyName="Text" Type="DateTime" />


        <asp:ControlParameter ControlID="DDlDriver" Name="driver" PropertyName="SelectedValue"


            Type="Int32" />


        <asp:SessionParameter Name="week" SessionField="s_week" Type="DateTime" />


    </SelectParameters>


</asp:SqlDataSource>

View 1 Replies View Related

Dynamic SqlDataSource Select Command?

Apr 25, 2008

I am trying to implement an "advanced search" feature on my ASP.NET 2.0 web form.  I have a GridView control and a SqlDataSource.  The SqlDataSource control successfully retrieves data when the SelectCommand attribute is set in the aspx page.  I need to make it so when a user clicks on a button, it can take a value from a text box and use it in the WHERE clause.  I have tried setting the SelectCommand programmatically and then DataBinding but it never accepts the new SelectCommand. What can I do to fix this?

View 5 Replies View Related

[SQLDatasource]Dynamic Selection Of Column

Mar 29, 2006

Hey, I have a search form with a selectbox. This selectbox contains the columnnames.I want when I put a text in a textbox and select a value in the selectbox and click submit that it search database.The Columnnames I put in a session.
If you see I have put in the querystring as columnname @sescolumn which I have initialised as asp:sessionparameter.But it gives no results. When I put @sescolumn between [] like normal columnnames are it doesn't work also.
Can someon put my on the right path?

 
<asp:SqlDataSource ID="Database_ecars" runat="server" ConnectionString="<%$ ConnectionStrings:connectionstring %>"
SelectCommand="SELECT [AutoID], [Merk], [Kleur], [Type], [Autotype], [prijs], [Zitplaatsen], [Afbeelding1], [Afbeelding2], [Afbeelding3], [Afbeelding4] FROM [Auto] where @sescolumn like @seskeyword and [AutoID] not in (select [AutoID] from [verhuring] where [StartVerhuur] >= @sesdatefrom and [Eindeverhuur] <= @sesdatetill)" >
<SelectParameters>
<asp:SessionParameter Name="sesdatefrom" SessionField="datefrom" Type="Decimal" />
<asp:SessionParameter Name="sesdatetill" SessionField="datetill" Type="Decimal" />
<asp:SessionParameter Name="seskeyword" SessionField="keyword" Type="string" />
<asp:SessionParameter Name="sescolumn" SessionField="columnname" Type="string" />
</SelectParameters>
</asp:SqlDataSource> 

View 3 Replies View Related

What Different Are There Between ConnectionString (Part 1) And ConnectionString (Part 2) In Web.config

Apr 12, 2006

What different are there between connectionString (Part 1) and connectionString (Part 2) in web.config
The CCWW is my PC's name, normally I can connect to the database ASPNETDB.MDF correctly either Part 1 or Part 2 in a web page,After I open Database Explorer panel and browse ASPNETDB.MDF, I can't connect to database using Part 2 when I open a webpage in Microsoft Visual Web Developer 2005 Express Edition,but I can correctly open a webpage using Part 1 after I open Database Explorer panel.
What different are there between connectionString (Part 1) and connectionString (Part 2) in web.config?
I guess  while I use Part 1 to connect, maybe it will be cancel exclusive method of the database  ASPNETDB.MDF first, but when I connect to database using Part 2, maybe two programms both Part 2 and Database Explorer visit ASPNETDB.MDF at the same time!
 
--------------------------------------Part 1------------------------------------------------------------------------<add name="MyConnect" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|ASPNETDB.MDF"          providerName="System.Data.SqlClient" />  --------------------------------------Part 1------------------------------------------------------------------------
--------------------------------------Part 2------------------------------------------------------------------------<add name="MyConnect"  connectionString="Data Source=CCWWSQLEXPRESS;Initial Catalog=ASPNETDB.MDF;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|ASPNETDB.MDF"     providerName="System.Data.SqlClient" />--------------------------------------Part 2------------------------------------------------------------------------

View 2 Replies View Related

ConnectionString

Mar 1, 2008

Just installed Express edition on my laptop and don't know how to set up the connection string in my aspx.vb page.
I've added my connection in the webconfig page and want to set up the vb page.  This is not working please tell me what's missing in the Dim conn section.Protected Sub SubmitInfo_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubmitInfo.Click
Dim conn As ConnectionStringsSection = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|BEEN.mdf;Integrated Security=True;User Instance=True"Dim cmd As New Data.SqlClient.SqlCommandWith cmd
.Connection = conn
.CommandType = "AddUserInfo".Parameters.AddWithValue("@FName", Fname.Text)
.Parameters.AddWithValue("@LName", LName.Text).Parameters.AddWithValue("@Email", Email.Text)
.Parameters.AddWithValue("@Comments", Comments.Text)
End With
conn.Open()
cmd.ExecuteNonQuery()
conn.Dispose()
End Sub

View 2 Replies View Related

ConnectionString

Nov 24, 2005

Hi I'm using Sql Server (SQLOLEDB.1) and I want to connect it by Sqlconnection.those are the details:user Id: saPassword: *****database: ServiceManagementserver name: KLXPE002KULMOSWhat should be the Connection String? Thats what i did:
"Persist Security Info=True;Integrated Security=SSPI;server=SQLOLEDB.1;database=ServiceManagement;Data Source=KLXPE002KULMOS;User ID=sa;password=****"It doesn't work.thnxItai

View 3 Replies View Related

Help With ConnectionString

May 11, 2006

Hello,
I have just tried to deploy my app from my local pc to our server and I have been getting this error.
Server Error in '/' Application.


Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.Source Error:



Line 164: <providers>
Line 165: <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/"
Line 166: type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 167: <add name="AspNetWindowsTokenRoleProvider" applicationName="/"
Line 168: type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />Source File: C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Configmachine.config    Line: 166


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
I am new to SQLExpress 2005 and asp.net 2.0.  I created some database files on my local pc then copied the whole app to the server.  Not sure what to do.
Any help would be greatly appreciated or direction to info.
Thanks Matt

View 13 Replies View Related

ConnectionString

Mar 18, 2008



hey all,

Im a bit lost as what i should have in my connectionString to a sql server


string connectionString = "server=localhost;database=databasename; uid=sa;pw=sa";



The server is on the localhost, the database name is ok, but what do I put in for the username and password?, At the moment because it is hosted locally I am not using any logins.


Thanks

idgeit

View 6 Replies View Related

SELECT A Single Row With One SqlDataSource, Then INSERT One Of The Fields Into Another SqlDataSource

Jul 23, 2007

What is the C# code I use to do this?
I'm guessing it should be fairly simple, as there is only one row selected. I just need to pull out a specific field from that row and then insert that value into a different SqlDataSource.

View 7 Replies View Related

ConnectionString Property

Jun 28, 2006

I am having trouble initializing my connection. This is the code:


Dim
DBConnPhone As New
SqlConnection(ConfigurationManager.AppSettings("DBConnPhone"))




        Dim DBConnClient As New
SqlConnection(ConfigurationManager.AppSettings("DBConnClient"))       


        Dim Sqlcomm1 As New SqlCommand


        Dim Sqlcomm2 As New SqlCommand


        DBConnPhone.Open()


       
DBConnClient.Open()

Once I start debugging, it stops and give me the error "The ConnectionString Property was not initialized" Any suggestions?

View 4 Replies View Related

ConnectionString Without Password

Nov 23, 2006

Hello! I am working at a ASP.NET Project with has a sign-in area. All users (the aspnet_Membership and so on) are on an external SQL Server stored.The ConnectionString in the web.config looks like this:<add name="hspWerbung" connectionString="Persist Security Info=False;User ID=XXXXX;Password=XXXXX;Initial Catalog=HSPWERBUNG01;Data Source=SERVER_SQL_02STOCKHOLM"   providerName="System.Data.SqlClient" />Is there any way to create a ConnectionString without the User ID and without the password?When i want to reach my site on the web (not with http://localhost/...) , i can't do it with "Integrated Security=True", because there will be no user, or? 

View 1 Replies View Related

Connectionstring Problem

Dec 9, 2006

Hay, I have a problem with this connectionstring.Dim myConnection As New Data.OleDb.OleDbConnection("Provider=SQLNCLI;Data Source=whatever-ja4lbqsqlexpress;Initial Catalog=Account;Integrated Security=SSPI;")I use this code to receive a value on a specific query Public Sub readdata(ByVal myconnectionstring As String)
Dim mySelectQuery As String = "SELECT UserName, Password FROM TAccount WHERE UseName = '" & TextBox1.Text & "'; and Password = '" & TextBox2.Text & "';"

Dim mycommand As New Data.OleDb.OleDbCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myreader As Data.OleDb.OleDbDataReader
myreader = mycommand.ExecuteReader
While myreader.Read
Label1.Text = myreader.GetString(1)

End While
myreader.Close()
myConnection.Close()

End Sub  But when it execute i receive this exeption Login timeout expiredAn error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Is this mean that i can not make a connection to my sql server 2005.
 
My sql server 2005 runs on my developer computer 

View 2 Replies View Related

ConnectionString Property Not Set

Feb 14, 2007

 
Hi, After many nights without sleep I'm not seeing this? Can anyone help why I'm getting a ConnectionString Property not set error? thanks!
Dim Sconn As StringDim DBCon As New Data.SqlClient.SqlConnectionSconn = ConfigurationManager.AppSettings("LocalSqlServer")DBCon = New SqlClient.SqlConnection(Sconn)Dim cmdCommand As New Data.SqlClient.SqlCommand
'Dont forget to instantiate a connection object
cmdCommand.Connection = DBConDBCon.Open()

View 18 Replies View Related

ConnectionString Using SQL Server

Feb 15, 2007

Hello all,

View 5 Replies View Related

Stuck With ConnectionString Please ---&>H.E.L.P.&<---

Jun 25, 2007

Hello, Well actually I am beginner to ASP.Net, I am working on Microsoft Virtual PC with VS 2005 and SQL Server 2005 installed. Now when Create web application in Studio  all works fine with databases but when i try to write some code for accessing SQL Databases I keep getting this error PLZ heLP.Following is my code<% @ Import Namespace="System.Data" %><% @ Import Namespace="System.Data.SqlClient" %><html><script language="C#" runat="server" Debug="false" >SqlConnection sqlcon;protected void Page_Load(Object Src, EventArgs e){    sqlcon=new SqlConnection("Data Source=VS02005;Initial Catalog=Gaurav;Integrated Security=True");        SqlDataAdapter sqlcom = new SqlDataAdapter("select * from Employee", sqlcon);     DataSet ds = new DataSet();    sqlcom.Fill(ds,"Employee");    DataGrid1.DataSource = ds.Tables["Employee"].DefaultView;    DataGrid1.DataBind();}</script><form runtat="server">    <asp:datagrid id="DataGrid1" runat="server" /></form></html>This is the error i am gettingServer Error in '/' Application.--------------------------------------------------------------------------------SELECT permission denied on object 'Employee', database 'Gaurav', schema 'dbo'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SELECT permission denied on object 'Employee', database 'Gaurav', schema 'dbo'. I am stuck dont know what to do, I hve checked all permissions for user gaurav, I also gave administrator rights to gaurav but nothing is working PLEASE help me. 

View 4 Replies View Related

SqlDataSource1.ConnectionString

Jul 4, 2007

This works:
SqlDataSource1.ConnectionString = "Data Source=mydb.myserver.com;Initial Catalog=mydbname;User ID=mydblogin; pwd=mydbpassword";
 This doesn't:
SqlDataSource1.ConnectionString = "<%$ ConnectionStrings:myConnectionString_from_WebConfig %>"
Ok, how do I tell it to use my connection string from my web.config? 

View 5 Replies View Related

How To Get DB UserID From ConnectionString

Mar 5, 2008

HiI've my ConnectionString in web.config... I want to display the DB UserID on my webPage and  UserID is specified in ConnectionString... Can any one help me in this caseThanksNasir Ibrahim 

View 2 Replies View Related

Problem In ConnectionString

Oct 26, 2004

hi,
i have problem in connectionstring in sql server.
my connection string is,
------
conn.ConnectionString = "workstation id=BARODA;packet size=4096;integrated security=SSPI;data source=BARODAMYINSTANCE;user id=sa;password=;persist security info=True;initial catalog=SMS"
it will give error like.....
login fail for user "MERIDIANIUSER_GROUP"

-------
conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODAMYINSTANCE;user id=sa;password=;persist security info=True;initial catalog=SMS"
it will give error like.....
login fail for user "sa"

-------
conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODAMYINSTANCE;user id=;password=;persist security info=True;initial catalog=SMS"
it will give error like.....
login fail for user "(null)"

i can do everything, but error occur everytimes.

when i use this, without instance
conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODA;user id=;password=;persist security info=True;initial catalog=SMS"
it will run successfully,

but i have instance,
and i want to run with it.

plz give any idea.
it's urgent.

thanks in advance.

View 3 Replies View Related

Problem In Connectionstring

Mar 11, 2006

when I write this code in web.config :
  <configuration>
<appsettings>

<addkey="constring" VALUE="WORKSTATION id=I-85096B7FC8F64;packet catalog='test"/' info="True;initial" security="SSPI;data" source="I-85096B7FC8F64;persist" size="4096;integrated">


<system.web>
and write this statements in the code of program :

string Constring = ConfigurationSettings.AppSettings("constring"); SqlConnection conn = new SqlConnection(constring);

this error is displyed:
The name 'constring' does not exist in the class or namespace 'C_sharp1.WebForm1'

View 2 Replies View Related

Get ConnectionString From Web.config

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

Application Connectionstring

Apr 1, 2008

hi

I have completed a windows db app.
I have saved the db files in the application/bin/ folder.
The connectionstring that i am using is

Code:

sql
Server =(local);Data Source=.SQLEXPRESS;DataBase=;Integrated Security=SSPI



say i wanted to install this app on my home computer, does not have sql express or anything installed.
Now i want to use the application and it must read/write data from the sql db that was saved in the application/bin/ folder.
what is the connectionstring then ?

can anyone please help ?
what im trying to say is that the application must work independent from any SQL manager/express etc.

is that possible ?

View 3 Replies View Related

Persist ConnectionString

Apr 3, 2007

Hello All,



I have changed connection string property of connectionmanger at runtime and saved package.But my new connectionstring is not persisting, i am getting my old connection string after reload package .



ConnectionManager cm = package.Connections[test.ConnectionManagerID];



cm.ConnectionString = @"C:Test.csv";



app.SaveToDtsServer(package, null,

@"File SystemDupaco Load Next Best.dtsx", "CIRCLE");



How can I save new connection string?.



Please help me.





Thanks



Subin

View 1 Replies View Related

SQL Connectionstring Parameters

Nov 22, 2006

Hi, does anyone knows where can i find all the values that support the connectionstring??? since the connectionstring uses the "server=local;database=nortwind;UID=me...."

etc. are there more parameteres to specify ?? which one of them is not REALLY important?, where can i find a list or something about it??

Thank you, i hope i made my point clear

View 10 Replies View Related

SQL Everywhere ConnectionString Problems

Jul 26, 2006

<VS2005, SQL Everywhere CTP>

When I create typed datasets (for SQL Everywhere db) using the VS designer, I get a connectionString like Data Source =".App_DataDb1.sdf" added to the settings file by the designer. This works fine in the designer but not at runtime. If I replace the settings value to Data Source ="|DataDirectory|App_DataDb1.sdf" then it works fine at runtime but breaks the designer. I looked at the typed dataset designer generated code & it creates a SqlCeConnection object which supports |DataDirectory| macro. So, how can I get the designer & runtime to agree on a connectionString. I guess I can create a partial class for the table adapters & force a connectionString at runtime via a constructor overload, but, is that my only option?

Btw, the error I get at runtime when using the designer generated connectionString is:
"The path is not valid. Check the directory for the database."

View 3 Replies View Related

Change Connectionstring For Dataset

Jul 25, 2006

hi,
I'm having this application using the express way to create the dategridview by having the query string builder. However, my computer recently crashed and I have no idea to change the connection string. so when I load the whole windows application, I am unable to view the information that are supposed to be in the datagridview. however, it returned an exception.
after finding out the main culprit, I realised that the database is using the old sql server's login. since it is using the old database's login, therefore it is unable to log the information into the datagrid view.
Please help! Thanks.

View 2 Replies View Related

Why ConnectionString Varies On Different Servers.?

Jan 8, 2007

Hi all,
I want to connect to an SqlServer database and I have given the connectionstring on an WinXP computer as Dim ConnectionString As String = "server='localhost'; trusted_connection=true; Database='domains'"
Now, when I copied the files to another computer which is Win 2003 Server, I had to give the connectionstring as
   Dim ConnectionString As String = "workstation id=INFO0;packet size=4096;integrated security=SSPI;data source=INFO0;persist security info=False;initial catalog=domains"
Now, I want to upload the files to a website called "BrowseNow.com".
What should be the connectionstring when the files are being uploaded to the server.
I want the public to read from and write to this database tables.
Is there anything I should do witht the SQL Server Enterprise Manager?
Thanking you in advance,
Tomy
 

View 2 Replies View Related

The ConnectionString Property Has Not Been Initialized

Jul 30, 2007

In short, I have a couple grid views on a page that are used for editing as well as sorting, etc.  The grids are setup to use the SqlDataSources.  I'm trying to deploy this to a server environment for different instances (test,cert,prod) and am trying to set the ConnectionString for the SqlDataSource in the code behind (Page_Load()).  Everything works well, except, I get an error message that says the "ConnectionString Property Has Not Been Initialized."  Its a javascript alert coming up on top of the grid view.
Here is how I'm trying to set the ConnString in the Page_Load():this.EmployeeTimeCardDataSource.ConnectionString = ConfigurationManager.ConnectionStrings[connStr].ConnectionString;
Here is an example of the DataSource.<asp:SqlDataSource ID="EmployeeTimeCardDataSource" runat="server"    SelectCommand="sp_Select_Managers_Employees_List"    SelectCommandType="StoredProcedure">  <SelectParameters>     <asp:SessionParameter Name="CurrentUser" SessionField="User" Type="String" />  </SelectParameters></asp:SqlDataSource>
 

View 5 Replies View Related







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