Connection To MSDE From WebMatrix
Feb 22, 2005
Hi,
I've just started to learn ASP.net using Scott Mitchell's book:ASP.NET in 24 hours. But i've got a little problem in the database section.
I couldn't connect with a MSDE from webmatrix using sql server authentication even the username and password are correct.
The error message :
"unable to connect to the database server:Login failed for user 'sa'. Reason:not associated with a trusted SQL server connection".
What does it mean? Have any of you ever had this kind of problem?
Thank you for helping me.
Regards,
tom
View 2 Replies
ADVERTISEMENT
Jul 1, 2004
Hi,
I'm still fairly green when it comes to ASP.NET and SQL Server, but I have written my share of cool applications (for personal use), using MS ACCESS. Needless to say, I'm growing beyond the limitations of ACCESS.
Since I don't have the cash to spend on SQL Server, I downloaded WebMatrix and MSDE. I can connect and create databases with no problems.
I just have a basic question:
Is it possible to use SQL Server Authentication with MSDE, or is it limited to Windows Authentication?
If there's a way, how would I go about it?
Thank you :-)
View 1 Replies
View Related
Nov 8, 2003
Hello,
I have downloaded WebMatrix/NET.Framework and it works well.
Unfortunatelly I have problem with connecting to MSDE.
I've installed the new version (sql2ksp3a) like they say:
setup.exe INSTANCENAME=my_inst_name DISABLENETWORKPROTOCOLS=0 SAPWD=my_pass
SECURITYMODE=SQL
The MSDE works ok (I can connect from a commercial programs - for example
'MSDE Manager') and seems to be ok.
But when I try to connect from Web Matrix I get the error:
"Unable to connect to database, Invalid connection connection Open, Invalid
instancename".
I put all the parameters correct:
user: sa, auth.type: SQL, server: my_pc_namemy_instance_name
By the way the instance name and my PC name is the same. Could it be the
reason ?
Please help,
greetings to all
View 1 Replies
View Related
Dec 7, 2004
Hi all,
i'm making a webpage via the walkthrough of webmatrix. I use the tutorial 'Build an End-to-End Application (with C#.NET) '. The problem is that this tutorial works with an access db. I'll try to start the same thing but using an sql server.
Nowhere i can't find (because i don't look at the right place i gess) how i have to make a sqlconnection via webmatrix with c# using a keyfield to filter my data and to fill out a datagrid.
can somebody help me please ?
thnx
View 3 Replies
View Related
Dec 22, 2004
I'm trying to learn a little C#, and SQL using SQL Express, Microsoft SQL Server 2005 - 9.00.951, and Web Matrix v0.6 buld 812 with .Net Framework v2.0.40507.42.
Does Web Matrix and .Net v2 work with SQL Express ?
sqlcmd and xm work allow me to select from my table okay, but cannot
do so using my aspx SQL code. It appears the SQLConnection is the
culprit:
SqlConnection c = new SqlConnection("server=localhost;Trusted_Connection=Yes;database=test");
(I have tried adding uid=;pwd=; and still get same error.)
Next line of code after connection is:
SqlDataAdapter co = new SqlDataAdapter("select field1 from testtable", c);
Note that error message below refers to line 18, co.Fill..., but I believe its
theSQLConnection code that is failing.
Always get error: Server Error in '/' Application.
Named Pipes Provider: The system cannot find the file specified.
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: Named Pipes Provider: The system cannot find the file specified.
Source Error:
Line 16: DataSet d = new DataSet();
Line 17: //
Line 18: int i = co.Fill(d, "x");
Line 19: Response.Write(i.ToString());
Line 20: l.DataSource = d; // d.Tables["x"].DefaultView;
Source File: c:My Work FilesMicrosoft RelatedSQLexpressa.aspx Line: 18
Stack Trace:
[SqlException (0x80131904): Named Pipes Provider: The system cannot find the file specified.
]
System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnectionBase owningConnection) +90
System.Data.ProviderBase.DbConnectionClosed.Open(DbConnectionBase outerConnection) +189
System.Data.ProviderBase.DbConnectionBase.Open() +62
System.Data.SqlClient.SqlConnection.Open() +168
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +144
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +86
ASP.a_aspx.abc(Object s, EventArgs e) in c:My Work FilesMicrosoft RelatedSQLexpressa.aspx:18
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +81
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +219
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +12
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +38
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4429
Thanks to anyone who replies.
View 1 Replies
View Related
Jan 16, 2004
get a prompt up (in a program like telnet / msdos window) so that I can run sql commands on my webmatrix accounts sql server. I've been trying to connect using telnet but i think maybe I've got the wrong end of the stick or I'm doing something wrong.
here's a link where you click through "how to connect" on the "myserver page" I searched the page for "connect" and found 0 occurances.
http://europe.webmatrixhosting.net/text.aspx?tmpl=qa#3.7
View 5 Replies
View Related
Oct 6, 2005
I just recently DL'd sql server 2005 Express and set up it on a server and it works. However, I do my development on my desktop with Webmatrix and can't seem to connect to it. Webmatrix tells me I must use SQL server management studio or SQL server management objects (SMO). Am I barking up the wrong tree?
View 1 Replies
View Related
Feb 24, 2004
what i'm trying to do is simply display the contents of the sqldata to verify that it works. and it doesn't. i have created a simple database named 'test' and table 'list' with fields: 'name' and 'id'. i have made 3 records as follows:
NAME ID
name1 1
name2 2
name3 3
what i did is connect to the database, click and drag it over to the canvas and codes were generated. if i run it, by default it should show all the contents of the table, correct? well, it isn't. i've tried it using a datagrid and it still doesn't work.
is there an access problem with the database? or, what settings to have to make/change in my sql server? by the way, i have MSDE.
<%@ Page Language="VB" %>
<%@ Register TagPrefix="wmx" Namespace="Microsoft.Matrix.Framework.Web.UI" Assembly="Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626" %>
<script runat="server">
' Insert page code here
'
Function test() As System.Data.IDataReader
Dim connectionString As String = "server='(local)'; trusted_connection=true; database='test'"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT [list].* FROM [list]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
dbConnection.Open
Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Return dataReader
End Function
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<wmx:SqlDataSourceControl id="SqlDataSourceControl1" runat="server" DeleteCommand="" ConnectionString="server='(local)'; trusted_connection=true; database='Northwind'" SelectCommand="SELECT * FROM [Employees]" UpdateCommand=""></wmx:SqlDataSourceControl>
<wmx:MxDataGrid id="MxDataGrid1" runat="server" OnLoad="MxDataGrid1_Load" DataSource="<%# SqlDataSourceControl1 %>" BorderStyle="None" BorderWidth="1px" DataKeyField="EmployeeID" CellPadding="3" BackColor="White" AllowPaging="True" DataMember="Employees" AllowSorting="True" BorderColor="#CCCCCC" DataSourceControlID="SqlDataSourceControl1">
<PagerStyle horizontalalign="Center" forecolor="#000066" backcolor="White" mode="NumericPages"></PagerStyle>
<FooterStyle forecolor="#000066" backcolor="White"></FooterStyle>
<SelectedItemStyle font-bold="True" forecolor="White" backcolor="#669999"></SelectedItemStyle>
<ItemStyle forecolor="#000066"></ItemStyle>
<HeaderStyle font-bold="True" forecolor="White" backcolor="#006699"></HeaderStyle>
</wmx:MxDataGrid>
<!-- Insert content here -->
</form>
</body>
</html>
View 4 Replies
View Related
Jan 13, 2004
When trying to connect to a local MSDE database using an ASP application I recieve the following error when using integrated security.
con.ConnectionString = "server=HNT1PC0281;database=test;Integrated Security=SSPI"
Login failed for user 'HNT1PC0281ASPNET'.
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: Login failed for user 'HNT1PC0281ASPNET'.
This String work in a C# application, but not ASP using VB.
Source Error:
This occurs on the con.Open() statement
When using a loginname/password I recieve
con = New SqlConnection("Server=HNT1PC0281;uid=sa;pwd=something;database=test")
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
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: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Source Error:
Let me know if you have any ideas...
Thanks,
View 1 Replies
View Related
Jan 14, 2004
setup MSDE command:
setup sapwd=19820822
connection test file:
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server">
Sub Page_Load()
Dim strConnection as String = "user id=sa;password=;"
strConnection += "database=northwind;server=solo822;"
strConnection += "Connect Timeout=30"
data_src.text = strConnection
Dim objConnection as New SqlConnection(strConnection)
'now we attempt to open the connection
try
objConnection.Open()
con_open.text="Connection opened successfully.<br />"
objConnection.Close()
con_close.text="Connection closed.<br />"
catch e as Exception
con_open.text="Connection failed to open.<br />"
con_close.text=e.ToString()
end try
end Sub
</script>
<html>
<body>
<h4>Testing the data connection
<asp:label id="data_src" runat="server"/></h4>
<asp:label id="con_open" runat="server"/><br />
<asp:label id="con_close" runat="server"/><br />
</body>
</html>
the displayed error:
Testing the data connection user id=sa;password=;database=northwind;server=solo822;Connect Timeout=30
Connection failed to open.
System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ASP.sql_connection_aspx.Page_Load()
what's up? plz tell me. 3x!!
View 1 Replies
View Related
Oct 31, 2004
I have instal VS Studio and MSDE. For experimental purposes I have not instal office and SQL. I wanted to see if I could connect to the MSDE. But each time I try to connect I receive the error message Access Denied or SQL Server does not exist.
Any help folks.
View 4 Replies
View Related
Nov 2, 2004
I have installed the MSDE that comes with VS NET 2002. For experimental reason's I have decided not to instal SQL and Office XP.
But the problem I have is that anytime I try to connect I receive an exception. The exception message is "No SQL server or Access Denied". I am not too sure if I am not doing something right or I have to instal office or SQL. I have created my database using the visual tools in the VS NET 2002.
Any help will very much be appreciated.
View 2 Replies
View Related
Mar 10, 2005
Hi,
I installed MSDE and the sample databases with it. They work fine.
Well I am using the server explorer of visaula studio standard 2002. I can see all the sample databases there and connect to them as well.
1.
--------------------------------------------------------------------
Now i created a new database named "testDb" and in a similar fashion i am using windows login thingy.
When i write my connection string in the program now it doesnt work
string connectionStr =@"Server=IMRANNetSDK;" + "Integrated Security=SSPI;" + "Connection Timeout=7;" + "Database=testDB;";
If i replace my Database clause to Northwind it works absolutely fine.
The ERROR it gives is:
Cannot open database requested in login 'testDB'. Login fails. Login failed for user 'IMRANASPNET'.
Why is this happenning? :(.
============================================
2.
-------------------------
How can i configure the MSDE to use the SQL Authentication.
It doesnt allow me to do that?
Thanx Heaps,
Imran
View 2 Replies
View Related
Dec 30, 2004
I am trying to connect to a remote MSDE SQL database. When I set up the odbc connection I get a connection denied error. The SQL server is on a windows 2003 server. Any ideas are greatly appreciated.
Thanks, LinsLo
View 3 Replies
View Related
May 10, 2006
hi friends,
I'll be thankful if anyone solve this problem.
When i developed my application, i used sql 2000 as a server side DB.
Now my client want to install MSDE instead of SQL 2000.
so i uninstall SQL2000 and installed MSDE .
AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP)
(includeing xmlparser,windows installer,.net 2.0).
now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAMEMSDERELA"
I used same kind of connection string for SQL 2000. Worked well.here what happened?
Connection String : "Data Source = CMPNAMEMSDERELA;Database =TEST; User id ="xxx; Password =xxxx;"
OS: Windows server 2003.
i used VB.NET to develop the apps. (VS2003). Connecting from Pocket PC.
kindly help me to solve this problem.
(Already i posted this in SQL tools forum. i hope this is the right place to post this question. so posting again.)
Thank u!
View 4 Replies
View Related
Jun 26, 2004
For a SQL Server 2000 connection string I usualy use the following format:
server=somewhere.com;uid=sa;password=sa;database=myDB
or:
server=66.33.11.123;uid=sa;password=sa;database=myDB
However, now I am dealing with a remote MSDE database. What is the format to connect to a remote MSDE database? Is it:
server=<IPADDRESS><INSTANCENAME>;uid=sa;password=sa;database=myDB
Where <IPADDRESS> is the Ip address of the remote machine and <INSTANCENAME> is the MSDE instance name. Is this correct? If not, what am I doing wrong?
View 4 Replies
View Related
Jan 5, 2005
Hi;
Installed MSDE on computer by running:
c:setup INSTANCENAME="VSdotNET" SAPWD="PASSWORD" SECURITYMODE=SQL
REBOOTED AND sql SERVER iCON APPEARS on the lower desktop Icon bar, open it and it says:
Server: JOHN Servises: SQL Server Running \JOHN - MSSQLServer
opened a command prompt at c: and
entered osql -S JOHN -U sa -P password
and got the 1> reply on the next line
I typed EXIT
I had downloaded two scripts that create Pubs and Northwind SQL databases. I put them in the C: folder
I Typed at c:osql -E -i instpubs.sql
It created the pubs SQL database for me
I Typed at c:osql -E -i instnwinds.sql
It created the nwinds SQL database for me
I closed the command prompt and
went to the Administrator Tools in the Control Panel
I selected Data OLEDB Selected ADD entered Pubs and used default values for Pubs to create a connection Tested it OK
Then went and ran Visual Studio Net 2003
Checked to see if the pubs and northwind SQL databases where present in the Server Explorer drop down window.
I seleced the connect to database Icon and in it's Data Link Properties
I entered JOHN for server name
pubs for selected database on the server
with Provider as MS OLEDB for SQL Service
the Icon changed to connected.
I entered this in the code for page_load
Dim MyDS As New DataSet
Dim ConnStr As String
Dim SQL As String
ConnStr = "server=(local)C:Program FilesMicrosoft SQL ServerMSSQLData;database=pubs;Trusted_Connection=yes"
SQL = "SELECT * FROM Titles " & _
"SELECT * FROM Publishers"
Dim MySqlConn As New SqlConnection(ConnStr)
Dim MySqlAdapter As New SqlDataAdapter(SQL, ConnStr)
'The SqlDataAdapter will automatically open and
'close the SqlConnection
MySqlAdapter.Fill(MyDS)
But I can not get this to work it errors out on line:
MySQLAdapter.Fill(myDS)
with: [SqlException (0x80131904): Unknown ProviderError Locating Server/Instance Specified ]
System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317
I change ConnStr to this:
ConnStr = "server=(local)data;database=pubs; uid=sa; Pwd=password" & _
"Trusted_Connection=true"
and get this error:
[SqlException (0x80131904): Shared Memory Provider: The system cannot find the file specified.
]
System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317
I've tried so many combination with and without user and password, I just don't get it, spent three long days stuck here, can someone help me out.
Note:
C:Program FilesMicrosoft SQL ServerMSSQLData
Is the accual location on my machine that pubs database is located.
I can use the pubs SQL database in Web Matrix OK.
Thanks
pdqjohnny@hotmail.com
View 2 Replies
View Related
Jul 29, 2004
The connection string I'm currently using for SQL Server is Provider=SQLOLEDB;Server=SERVERVSDOTNET;Database= CCDDbase;Integrated Security=SSPI
would this be the same query string for MSDE database? I'm quite new in MSDE but I know that except for the tools that comes with SQL Server and its size, they are practically the same...
View 2 Replies
View Related
May 1, 2007
Hi all,
I installed a MSDE on a Windows XP SP2 and configured it for accepting remote connections. But It shows the "SQL Server doesnot exist or connection denied" message whenever I try to connect to this server. For more information I am adding more facts
* It is an MSDE and not a WMSDE
* Firewall is turned off
* Server process is listening on 0.0.0.0:1433
* TCP/IP and Named Pipes are enabled using server network utility
* LoginMode=2 is set for mixed mode authentication in the registry
* Tried restaring the Process and even windows after the changes.
Please help me !!
Thanks in advance
View 1 Replies
View Related
Sep 22, 2004
i have msde 2000 running on a server i am able to create an odbc connection to my db on that pc. when i try to create anpther odbc connection on another pc on that network i get the following error:
sql state '01000'
server error 2
[microsoft][odbc sql server driver][named pipes] connectionopen (connect()).
connection failed
sql state '08001'
server error 17
[microsoft][odbc sql server driver][named pipes]server does not exist or access denied.
what do i have to do to get this odbc connection on this pc working?
Thank You,
Thomas
View 2 Replies
View Related
Nov 8, 2006
I have just done an in-place upgrade from MSDE to SQL Express with Advance Services for my customer. After upgrading, the program was not enable to connect to SQL Express and threw an error (the program connect to the server through OLEDB provider)
Code -2147217843 (80040e4d) - IDispatch error #3149 - Source : Microsoft OLE DB Provider for SQL Server
It only works if I replace the string "Provider=SQLOLEDB.1" with "Provider=SQLNCLI.1". I wonder why I have to do that because in my working PC and other customers, I don't get this.
The customer's PC use Windows 2003 Server for Small Business Server SP1
Thanks in advance
Huy Le
View 4 Replies
View Related
Dec 1, 2003
I have Installed MSDE SP3a (sql2kdesksp3.exe) on a Windows 2003 Web Edition Server.
The security mode is win/sql. I can log in with both Win NT and SQL security localy, from both EM and MSDE manager.
(in the end of the installation, no dialog show, and the agent does not start automaticly, started on restart)
The MSDE is installed from cmd, with no SAPWD but SecurityMode=SQL.
But from another client on the network (same domain), I can´t connect. I get the "SQL Server Does Not Exist or Access Denied" Error Message
I have check the regestry for the tcpip port settings. And its not 0.
I have read some other MSDE related threads, but no luck.
Any hints what to check new, to try to solve this problem ?
peace.
View 3 Replies
View Related
May 22, 2004
Hi All
I installed the following in order:
1. .NET Framework Version 1.1 Redistributable
2. .NET Framework Version 1.1 Software Development Kit (SDK)
3. MSDE 2000 Rel A
In the command window I changed to the directory where MSDE 2000 Rel A was installed and typed in this:
setup.exe INSTANCENAME=MyDb DISABLENETWORKPROTOCOLS=1 SAPWD=<My SA PASSWORD>
MSDE installed successfully and the little icon appeared in the system tray, next to the clock. However, there was no little green arrow/triangle showing on the icon to show connection status as Connected.
4. ASP.NET Commerce Starter Kit
During the Starter Kit install a Connect to Database window opened - Connect to SQL or MSDE.
In the 'Server' field the following was automatically displayed:
STEVE-HOME/MyDb
Where STEVE-HOME is the name of my computer (changed from 'localhost') and MyDb is the instance name.
Thw 'Windows Authentication' radio button was selected by default. I left this unchanged, then clicked OK.
A window opened asking to test the connection. I clicked OK and the connection was successful.
(I didn't select the SQL Server authentication or enter a username, password or select a Database.)
The Starter Kit installed successfully and works fine. However, the SQL Server Service Manager icon states it is not connected when I mouse over it.
I opened the SQL Server Service Manager window and the Server and Services fields are blank.
Surely the Starter Kit wouldn't work if MSDE wasn't connected.
Can anyone advise on how to get the icon to show it is connected
Your help would be greatly appreciated.
View 1 Replies
View Related
Jun 6, 2005
Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters.
I'm trying to setup a news database for my website, which will populate
the information into a datagrid. To test, I manually added a news
item in the database through the visual studio 2003 gui. I
immediately noticed a problem as the I was getting an error after a
long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column. As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
View 1 Replies
View Related
Dec 11, 2006
Is it possible to make a connection to a hosted SQL Server using the WebMatrix? All attempts have resulted in the following error message.Unable to connect to the databaseSQL Server does not exist or access denied.ConnectionOpen (Connect()).
View 1 Replies
View Related
May 27, 2000
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
View 1 Replies
View Related
Mar 27, 2001
We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??
regards,
Manfred
View 3 Replies
View Related
Mar 9, 2005
I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
View 4 Replies
View Related
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
Feb 6, 2008
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.
Thanks,
John T
View 3 Replies
View Related
Mar 9, 2007
All --
Please help.
I have some questions about connection strings.
BACKGROUND...
Note that I am using the "SQL Native Client OLE DB Provider", SQL Sever 2005 Express, ASP.NET, C#.NET, and VS.NET 2005.
Note that I do not want to use the "Attach a database file" type of connection string.
Note that I am using the site http://www.ConnectionStrings.com as a reference.
Note that this "Standard security" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Uid=MyDatabaseUser;Pwd=MyDatabasePassword;" />...does not work and causes the following run-time error...A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Note that this "Trusted connection" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Trusted_Connection=yes;" />...works but is less-than ideal because it uses a Trusted Connection rather than a Username/Password combination.
QUESTIONS...
(A) What exactly does the error in Item 4 mean?
(B) Do 4 and 5 imply that one must use a Trusted_Connection for all SQL Server 2005 Express connection strings when the database does not reside in the web application's App_Data folder or use a "Attach a database file" type of connection string?
(C) Are there any alternatives?
(D) What do you suggest?
Please advise.
Thank you.
-- Mark Kamoski
View 1 Replies
View Related
Apr 7, 2008
When running the project in debug mode or non-debug mode, I get the following error from MS Visual Studio:
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Package [Connection manager "SYBASE_CONNECTION"]: The connection manager failed to defect from the transaction.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
Any ideas???
View 8 Replies
View Related
Mar 4, 2008
Hi All,
We are using the Windows Task Scheduler as a substitute for the SQL Server Agent, which isn't available in the Express edition. The scheduled task just calls a batch file, which in turn, runs a stored procedure using osql with the -E option for a Trusted Connection.
SQL Server Express has been installed using the defaults, which means the service is running in the "NT AUTHORITYNETWORK SERVICE" account. The scheduled task we create is set to run using the "NT AUTHORITYSYSTEM" account.
Now we find that on Windows Vista (tested using Ultimate Edition) that the scheduled task fails to run the stored procedure until the machine is rebooted the first time after installing SQL Server Express. When I say "fail", I mean that the stored procedure isn't executed. The scheduled task however completes and reports no errors. On Windows XP, we do not run into this problem so I suspect it has something to do with the UAC in Vista?
We further found that after installing SQL Server Express and creating the scheduled task in the "NT AUTHORITYNETWORK SERVICE" account, the scheduled task (and stored procedure) runs fine WITHOUT requiring a reboot.
Can anyone explain why a reboot is needed to get SQL Server Express to run the scheduled task correctly under Windows Vista and the SYSTEM account?
Any help or thoughts greatly appreciated.
View 2 Replies
View Related
