Connection String Questions
Feb 12, 2008
Environment:
Windows Server 2003 Standard Edition Service Pack 1
ASP 3.0
SQL Server 2005 Express
(Was running SQL Server 2000)
I am having problems with the connection string.
After installing SQl Server 2005 Express, the old connection string failed.
Conn="DRIVER={SQL Server};SERVER=servername;UID=userid;PWD=pass;DATABASE=dbname"
I created the following DSN in ODBC...
Conn="DSN=dsnname;UID=userid;PWD=pass;DATABASE=dbname;APP=ASP SCRIPT"
...it works but I am seeing error messages...
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
Question One:
Why is the first connection string failing?
Question Two:
Is the above error message related to using ODBC or is it related to Win Server SP 1?
Thanks in advance.
View 3 Replies
ADVERTISEMENT
Aug 23, 2006
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
Is this an intrinsic issue?
View 2 Replies
View Related
Jan 10, 2001
Hello All,
I have am importing a file that contains an address field where the city and state are in the same field, IE ['Atlanta, GA']. How do I separate the city and state into separate fields. I can get the state by using the RIGHT function. My problem is getting the city information up to the comma.
Any help would be appreciated.
TIA
View 1 Replies
View Related
May 16, 2007
I setup alias both sql server 2005 and 2005 to communication cross wide area networks.
I cannot use ping and telnet command to validate the network layer connection.
The only tool that I can use is netstat -an.
Questions.
When I netstat in sql 200 server. Should I see the ip address of sql server 2005 show up like 55.121.161.32: 1433?
So far I saw different pot show up like 55.121.161.32. 4344.
I am newbee dba and the network guy keeps telling me that I should use telnet.
Please advise. Thank you.
TJ
View 4 Replies
View Related
Dec 15, 2006
Hello All,
I am looking to get some guidance and feed back from the community as to the prevalence and usage of the following technologies:
ODBC Descriptor support
OLE DB support
External Linked Server support
Data Link support for Data Transformation Services
Specifically I am hoping to find out when each technology should be used and the types of applications that use them. Additionally, I am wondering if there are alternatives to these technologies and why they may have been used instead.
Any guidance/feed back is appreciated.
Thanks,
View 4 Replies
View Related
Feb 18, 2008
I'm trying to create a custom connection manager and I have ConnectionType in the DtsConnection attribute set to "MSMDM". When I tried to create one in a package I got:
The connection type "MSMDM" specified for connection manager "{A8543B4B-41D9-4E69-9580-3D1A491AD719}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
(TestHarness1)
So, a few questions:
What are the valid connection manager types?
Why can I not create a new connection manager type of my own?
If I cant create new connection manager types then the purpose of being able to build custom connecton managers is defeated. Hence, what's the point in giving us the ability to create custom connection managers?
-Jamie
View 7 Replies
View Related
Sep 27, 2007
Hi,
I'm having a BIG problem, this is my 3rd day looking for answer !I'm trying to create a custom membership provider with MS SQL database 2005 but not the default ASPNETDB. I've changed the web.config to be as following:<connectionStrings><add name="sqlConn" connectionString="Data Source=.;Integrated Security=True;Initial Catalog=ASPNETDB;"providerName="System.Data.SqlClient" /></connectionStrings> <system.web><trace enabled="true" /><roleManager enabled="true" /><authentication mode="Forms" />
<membership defaultProvider="MySqlProvider"><providers><remove name="AspNetSqlProvider"/><add name="MySqlProvider" connectionStringName="SqlConn" type="System.Web.Security.SqlMembershipProvider" applicationName="/" /></providers></membership>
But when I try to login to the site using the login control the following error occurs:
Server Error in '/etest' 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 149: <roleManager>
Line 150: <providers>
Line 151: <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 152: <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 153: </providers>Source File: C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Configmachine.config Line: 151
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.213
It is clear that this is a prblem with my Machine.Config file - since I've "worked!" on this file for a while. But when I've checked the Machine.config file I've found the LocalSqlServer connection it is talking about! .
I'm lost and I dunno what to do, can anyone help?
Here is the mahine.config in case if you need it:<connectionStrings>
<add name="LocalSqlServer" connectionString="data source=.;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /></connectionStrings>
<system.data><DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /><add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /><add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /></DbProviderFactories>
</system.data><system.web>
<processModel autoConfig="true" /><httpHandlers />
<membership><providers>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" /></providers>
</membership><profile>
<providers><add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers></profile>
<roleManager><providers>
<add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /><add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers></roleManager>
</system.web>
View 8 Replies
View Related
Sep 16, 2015
I am using sqljdbc41.jar to connect with MSSQL database, it is working fine on my local machine.Where as on the remote server, same class giving me error
Login failed for user '<domain><windows loginID>'
My connection string is URL...
I am using sqljdbc41.jar and on 64 bit processor , I am using following command which included path for sqljdbc_auth.dll java -Djava.library.path= C: sqljdbc_4.1enuauthx64 TestDao and error is Login failed for user '<domain><windows loginID>' why it is not picking up username passed in connection string. I have 2 machines, one is local and other is remote. on both machine I login using my domain, it is working absolutely fine on local then why the error is coming on remote machine.Both the machines are identical.
View 4 Replies
View Related
Jan 18, 2008
I have been trying to host my website on Go Daddy for about 3 weeks and I have cleared several problems but this one remains. I can get into the ASPNETDB database for doing logins , etc but I cant access my database called "PINEmgt".
To try to understand where the problem is located,I built a very simple application without login controls and put on it one Detailform accessing a single line table "Signin". I continually get the error message I got with my real app :"The connection name 'PINEMgtConnectionString2' was not found in the applications configuration or the connection string is empty. " There is only one connection string in my app -'PINEMgtConnectionString2'. When I run the app locally on my machine it works. After I move everything to Go Daddy, I get the error message and the following dump"
Line 24: </Fields>
Line 25: </aspetailsView>
Line 26: <aspqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStringsINEMgtConnectionString2 %>"
Line 27: InsertCommand="INSERT INTO Signup(first_name, last_name, email, customer_id) VALUES (,,,)"
Line 28: SelectCommand="SELECT * FROM [Signup]"></aspqlDataSource>
This is indeed the code from my single page app.
The dump is:
[InvalidOperationException: The connection name 'PINEMgtConnectionString2' was not found in the applications configuration or the connection string is empty.]
System.Web.Compilation.ConnectionStringsExpressionBuilder.GetConnectionString(String connectionStringName) +3039085
ASP.default_aspx.__BuildControlSqlDataSource1() in d:hostinguck7scoutDefault.aspx:26
ASP.default_aspx.__BuildControlform1() in d:hostinguck7scoutDefault.aspx:10
ASP.default_aspx.__BuildControlTree(default_aspx __ctrl) in d:hostinguck7scoutDefault.aspx:1
ASP.default_aspx.FrameworkInitialize() in d:hostinguck7scoutDefault.aspx.vb:912306
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +40
System.Web.UI.Page.ProcessRequest() +86
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +18
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.default_aspx.ProcessRequest(HttpContext context) +29
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
After Googleing, asking Go Daddy for info (which they dont give) , etc for three weeks, I need serious mental help
in the form of a solution of this problem. Your help with the problem or the name of a good mental health professional in eastern N.C. (maybe both) would be appreciated.
View 10 Replies
View Related
May 30, 2008
I have seen another thread with this same problem, but the problem seemed to be a typo. I am getting an error when I try to access the web site ..
The connection name 'USASH-AS0013' was not found in the applications configuration or the connection string is empty.
However, in my web.config file I do have a connection named USASH-AS0013. Here is my web.config file (with my user/pwd hidden). Any help would be greatly appreciated.
<?xml version="1.0"?>
<!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
WindowsMicrosoft.NetFrameworkv2.xConfig
-->
<configuration>
<appSettings/>
<connectionStrings>
<add name="USASH-AS0013" connectionString="Provider=SQLOLEDB;Data Source=USASH-AS0013;User ID=****;Password=*****;Initial Catalog="Smart Factory""
providerName="System.Data.OleDb" />
</connectionStrings>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
Visual Basic options:
Set strict="true" to disallow all data type conversions
where data loss can occur.
Set explicit="true" to force declaration of all variables.
-->
<compilation debug="true" strict="false" explicit="true"/>
<pages theme="MySkin" >
<namespaces>
<clear/>
<add namespace="System"/>
<add namespace="System.Collections"/>
<add namespace="System.Collections.Specialized"/>
<add namespace="System.Configuration"/>
<add namespace="System.Text"/>
<add namespace="System.Text.RegularExpressions"/>
<add namespace="System.Web"/>
<add namespace="System.Web.Caching"/>
<add namespace="System.Web.SessionState"/>
<add namespace="System.Web.Security"/>
<add namespace="System.Web.Profile"/>
<add namespace="System.Web.UI"/>
<add namespace="System.Web.UI.WebControls"/>
<add namespace="System.Web.UI.WebControls.WebParts"/>
<add namespace="System.Web.UI.HtmlControls"/>
</namespaces>
</pages>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
-->
<authentication mode="Windows"/>
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
View 3 Replies
View Related
Jun 5, 2007
All:
I am writing an Internet/Extranet based (ASP.Net 2.0) web application that uses SQL server 2005 as the database. I am using forms authentication on my web application. I am also storing the connection string to SQL server in my web config file. The conn string is encrypted using DPAPI with entropy. I currently have created a SQL login account on my SQL server for use by the web application. This is the user ID I am using in my conn string. The reason for this is because all persons using the application will NOT have a windows login.
Here is my question: The login I created currently has defaulted to the "dbo" role and therefore has "dbo" rights to the database. I want to setup up this login account so that all it can do is execute stored procedures. I dont want this SQL login to be able to do anything else. In my application I am using stored procedures for ALL data access functions, via a data access layer in my application. Can someone guide me step by step as to how to setup this type of access for this SQL login.
Thanks,
Blue.
View 4 Replies
View Related
Jul 15, 2007
Hi all, i have standard edition of sql server, on a server hat doesnt have sql server standard would i be able to connect to it using my connection string. Or does the server has to have standard edition too. Is this same for express edition, and if possible to do this whats the difference between express connection string from standard edition thanks
View 3 Replies
View Related
Feb 19, 2015
I have a child package where the ConnectionString property of a Connection Manager is set by a Parent Package Variable Configuration. I set up a script task that brings up a message box with the value of the ConnectionString property right before the dataflow task.
MessageBox.Show(Dts.Connections["CPU_*"].ConnectionString.ToString());When I run the parent package, the message box shows that the connection string is changing with every iteration, but in the dataflow it always draws the data from the same source.
The connection manager is an ADO.Net type, RetainSameConnection is set to False, and I've been researching this for days.
(Update 2/23/2015): To make this stranger, when I look at the diagnostic logs, they tell me that when the new connections are being opened they are using the new connection strings.
View 2 Replies
View Related
Jan 4, 2006
I came across something strange today. I was wondering I was doing something wrong.
View 7 Replies
View Related
Jul 3, 2007
This is the first time I have used SSIS, so please bear with the ignorance.
I have a super simple package that inserts x000's of rows into a temporary table. The data source is a file that the user will upload. I need to be able to tell the package what file to upload. I'm thinking the simplest thing would be to edit the connectionString property of the SourceConnectionFlatFile at runtime. Is this possible? What form should the file path be in (UNC, other)? And, are there any other considerations I should be aware of?
Thanks!
View 1 Replies
View Related
Nov 23, 2006
I have a SQL Server 2005 database (called BDHSE) in a PC which i call PC1. I have a second PC (PC2) and both are within a network (a WLAN).
What i want is to have access to BDHSE from an application in VB6 (APP1) running in PC2. All the INSERT, DELETE, UPDATE records process is done through APP1.
APP1 ia currently running in PC1 and is to be installed on PC2.
I have these questions:
1. What do i need to install in PC2 since all the INSERT, DELETE, and UPDATE is done using APP1? I guess i only have to install the Microsoft SQL Native Client (with all the prerequisites of course) but i am not sure.
2. In the APP1 made in VB6, do i have to change the connectionstring since i am accesing the database which physically is at PC1 and the APP1 will be used in PC2?
3. Any advice you can give me on doing this will be well received.
Thanks in advance,
BSc Fernando Martinez
View 4 Replies
View Related
May 15, 2007
Good Morning,
I hope that I am just missing a step in the process somewhere. I have established a string variable called DatabaseServer and another called DatabaseName. In the OLE DB connectionstring expression I have the following:
Code Snippet
"Data Source=" + @[User::DatabaseServer] + ";Initial Catalog=" + @[User::DatabaseName] + ";Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;"
My understanding is that changing the variable from SERVERA to SERVERB should repoint the connection. (Test to pre-production to production in my current promotion environment.) This should also take effect in any dataflow task using the database connection above right? When I try to repoint the server variable (and only the server variable) I am either a.)throwing errors saying the original connection cannot be found in the data flow task, or b.)the job appears to be processing fine, but the repoint did not take place and data is still flowing to the original server.
Can anyone offer suggestions as to what I am missing?
The properties values in the DB connection:
ConnectionManagerType is OLEDB
DataSourceID is blank
DelayValidation is False (Setting to true changes nothing in my test)
Expression for ConnectionString is (see above)
RetainSameConnection is False
SupportsDTCTTransactions is True (and appears to be unchangeable.)
View 7 Replies
View Related
Jul 19, 2006
Hi,
I need your help!!!!!!!!!!
Ii'm running the application using the sql SDK version , i'm having trouble openning the connection. my connection string is:
strConnect="data source=DEFAULT_WINXP\VSDOTNET;initial catalog=try1;integrated security=SSPI;persist security info=True;workstation id=DEFAULT_WINXP;packet size=4096";
and i get an exception: Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DEFAULT_WINXPASPNET'.
this is my code:
string strConnect;
SqlConnection objConnect;
SqlCommand objCommand;
SqlDataAdapter objDatatAdapter;
DataSet objDataSet;
strConnect="data source=DEFAULT_WINXP\VSDOTNET;initial catalog=try1;integrated security=SSPI;persist security info=True;workstation id=DEFAULT_WINXP;packet size=4096";
objConnect = new SqlConnection(strConnect);
objCommand=new SqlCommand();
objDatatAdapter = new SqlDataAdapter();
objDataSet=new DataSet();
objConnect.Open();
objCommand.Connection = objConnect;
objCommand.CommandType = CommandType.Text;
objDatatAdapter.SelectCommand = objCommand;
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DEFAULT_WINXPASPNET'.Source Error:
Line 166:objDatatAdapter = new SqlDataAdapter();
Line 167:objDataSet=new DataSet();
Line 168:objConnect.Open();
Line 169:objCommand.Connection = objConnect;
Line 170:objCommand
View 5 Replies
View Related
Jul 21, 2006
Hi
I'm using VB.NET in ASP.NET .
Windows 2000
Visual Studio 2005
and SQLServer 2005.
I'm new to VS 2005
I'm using the following code for connection
<add key="dsnstring" value="persist Security info=False; User ID=; password=;Initial Catalog=TransMate1; Data Source=Localhost trusted_connection=yes" />
it is giving the error as 'Cann't do the connection since user id cann't be null
It is not exact words of the error message.
following code is working fine with the SQL Server 2003 but not with SQL Server 2005.
<add key="dsnstring" value="persist Security info=False; User ID=sa; password=dreams;Initial Catalog=TransMate; Data Source=Localhost" />
Kindly help me
Thanks in advance
Regards.
View 1 Replies
View Related
Aug 8, 2006
I have made an app (the first one) and im trying to find the right connection string to the database. Im using sqlexpress on my local computer, and my host uses MSSQL, can anyone tell me what the connection string could
View 1 Replies
View Related
Sep 28, 2006
any1 know how to find/create a connection string to an SQL database ????
View 3 Replies
View Related
Feb 8, 2007
I want's to use following connection string
"dsn=MyDsn;uid=MyUser;pwd=MyPassword"
Can some how I use it with sqlconnection
I want's to get rid of odbconnection e.t.c
What will be the connection string for sql provider for above dsn information.
If anybody can explain the please help me ?
View 4 Replies
View Related
Apr 13, 2007
my web site is in a host. my mssql db is in other host. how I write the connection string. Please help.
View 6 Replies
View Related
Apr 27, 2007
An 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
ive got this error and i think its about connection string, help please, can somebody show me how to fix this, obviously im a newbie and this my first time to use .net. thanks!
View 2 Replies
View Related
Jun 11, 2007
hi, i was just wondering what's wrong with my code. i have class library to handle all the classes of my asp.net project. when im compiling a class, i am getting an error "Error 1 The name 'ConfigurationManager' does not exist in the current context " . i have this code for that error message: string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString; im not sure about this because im new in asp.net. am i missing a reference here?if yes, what namespace should i include? by the way, i tested this directly in my asp.net age and it is working fine. when i use visual c#.net, that's where the error prompts me, and i cant build that class library.
View 2 Replies
View Related
Aug 13, 2007
hi,
ok im not sure if this is in the right forum, so sorry if its not.
basicly,
before i optained a licence for SQL Server 2005 Dev i was using SQL Server 2005 Express.
now in IIS iv found the following entery in Connect Strings
data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
basicly, what i want to know is do i need this entery, and if so, do i need to edit it?
thanks
View 2 Replies
View Related
Oct 26, 2007
I am using Dreamweaver 8 on Windows XP. I am trying to connect to SQL Server 2005. My connection string isn't right. I ran the OBDC test and it works so I know its the connection string. My webpages give me the error that the server does not exist or access denied. When I use anything else like SQLNCLI.1 for the provider it gives me the error that the provider is not found. What should the connection string consist of and what should I use for Provider?
MYCONN_Conn ="Provider= SQLOLEDB;Data Source=sql2005.loc.mss.edu;Integrated Security=SSPI;Initial Catalog=OPENAssessment;"
Thanks in advance.
View 2 Replies
View Related
Nov 11, 2007
Can VWD generate it by itself? I have a MDF file and I need to get the connection string.
View 3 Replies
View Related
Dec 3, 2007
Hi , I've been searching for this answer for a few hours now but unfortunately I still can not sort it.
I'm attempting to make a "Database Driven Hierarchical Menu" from this tutorial http://aspalliance.com/822
It explains in the tutorial that you must change the connection string to point to your database and add user name and password. (i dont have a user name or password for my local server, or atleast I dont think I do!)
Below is my connection string:DataSet ds = new DataSet();
string connStr = "server=localhost;Trusted_Connection=true;database=Product.mdf";using (SqlConnection conn = new SqlConnection(connStr))
{string sql = "Select MenuID, Text, Description, ParentID from Menu";SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(ds);
da.Dispose();
Every time I try to run the page I get this error.
Cannot open database requested in login 'Product.mdf'. Login fails.Login failed for user '*****'
Can anyone see where I'm going wrong? I'm quite new to all this so I apologies if this seems a bit stupid.
Many Thanks
View 15 Replies
View Related
Apr 2, 2008
I have the following code:
' Dim connStr As String = System.Configuration.ConfigurationManager.AppSettings("AppDoc")
Rather than use the AppSettings within Configuration Manager, I just want to use the connection string. I've seen examples of this in CS but none in VB. Can someone point me in the right direction?
I thought it would be something like this but it doesn't work:
Dim connStr As SqlDataSource = New SqlDataSource(ConfigurationManager.ConnectionStrings["AppDoc"].ConnectionStrings)
View 2 Replies
View Related
Apr 26, 2008
Hi ,I m using this Connection string Data Source=Dev30/SQLExpress;Server=Dev30;Initial Catalog=Fran;Integrated Security=sspi; i get an error An 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 i set the Surface area connection to TCP/IP browser satred..!! Still get this error !!Regards,Francis P.
View 2 Replies
View Related
Apr 28, 2008
here is sample conenction string i want o use for my web site
<add name="myconstr" connectionString="data source=//SQLEXPRESS; AttachDbFilename="data est.mdf";Trusted_connection=yes; uid="username"; pwd="password"; Integrated security=true;Connect Timeout=30;User Instance=True"
providerName="System.data.sqlclient" />
now i am getting this error
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
please tell is my connection string wrong?
i have sahred hosting they say its coding problem.
and i guess
its may be becasue
datasource as SQLEXPRESS
Please help me where I am wrong?
username and passowrd its the one provided by them
data folder i have created under wwwroot
wwwroot s my websites root folder
please help at your earliest as i am new and have no other source of help.
View 8 Replies
View Related
May 2, 2008
Could someone help me with my connection string and how I should create it?
I have a Windows 2003 server running MS Sql 2005. This is a separate server, meaning I'm developing my ASPX code on my laptop and FTP the code over to the server. I'm not sure how to write my connection string. Should My current connection string point to my locally hosted DB. Now that I have my own server should I replace my current 'localhost' entry with the server's IP address? Do I need to create a DNS on the server? Sorry, I'm very new to all this and I'm lost. Any help would be greatly appricated.
View 4 Replies
View Related
