I have got an XP machine where I have installed a SQL Server for my
testing.
I recently started working on a vb.net project requiring MSDE. After
executing the Setup, made using Install Shield, including the
installation of an instance of MSDE I can't start the Query Analyzer on
my "normal" SQL server or any instance, I am having a message saying
"the specified file can not be found". I have to do a system restore to
recover this functionality.
Here is a pic http://www.corobori.com/sos/picSQLMSDE.jpg
i am new to SSIS. I need to know can i make the excel source connection to redirect to a different excel file if the file i am looking is not available. i am using parameters to identify the excel files with the current date. if the file with that date is not found, i need to take excel file with the previous date to load the data.
lately I had the following message on win2000 sp4 with sqlserver2000 sp3a: "DTS Designer Error - Specified file not found". Then in the DTS editor the Task menu objects are missing and it is not possible to link a source and a target using Transform Data Task.
Before it used to work fine.
I have done the following:
- installing again last sp: same issue again - reinstalling sqserver with a registry deep cleaning: same issue again - started disabled windows services: same issue again
any idea?
Carsten
edit: Could it be possible that a lately installed fix for Win2K interferes with DTS-Designer?
I was requested to build and move and existing SSIS package from the developers local PC to the Dev server. Both are running SQL 2K5, I built the following command file so SQL Agent can run the import job.
REM *** Run for FileImport set FileImportLoadData=C:SSISConfigDEVFileImportLoadData.dtsConfig "C:Program FilesMicrosoft SQL Server90DTSBinndtexec" /f "C:SSISConfigFileImportFileImportLoadData.dtsx"
All files are in the proper place but when the jobs runs the following message shows up in the history;
Message Executed as user: LIGHTHOUSE1SQLEXEC. ...system32>set FileImportLoadData=C:SSISConfigDEVFileImportLoadData.dtsConfig C:WINDOWSsystem32>"C:Program FilesMicrosoft SQL Server90DTSBinndtexec" /f "C:SSISConfigDEVFileImportLoadData.dtsx"Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:54:00 AM Warning: 2008-05-08 08:54:01.77 Code: 0x80012014 Source: FileImportLoadData Description: The configuration file "FileImportLoadData.dtsConfig" cannot be found. Check the directory and file name. End Warning Warning: 2008-05-08 08:54:01.77 Code: 0x80012059 Source: FileImportLoadData Description: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed. End Warning Progress: 2008-05-08 08:54:01.82 Source... Process Exit Code 0. The step succeeded.
My questions is how do I fix this and is this really and error?
Hi,I'm developing a desktop C# app that uses SQL Everywhere as an embedded database. I generated strongly typed DataSet and use that to populate a DataGrid on my app.When the app first loads, it populates the DataGrid with a line like this:
however, this time, the following exception was thrown:
The database file cannot be found. Check the path to the database. [ File name = .\Inventories.sdf ]
Does anyone know what may be going on? I saw this article about a bug in VS 2005 when using strongly typed DataSets (http://channel9.msdn.com/wiki/default.aspx/MobileDeveloper.DatabaseCannotBeFoundErrorInTypedDataset) but that doesn't seem to apply here.
The connection string is identical both times that line of code is called so I'm a bit baffled with what's going on.
Hi guys, would appreciate if you can shed some light on this.Sorry to be a pain, can you tell me what is wrong with the following:for /F %%i in ('dir /b /on c:cppc*.txt') do bcp Inventory..pc in%%i -fc:cpcp.fmt -T -S CHICKYywhere CHICKYy is the serverbcp.fmt8.00.19461 SQLCHAR 0 20 ", " 0 filler_1 ""2 SQLCHAR 0 8 " " 1 computer_name ""3 SQLCHAR 0 20 ", " 0 filler_2 ""4 SQLCHAR 0 16 " " 2 ip_address ""5 SQLCHAR 0 20 ", " 0 filler_3 ""6 SQLCHAR 0 60 " " 3 operating_system ""pc1.txt and other *.txt format is:JW_193801,192.168.1.1,Windows XP,when I run it I get:C:cp>for /F %i in ('dir /b /on c:cppc*.txt') do bcp Inventory..pc in%i -fc:cpcp.fmt -T -S CHICKYyC:cp>bcp Inventory..pc in pc1.txt -fc:cpcp.fmt -T -S CHICKYySQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column numberfound in BCP format-fileC:cp>bcp Inventory..pc in pc2.txt -fc:cpcp.fmt -T -S CHICKYySQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column numberfound in BCP format-fileC:cp>bcp Inventory..pc in pc3.txt -fc:cpcp.fmt -T -S CHICKYySQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column numberfound in BCP format-fileC:cp>bcp Inventory..pc in pc4.txt -fc:cpcp.fmt -T -S CHICKYySQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column numberfound in BCP format-fileC:cp>bcp Inventory..pc in pc5.txt -fc:cpcp.fmt -T -S CHICKYySQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Incorrect host-column numberfound in BCP format-fileThe sql table has 3 columns:Sorry to be a pain.-----------------------------------------------------------------------"Are you still wasting your time with spam?...There is a solution!"Protected by GIANT Company's Spam InspectorThe most powerful anti-spam software available.http://mail.spaminspector.com
I've got a package which reads a text file into a table and updates another. I set up configurations so that I could import it into the SSIS store on both my dev and live servers. Now, I'm getting this error. I tried removing the configs and am still getting it.
I've been through each step and everything looks okay. Does anyone have any idea (a) what's wrong, (b) how to localise the error or (c) get any additional information? Or do I just have to recreate the package from scratch?
Error at PartnerLinkFlatFileImporter: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error at PartnerLinkFlatFileImporter [Log provider "SSIS log provider for SQL Server"]: The connection manager "" is not found. A component failed to find the connection manager in the Connections collection.
We have a brand new sql 2k server. Its all up to date on service packs(both win2k and SQL).I went in to enterprise manager and added a new db. I can run sprocsand raw sql against the new db just fine from Query Analyzer.When I try to make a dts package that refers to my new db I get thefollowing error:Error desription: deferred prepare could not be completed.Could not locate entry in sysdatabases for database 'mydbname'. Noentry found with that name. Make sure that the name is enteredcorrectly.OK, so I look in sysdatabases and see 'mydbname'. Just in case im anidiot... I actually copied the db name from that table and paste it inmy dts window.My dts package is using an "execute SQL task" to call a stored proc.To be ecxact:USE mydbnameGOEXEC MyProcWhen I click on the parse button, is when I get that error message.I have deleted the db, restarted the server, and recreated the db witha slightly different name. I can replace mydbname with pubs ornorthwind and all is ok. It just doesnt like new db's.Any help would be greatly appreciated.Thanks,Dave
I've found a bug in SQL CE 3.0/3.1. This has been confirmed to be present by other users of this and the microsoft.public newsgroups, both in the Windows CE versions and the desktop x86 versions. I got this response:
Laxmi Narsimha Rao ORUGANTI MSFT wrote:
Can you please provide the simplified repro with full VS Solution you have thru our blog: http://blogs.msdn.com/sqlservercompact/contact.aspx. First contact us and then we will exchange directly thru mail.
And that's where it has ended (after I contacted the team via the blog - no response). Other forum users have suggested that I post here repeatedly until I get a response, so that's what I'm doing. Apologies.
Been trying to get this one but need a little input. SELECT a.Id,g.LabName...... FROM someTbl a,table g WHERE a.id = @idAND (b.calLab = g.ID OR g.LabName = ???) With the above, if b.calLab = 0 then there is no entry in table g.(I didn't develop the table or would have included NONE) So, how to tell g.LabName to come back as 'None' if b.calLab = 0? Thanks, Zath
Hello, I'm working on a function that will return the results in a SELECT statement. But it's not being called properly, and I can't understand why it isn't working. If anyone can help me out I'd greatly appreciate it. Here's the function code:1 FUNCTION [dbo].[UDFproduct_Search]2 ( 3 @search_string varchar(255)4 )5 RETURNS TABLE 6 AS7 RETURN 8 (9 SELECT product_id10 FROM product11 WHERE product_item_number LIKE '%' + @search_string + '%' OR12 product_part_number LIKE '%' + @search_string + '%' OR13 product_name LIKE '%' + @search_string + '%' OR14 product_commodity LIKE '%' + @search_string + '%'15 ) This SELECT statement returns the expected value:SELECT * FROM UDFproduct_Search('CABINET') This SELECT statement returns the expected value:1 SELECT * FROM where_used WHERE product_id 2 IN(SELECT product_id FROM product3 WHERE product_item_number LIKE '%' + 'CABINET' + '%' OR4 product_part_number LIKE '%' + 'CABINET' + '%' OR5 product_name LIKE '%' + 'CABINET' + '%' OR6 product_commodity LIKE '%' + 'CABINET' + '%') This SELECT statement returns errors:SELECT * FROM where_used WHERE product_id IN(UDFproduct_Search('CABINET') Error:'UDFproduct_Search' is not a recognized built-in function name. I've tried adding dbo to the function call, and in various locations, but I still get the error. Hope someone can point something out I missed. Thanks.
hi... i am very new to SQL server.. previously was using MySQL... now i am trying to connect my project to SQL Server.. but i wasnt able to... i keep getting errors
System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.Open() at icms.DB.q(String mySTR) in C:icmsDB.vb:line 30
below is my webconfig i am not very sure about the value for the user.. because if it is MySQL i can get it from my control centre.. but what about SQL server ? where should i get my value ?
Dim myCMD As New SqlCommand Public Sub New() Dim db_server = AppSettings("db_server") Dim db = AppSettings("db") Dim db_user = AppSettings("db_user") Dim db_pwd = AppSettings("db_pwd") Dim DBConnection As String = "DRIVER={SQL Server};" & _ '<==== is my driver correct? "SERVER=" & db_server & ";" & _ "DATABASE=" & db & ";" & _ "UID=" & db_user & ";" & _ "PASSWORD=" & db_pwd & ";" & _ "OPTION=3;" myDB.ConnectionString = DBConnection myCMD.Connection = myDB End Sub 'Public Function q(ByVal mySTR As String) As OdbcDataReader 'SQL Query Public Function q(ByVal myStr As String) As SqlDataReader myCMD.CommandText = myStr Try myDB.Open() q = myCMD.ExecuteReader(Data.CommandBehavior.CloseConnection) Catch ex As Exception Err(ex.ToString) End Try
End Function Public Sub c(ByVal mySTR As String) ' COMMAND ONLY Try myCMD.Connection.Open() myCMD.CommandText = mySTR myCMD.ExecuteNonQuery() myCMD.Connection.Close() Catch ex As Exception Err(ex.ToString) End Try End Sub
I have inhereted this application and I am a newbee at asp.net. Fisrt my apologies for posting such a large amount, I just wanted to give you all the information that I possibly can.
I have the follwoing error "Specified SQL server not found".
Server Error in '/ppasa' Application. --------------------------------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found. 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.Runtime.InteropServices.COMException: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x80004005): [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.] ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) +0 PPASA.PPASA.OpenCloseDB(Boolean Connect) in c:inetpubwwwrootPPASAPPASA.vb:9 PPASA.Login.btnSubmit_Click(Object sender, EventArgs e) in c:inetpubwwwrootPPASALogin.aspx.vb:38 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
The process of my application works as follows. 1)Login.aspx submits the username and password. It is linked to Login.aspx.vb with the following statement <%@ Page Language="vb" AutoEventWireup="false" Codebehind="Login.aspx.vb" Inherits="PPASA.Login"%> 2)In Login.aspx.vb (below) has a call to PPASA.vb with the following statement Call OpenCloseDB(True).
Public Class Login Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub Protected WithEvents Label1 As System.Web.UI.WebControls.Label Protected WithEvents Image1 As System.Web.UI.WebControls.Image Protected WithEvents Label2 As System.Web.UI.WebControls.Label Protected WithEvents txtUsername As System.Web.UI.WebControls.TextBox Protected WithEvents Label3 As System.Web.UI.WebControls.Label Protected WithEvents txtPassword As System.Web.UI.WebControls.TextBox Protected WithEvents btnSubmit As System.Web.UI.WebControls.Button Protected WithEvents btnClear As System.Web.UI.WebControls.Button
'NOTE: The following placeholder declaration is required by the Web Form Designer. 'Do not delete or move it. Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here End Sub
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim rs As ADODB.Recordset
Call OpenCloseDB(True) rs = cnn.Execute("SELECT ID FROM PPASA_User WHERE Name='" & UCase(txtUsername.Text) & "' AND Password='" & txtPassword.Text & "'") If Not rs.BOF And Not rs.EOF Then Call PopulateUserInfo(rs.Fields(0).Value) Server.Transfer("PPASAMain.aspx") Else Call ClearLoginBoxes() End If Call OpenCloseDB(False)
End Sub
Public Sub PopulateUserInfo(ByVal MyID As Integer)
Dim rs As ADODB.Recordset
Call OpenCloseDB(True) rs = cnn.Execute("SELECT ID,Name,Security FROM PPASA_User WHERE ID=" & MyID) If Not rs.BOF And Not rs.EOF Then rs.MoveFirst() 'CurrentUser.ID = rs.Fields(0).Value 'CurrentUser.Name = rs.Fields(1).Value 'CurrentUser.Security = rs.Fields(2).Value Session.Add("ID", rs.Fields(0).Value) Session.Add("Name", rs.Fields(1).Value) Session.Add("Security", rs.Fields(2).Value) Session.Add("DonorID", 0) End If Call OpenCloseDB(False) End Sub
Private Sub ClearLoginBoxes() txtUsername.Text = "" txtPassword.Text = "" End Sub
Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click Call ClearLoginBoxes() End Sub End Class
3)PPASA.vb then creates the connection to the Database. PPASA.vb looks like this.
Module PPASA
Public cnn As New ADODB.Connection
Public Sub OpenCloseDB(ByVal Connect As Boolean)
If Connect = True Then If cnn.State = 0 Then cnn.Open("Description=PPASA;DRIVER=SQL Server;SERVER=THE-ONESERVERA;UID=sa;PWD=123;APP=Microsoft Data Access Components;DATABASE=PPASA") End If Else If Connect = False Then If cnn.State = 1 Then cnn.Close() End If End If End Sub
Public Function CheckSecurity(ByVal Actual As Integer, ByVal Required As Integer) As Boolean If Actual >= Required Then CheckSecurity = True Else CheckSecurity = False End If End Function End Module
4)After I submit Login.aspx the application boms and gives me the "Specified SQL server not found".
Extra Info:
The Sql server is up and running. I have tested it by connecting with 2 test connection files index.asp and index2 .aspx. Here are the files. The files also return results from the pubs db.
index.asp
<% Set conn = Server.CreateObject("ADODB.Connection") strConn="DRIVER={SQL Server};SERVER=THE-ONESERVERA;UID=sa;PWD=123;DATABASE=pubs"
conn.open strConn
sql = "SELECT * from authors" set rs = conn.Execute(sql) if not rs.EOF then while not rs.EOF lastname = rs("au_lname") firstname = rs("au_fname") response.write "LASTNAME :: " & lastname & " \// FIRSTNAME :: " & firstname & "<br>" rs.movenext wend end if conn.Close() Set conn = Nothing %>
and index2.aspx
<%@ Page aspcompat=true %> <% Dim objConn Dim strConn Dim objRs Dim objCmd Dim objField
If Not objRs.EOF then Do While Not objRs.EOF response.write ("VALUES :: ") For Each objField In objRs.Fields Response.Write (" " & objField.value & " \// ") Next response.write ("<br>") objRs.movenext Loop End if
objConn.Close() %>
There are also the following files in the bin directory. Interop.ADOR.dll Interop.MSChart20Lib.dll Interop.Scripting.dll PPASA.dll utCharting.dll
So my question is this, why do I get the error "Specified SQL server not found", when I dont get the error with the test connection files.? Do I have to do anything with the .dll file in the bin directory, like register them or something? How does the Login.aspx.vb file call the PPASA.vb file when I see no reference to PPASA.vb in the Login.aspx.vb file? I would appreciate any help or suggestions. Thanks
I have 2 server 2003 boxes one has sql 2000 and the other has IIS. I can pull up my pages on the iis server but as soon as my app tries to access the sql server I get cannot find server. All my settings are correct in the web.config file. I do not have this problem with the same setup on server 2000 boxes. Also active dir is not set up on the 2000 or 2003 boxes. Can someone please help. thanx weisenbr
I am trying to connect to my SQL Server through my ASP.NET webpages. My problem is that, no matter what I do, it always says that the server is not found. I know the IP address of my server, and this IP address works from other computers within my network, just not mine.
I have no idea what it could be. If anyone knows, any help would be greatly appriciated.
Hi, i have just started working with asp.net and purchased a book which has MSDE with it for database access. Ihave followed all the instructions on how to install MSDE, however when i try to set up a database using Miscrosoft ASP.NET Web Matrix, i get the error message:Unable to connect to the database server.SQL server does not exist or access denied.ConnectionOpen(Connect()).This message occurs when i am creating a new database.does anyone have any ideas why this may be happening?I have MySQL installed on my computer, could this be interfering with the MSDE ?Thanks....
Sometimes when I try to connect to an existing server (sql 7.0) , I get the error message "specified sql server not found-check registration properties" and it refuses to connect to it. Has anyone encountered this before? Do help.
and i get "[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found."
From my older host I have no problems connecting to my server... so I assumed it must be something at my new host, but I'm able to connect to other remote sql servers from my new isp (for example I can connect from my new ISP to the old ISP's SQL server w/o a problem), but for some reason I can't from the new host connect to mine.. is there a setting on mine that needs to change?
newhostwebsvr to oldhostsql works... oldhostwebsvr to mylocalsql works.. newhostwebsvr to mylocalsql doesn't work??
Hi there, I access to server SQL by an application on web,I configured the ODBC box for using TCP/IP and the server use also the TCP/IP. I have this message :
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found. /medecin/IdentificationAcces/membre_enregistrer.asp, line 108
Can somebody help me with the following error while deploying my cube:
The attribute key cannot be found : dbo_fact_table, Column: datetime Value 25/10/1901 4:18:00 pm...
The year 1901 is included in the time period of the time dimension. The calendar includes the following dates : 1/1/1753 - 31/12/2007 (Time binding) Why this referential integrity error occurs ??
Please help me because it is urgent and I cannot find a solution..
Can someone please tell me how to fix this following error in SQL 2005 When trying to create a maintenance plan, Method Not Found:'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIYtils..ctro()' (Mircosoft.SqlServer.MaintenancePlanTasksUI)
I issue this command in QA:CREATE FUNCTION encrypt_pair (@data VARCHAR(14) , @key char(30) )RETURNS VARCHAR (60) ASBEGINDECLARE @encryptedvars VARCHAR(60)EXEC master..xp_aes_encrypt @data,@key,@encryptedvars OUTPUTRETURN @encryptedvarsENDIf I run it again, I get an error that it already exists (duh).Next I run:select student_id, student_ssn,encrypt_pair(student_ssn,'000000000000000000000000 00000000') fromstudent_ssnand I get the error:Server: Msg 195, Level 15, State 10, Line 1'encrypt_pair' is not a recognized function name.I don't get whats wrong!ThanksRob
We have just installed SQL 2005 on a brand new server and have installed our software for our business solution. When I attempt to run the program, it says that it cannot find "ntwdblib.dll" Where is this file? Am I missing a file from the install or what?
I know that SQL Server Express has to work in C# Express. I mean, that's one of the huge things they push about it, right? So then why, after installing both C# Express and SQL Server Express, do I get the following message (after a very long, crash-provoking pause) when trying to add a database to my project?
"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. (yadda yadda Error locating Server/Instance specified)"
This comes from trying to use an existing MDF file that I created using the SQL Server Management Studio. Trying to add a new database MDF file to the project yields (immediately):
"Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL..."
I've tried all the things suggested in these error messages, and some others as well, with TCP/IP and named pipes, although those things shouldn't be necessary, since this is all local on the same machine with a default instance.
