Problem Of MS SQL ----ntwdblib.lib NOT Found
Jul 20, 2005
Dear all,
I want to use C program to connect MS SQL server.
I copied some sample file to install on my computer.
When I run the program, an error occurred, which is about ntwdblib.dll
not find in some paths.
But when I check the paths again, they have ntwdblib.dll.
When I run my C program in another computer, it works...
so , I feel very frustrated.
In my C program, I include the following libraries.
#defineDBNTWIN32
#include "windows.h"
#include <sqlfront.h>
#include <sqldb.h>
#include <stdio.h>
Also, I don't know the meaning of "#defineDBNTWIN32".
I haven't installed SQL Client on my computer. Is it the main
problem??
Pls help!!
Cheers,
Alan
View 1 Replies
ADVERTISEMENT
Feb 6, 2006
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?
View 4 Replies
View Related
Aug 7, 2007
We are in the process of upgrading to sql 2005. For us its a big jump but right now I need to know how to specify the port I want to connect on the server. We use ntwdblib, dblogin, dbopen...where and how do I specify the port, since we now have multiply instances on the single server and the default port is not what I need to connect too.
Thanks
View 3 Replies
View Related
May 1, 2007
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?
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
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.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
View 20 Replies
View Related
Jul 20, 2005
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
View 1 Replies
View Related
Oct 10, 2007
Greetings,
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.
TIA
ID
View 12 Replies
View Related
Mar 13, 2007
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
View 2 Replies
View Related
Apr 14, 2008
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.
View 4 Replies
View Related
Apr 4, 2004
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 ?
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="db" value="icms" />
<add key="db_user" value="sqladmin" />
<add key="db_server" value="server" />
<add key="db_pwd" value="*****" />
<add key="session_timeout" value="600" />
</appSettings>
<system.web>
<compilation defaultLanguage="vb" debug="true" />
<trace enabled="true"/>
<customErrors mode="RemoteOnly" />
</system.web>
</configuration>
======================
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
View 4 Replies
View Related
Aug 2, 2004
Hi
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
strConn="DRIVER={SQL Server};SERVER=THE-ONESERVERA;UID=sa;PWD=123;DATABASE=pubs"
objConn = Server.CreateObject("ADODB.Connection")
objCmd = Server.CreateObject("ADODB.Command")
objRs = Server.CreateObject("ADODB.RecordSet")
objCmd.CommandText = "SELECT * from authors"
objConn.open (strConn)
objCmd.ActiveConnection = objConn
objRs = objCmd.Execute
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
View 1 Replies
View Related
Aug 3, 2004
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
View 3 Replies
View Related
Sep 24, 2004
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.
Jags
View 5 Replies
View Related
Oct 17, 2005
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....
View 2 Replies
View Related
Dec 15, 2001
please help me!!!
I have trouble connecting...
and i get get this error when i try to connect to my server:
Specified SQL Server not found
what to do? what to do??
robert
View 1 Replies
View Related
Dec 21, 1999
Hi,
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.
View 2 Replies
View Related
Dec 21, 2001
I'm attempting a connection to my sql server (running off broadband) from a page I have hosting at my new ISP.. just a standard conn string in .asp..
cn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=24.10.XX.XXX.UID=sa;PWD=mypwd;DATABASE=d_ap p;"
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??
View 1 Replies
View Related
Apr 26, 2002
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
I don't know why there is Named Pipes in message.
Please help me
thanks in advance
Jalal
View 1 Replies
View Related
Jan 18, 2004
hi
How Can I Find VNSAPI32.dll
Please help me
View 2 Replies
View Related
Jun 3, 2007
Hello !
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..
Thanks
View 1 Replies
View Related
Aug 3, 2007
Hi Team
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)
Any assistance would help
Thanks
View 1 Replies
View Related
Sep 10, 2007
Hi Guys i get this error when trying to setup a new maintenance plan
Method not found 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.(Microsoft.SqlServer.MaintenancePlan.TaskUI)
I have look and googled and can't seem to find the solution.
any help would be appreciated.
Running SQL 2005 SP2
View 3 Replies
View Related
Jul 23, 2005
I have got an XP machine where I have installed a SQL Server for mytesting.I recently started working on a vb.net project requiring MSDE. Afterexecuting the Setup, made using Install Shield, including theinstallation of an instance of MSDE I can't start the Query Analyzer onmy "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 torecover this functionality.Here is a pic http://www.corobori.com/sos/picSQLMSDE.jpgJean-Lucwww.corobori.com
View 4 Replies
View Related
Oct 3, 2005
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
View 2 Replies
View Related
Jun 21, 2007
I am running a .Net web application that accesses many SQL reports using the Report Viewer.
If a report takes quite a while to load or if I leave the web application idle for quite some time, I get an error similar to the following:
Execution ' ' cannot be found
It seems like the connection to SQL times out and it tries to execute an empty SQL query. Is there any way to prevent this from happening?
View 5 Replies
View Related
Jul 10, 2007
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.
Any help?
View 10 Replies
View Related
Apr 22, 2008
Hello,
i need help
i tried to connect to the database but when i compile the program,it said database file cannot be found.
my database name is MyDatabase#1.sdf
in what category should i put the database ?
this is my program directory
http://img156.imageshack.us/img156/5900/probjp0.jpg
and this is my coding
http://img156.imageshack.us/img156/2052/prob2pe9.jpg
it seems everything is fine.
i dont have any idea why compiler cannot found the database.
by the way,i use VB.net Smart Device in this program
i spend nearly 3 hours to try find the problem but got no luck.
hope anyone here can help me.
thanks.
View 1 Replies
View Related
Oct 8, 2007
Setup:
I'm using SQLCE on a VB.Net (2005) desktop applicaiton.
I have strongly typed datasets pointing to tables in the SDF.
The path to the sdf is |DataDirectory|DataQQ.sdf
Problem:
When I run my application, I have a list of context sensitive tasks that appear as buttons.
When the user steps into a control, the app retrieves a list of context tasks from the SDF and populates the buttons.
When the user pushes one of the buttons, for example "View File" the appropriate action takes place.
However, when the user enters into the next field, I get a SQLCeException telling me the path could not be found (error 25009). The Path it gives is Path = .DataQQ.sdf
It points to the task of getting data from the Context Tasks table.
The problem is, though, that it just accessed that same path and same table to populate the task list.
I've manually checked the file location in explorer as well as openning up the database in Management Studio. It exists and opens fine. But for some reason, it seems to lose the path or connection in between 2 identical calls.
I don't believe I saw this problem until after I switched TO strongly typed datasets.
Any ideas?
View 1 Replies
View Related
Dec 12, 2007
Hi,
I'm encountering a problem with a variable evaluated as an expression, wherein approx. 1 per 1000 runs the variable does not get (re-)evaluated in time, and thus its design time (evaluated) value gets used. This is happening either because a) I'm not handling the variable and/or the control flow correctly, b) I have no right to assume that SSIS will (re-)evaluate it 'in time', as defined by myself, or c) I've found a Microsoft bug. Answers ('a','b' or 'c') would be greatly appreciated:
I have 2 Execute SQL tasks preceeding a Data Flow Task. Precedence constraints (of Evaluation operation 'constraint') require both Exec SQL Tasks to have completed successfully, before the data flow task can be entered. Each Exec SQL Task sets a user variable (~ 'Result Set'), and a 3rd user variable, which is evaluated as an expression, is a function of the 1st 2. Does the expression get re-evaluated automatically+immediately, every time one or both of its dependent variables' values changes? Thus does SSIS GUARANTEE that the 3rd variable will be re-evaluated BEFORE the data flow is entered into? Is this failing to happen (approx. every 1000 runs) because of 'a', 'b' or 'c'?
(I can guarantee that the evaluated variable is not dependent on anything else, and thus there is no race condition which would influence its value at any point in time).
All insights/answers greatly appreciated,
Tamim.
View 11 Replies
View Related
Mar 2, 2007
Hi. I have a SSIS that is failing and I don't know if it is a logging or dba connection issue. I has this set up:
-A db connection pointing to the data source
-A file connection for the logging
-A package configuration with the db connection and file connection info.
When I run my SSIS in the IDE then I get in the error message this:
Error at packagexxx: The connection "" is not found. This error is thrown by Connections collection when the specified connection element is not found.
Error at packagexxx [Log provider "SSIS log provider for Text files"]: the connection manager "" is not found. A component failed to find the connection manager in the Connections collection.
Do you know how to make it work?
View 3 Replies
View Related
Sep 7, 2007
I have this annoying error and I cannot find a solution yet. Please help!
I'm generating some reports from a SQL Server 2005 database. I know these reports work fine because I've seen them working, but, sometimes, appearently random, it doesn't create the report, instead, it gives me this error:
Execution '' not found
With nothing inside the ''. Another case is when I try to refresh the report: I generate the report, I see it, and I press F5 to refresh, I get the same error again.
Could anybody help me please? I'm desperate.
View 13 Replies
View Related
Jun 30, 2006
Hello,
I have two different instances of sql server 2005 but i get
Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not found. State 89.
This is one of the two instances:
use master
--ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'dsjdkflJ435907NnmM#sX003'
create master key encryption by password = 'hello'
create certificate [Certificato2]
from file = 'c:certsTransportCert2.cer'
with private key (FILE='c:certsTransportCert2.pvk',
decryption by password='simone')
active for begin_dialog = ON
CREATE LOGIN [M02] WITH PASSWORD = 'wrPqYkr%bm3';
ALTER LOGIN [M02] DISABLE;
CREATE USER [M02] FROM LOGIN [M02];
GO
create certificate [Certificato1]
authorization [M02]
from file = 'c:certsTransportCert1.cer'
active for begin_dialog = ON
GO
USE PublisherdDB
--ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'dsjdkflJ435907NnmM#sX003'
create master key encryption by password = 'hello'
create certificate [CertificatoDialogo2]
from file = 'c:certsDialogCert2.cer'
with private key (FILE='c:certsDialogCert2.pvk',
decryption by password='simone')
active for begin_dialog = ON
CREATE USER [Proxy::IsDbLookupRequestServiceM02] WITHOUT LOGIN;
GO
create certificate [CertificatoDialogo1]
authorization [Proxy::IsDbLookupRequestServiceM02]
from file = 'c:certsDialogCert1.cer'
active for begin_dialog = ON
CREATE REMOTE SERVICE BINDING [RSB::IsDbLookupRequestServiceM02]
TO SERVICE 'IsDbLookupRequestServiceM02'
WITH USER = [Proxy::IsDbLookupRequestServiceM02],
ANONYMOUS = OFF;
GO
CREATE ROUTE [Route::IsDbLookupRequestServiceM02,D516E70B-59D6-4BF4-882A-BDA7ACD6EB07] WITH
SERVICE_NAME = 'IsDbLookupRequestServiceM02',
ADDRESS = 'tcp://PORTATILEXP:4022';
GO
GRANT SEND ON SERVICE::[IsDbLookupResponseService] TO [Proxy::IsDbLookupRequestServiceM02]
GO
USE MASTER
CREATE ENDPOINT [BROKER]
AUTHORIZATION [VIDEOSYSTEMSimone_Farinea]
STATE=STARTED
AS TCP (LISTENER_PORT = 4033, LISTENER_IP = ALL)
FOR SERVICE_BROKER (MESSAGE_FORWARDING = DISABLED
, MESSAGE_FORWARD_SIZE = 10
, AUTHENTICATION = CERTIFICATE [Certificato2]
, ENCRYPTION = REQUIRED ALGORITHM RC4)
GRANT CONNECT ON ENDPOINT::[BROKER] TO [M02];
Here is the second one:
use master
--ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'hello'
create master key encryption by password = 'hello'
create certificate [Certificato1]
from file = 'c:certsTransportCert1.cer'
with private key (FILE='c:certsTransportCert1.pvk',
decryption by password='simone')
active for begin_dialog = ON
CREATE LOGIN [SIMONEX] WITH PASSWORD = 'wrPqYkr%bm3';
ALTER LOGIN [SIMONEX] DISABLE;
CREATE USER [SIMONEX] FROM LOGIN [SIMONEX];
GO
create certificate [Certificato2]
authorization [SIMONEX]
from file = 'c:certsTransportCert2.cer'
active for begin_dialog = ON
GO
USE vsi
--ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'hello'
create master key encryption by password = 'hello'
create certificate [CertificatoDialogo1]
from file = 'c:certsDialogCert1.cer'
with private key (FILE='c:certsDialogCert1.pvk',
decryption by password='simone')
active for begin_dialog = ON
CREATE USER [Proxy::IsDbLookupResponseService] WITHOUT LOGIN;
GO
create certificate [CertificatoDialogo2]
authorization [Proxy::IsDbLookupResponseService]
from file = 'c:certsDialogCert2.cer'
active for begin_dialog = ON
GRANT SEND ON SERVICE::[IsDbLookupRequestServiceM02] TO [Proxy::IsDbLookupResponseService]
GO
CREATE ROUTE [Route::IsDbLookupResponseService,88EB00C4-8CA9-4B45-9899-677AA70818B1] WITH
SERVICE_NAME = 'IsDbLookupResponseService',
ADDRESS = 'tcp://SIMONEX:4033';
GO
USE MASTER
CREATE ENDPOINT [BROKER]
AUTHORIZATION [VIDEOSYSTEMSimone_Farinea]
STATE=STARTED
AS TCP (LISTENER_PORT = 4022, LISTENER_IP = ALL)
FOR SERVICE_BROKER (MESSAGE_FORWARDING = DISABLED
, MESSAGE_FORWARD_SIZE = 10
, AUTHENTICATION = CERTIFICATE [Certificato1]
, ENCRYPTION = REQUIRED ALGORITHM RC4)
GRANT CONNECT ON ENDPOINT::[BROKER] TO [SIMONEX];
What's wrong in my code?
Many thanks.
View 1 Replies
View Related
Feb 19, 2007
Hello I haw trouble getting the service broker to work I have 3 instances of SQL servers:
1 €śSender€? SQL 2005 Server
2 €śReceiver 1€? SQLEXPRESS 2005
3 €śRecevier 2€? SQLEXPRESS 2005
What I wont is to be abele to do is to send a message from €śSender€? to €śReceiver 1€? or €śRecevier 2€?.
I am abele to send a message from €śSender€? to €śReceiver 1€? but if I send a message to €śReceiver 2€? I get a dialog security problem I think. If I use profiler I can se in €śReceiver 2€? the events:
Broker:Connection
Audit Broker Login
Broker:Message Classify
Audit Broker Conversation = Certificate not found
Broker:Message Undeliverable
And I cant find what´s wrong, this Is my scripts for etch instance.
€śSender€?
USE master
CREATE CERTIFICATE Cert_ROBOTSRV
WITH SUBJECT = 'Cert_ROBOTSRV_auth',
START_DATE = '02/15/2007',
EXPIRY_DATE = '02/15/2015'
GO
BACKUP CERTIFICATE Cert_ROBOTSRV TO FILE = 'C:Cert_ROBOTSRV'
GO
CREATE ENDPOINT SBEndpointServer STATE = STARTED
AS TCP (LISTENER_PORT = 5723)
FOR SERVICE_BROKER (AUTHENTICATION = CERTIFICATE Cert_ROBOTSRV)
GO
CREATE USER andon
CREATE CERTIFICATE Cert_sevapc311_pub AUTHORIZATION andon
FROM FILE = 'C:Cert_sevapc311'
--DROP CERTIFICATE Cert_Andonpc017_Trans
CREATE CERTIFICATE Cert_Andonpc017_Trans AUTHORIZATION andon
FROM FILE = 'C:Cert_andonpc017_Trans'
--DROP LOGIN sbLogin
CREATE LOGIN sbLogin
FROM CERTIFICATE Cert_Andonpc017_Trans;
GO
GRANT CONNECT ON ENDPOINT::SBEndpointServer TO [public]
GRANT CONNECT ON ENDPOINT::SBEndpointServer TO andon
GO
----------------------------------------------------
USE AndonDB
CREATE ROUTE Grafik_sevapc311
WITH SERVICE_NAME = 'Grafik_Service_Recive_sevapc311',
BROKER_INSTANCE = '7C737F42-2DF6-46E7-A6B6-89D1A9608DE2',
ADDRESS = 'TCP://sevapc311:5723'
GO
--DROP ROUTE Grafik_andonpc017
CREATE ROUTE Grafik_Andonpc017
WITH SERVICE_NAME = 'Grafik_Service_Recive_Andonpc017',
BROKER_INSTANCE = 'AE2B294A-B02E-4709-A51E-CFBFD0E478C1',
ADDRESS = 'TCP://192.168.20.106:5723'
GO
CREATE CERTIFICATE Cert_ROBOTSRV_Dialog
WITH SUBJECT = 'Cert_ROBOTSRV_auth',
START_DATE = '02/15/2007',
EXPIRY_DATE = '02/15/2015'
GO
BACKUP CERTIFICATE Cert_ROBOTSRV_Dialog TO FILE = 'C:Cert_ROBOTSRV_Dialog'
GO
CREATE CERTIFICATE Cert_sevapc311_pub_Dialog AUTHORIZATION andon
FROM FILE = 'C:Cert_sevapc311_Dialog'
--DROP CERTIFICATE Cert_andonpc017_Dialog
CREATE CERTIFICATE Cert_Andonpc017_Dialog AUTHORIZATION andon
FROM FILE = 'C:Cert_andonpc017_Dialog'
GRANT SEND ON SERVICE::[Grafik_Service_Send_ROBOTSRV]
TO andon
CREATE USER sbLogin
GRANT SEND ON SERVICE::[Grafik_Service_Send_ROBOTSRV]
TO sbLogin
GO
--GRANT SEND ON SERVICE::[Grafik_Service_Send_ROBOTSRV]
--TO [VADERSTADvrobot]
--GO
-- Grant RECEIVE permission on the queue.
GRANT RECEIVE ON [Grafik_Queue]
TO andon
GO
GRANT CONTROL ON SERVICE::[Grafik_Service_Send_ROBOTSRV]
TO andon
GO
--DROP REMOTE SERVICE BINDING Grafik_sevap
CREATE REMOTE SERVICE BINDING Grafik_sevap
TO SERVICE 'Grafik_Service_Recive_sevapc311'
WITH USER = andon
GO
--DROP REMOTE SERVICE BINDING Grafik_andonpc017
CREATE REMOTE SERVICE BINDING Grafik_andonpc017
TO SERVICE 'Grafik_Service_Recive_Andonpc017'
WITH USER = andon
€śReceiver 1€?
use master
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'andonANDON'
CREATE CERTIFICATE Cert_sevapc311
WITH SUBJECT = 'Cert_sevapc311_Auth',
START_DATE = '02/15/2007',
EXPIRY_DATE = '02/15/2015'
GO
BACKUP CERTIFICATE Cert_sevapc311 To FILE = 'C:Cert_sevapc311'
CREATE ENDPOINT SBEndpointklient STATE = STARTED
AS TCP (LISTENER_PORT = 5723)
FOR SERVICE_BROKER (AUTHENTICATION = CERTIFICATE Cert_sevapc311)
CREATE CERTIFICATE Cert_ROBOTSRV_pub AUTHORIZATION andon
FROM FILE = 'C:Cert_ROBOTSRV';
GRANT CONNECT ON ENDPOINT::SBEndpointklient to andon
----------------------------------------------------------------------------------
use KlientDB
GRANT SEND ON SERVICE::[Grafik_Service_Recive_sevapc311]
TO andon
GO
GRANT CONTROL ON SERVICE::[Grafik_Service_Recive_sevapc311]
TO andon
GO
GRANT RECEIVE ON [Grafik_Queue]
TO andon
GO
CREATE Route Grafik_ROBOTSRV
WITH
SERVICE_NAME = 'Grafik_Service_Send_ROBOTSRV',
BROKER_INSTANCE = '2BA192F8-0BA3-4237-A156-21AFF7C65481',
ADDRESS = 'TCP://ROBOTSRV:5723'
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'andonANDON'
CREATE CERTIFICATE Cert_sevapc311_Dialog
WITH SUBJECT = 'Cert_sevapc311_Auth',
START_DATE = '02/15/2007',
EXPIRY_DATE = '02/15/2015'
GO
BACKUP CERTIFICATE Cert_sevapc311_Dialog To FILE = 'C:Cert_sevapc311_Dialog'
CREATE CERTIFICATE Cert_ROBOTSRV_pub_Dialog AUTHORIZATION andon
FROM FILE = 'C:Cert_ROBOTSRV_Dialog';
€śReceiver 2€?
use master
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'andonANDON'
--DROP CERTIFICATE Cert_Andonpc017_Trans
CREATE CERTIFICATE Cert_Andonpc017_Trans
WITH SUBJECT = 'Cert_Andonpc017_Auth',
START_DATE = '02/15/2007',
EXPIRY_DATE = '02/15/2015'
GO
BACKUP CERTIFICATE Cert_Andonpc017_Trans To FILE = 'F:Cert_Andonpc017_Trans'
CREATE ENDPOINT SBEndpointklient STATE = STARTED
AS TCP (LISTENER_PORT = 5723)
FOR SERVICE_BROKER (AUTHENTICATION = CERTIFICATE Cert_Andonpc017_Trans)
--DROP USER andon
CREATE USER andon
--DROP CERTIFICATE Cert_ROBOTSRV
CREATE CERTIFICATE Cert_ROBOTSRV AUTHORIZATION andon
FROM FILE = 'C:Cert_ROBOTSRV';
CREATE LOGIN sbLogin
FROM CERTIFICATE Cert_ROBOTSRV;
GO
GRANT CONNECT ON ENDPOINT::SBEndpointklient TO [public]
--Select * from sys.certificates
---------------------------------------------------------------
use KlientDB
create user andon
Grant SEND ON SERVICE::[Grafik_Service_Recive_Andonpc017] to [Public]
GRANT SEND ON SERVICE::[Grafik_Service_Recive_Andonpc017]
TO andon
GO
GRANT CONTROL ON SERVICE::[Grafik_Service_Recive_Andonpc017]
TO andon
GO
GRANT RECEIVE ON [Grafik_Queue]
TO andon
GO
--DROP Route Grafik_ROBOTSRV
CREATE Route Grafik_ROBOTSRV
WITH
SERVICE_NAME = 'Grafik_Service_Send_ROBOTSRV',
BROKER_INSTANCE = '2BA192F8-0BA3-4237-A156-21AFF7C65481',
ADDRESS = 'TCP://ROBOTSRV:5723'
--Dialog Säkerhet
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'andonANDON'
--Drop CERTIFICATE Cert_Andonpc017_Dialog
CREATE CERTIFICATE Cert_Andonpc017_Dialog
WITH SUBJECT = 'Cert_Andonpc017_Auth',
START_DATE = '02/15/2007',
EXPIRY_DATE = '02/15/2015'
GO
BACKUP CERTIFICATE Cert_Andonpc017_Dialog To FILE = 'F:Cert_Andonpc017_Dialog'
--Drop CERTIFICATE Cert_ROBOTSRV_Dialog
CREATE CERTIFICATE Cert_ROBOTSRV_Dialog AUTHORIZATION andon
FROM FILE = 'C:Cert_ROBOTSRV_Dialog';
View 2 Replies
View Related
May 30, 2007
SQL 2005 SP 2
Client running 26 push subscribers, 25 work 1 is failing now after working for several weeks
Error messages:
The subscription to publication [] could not be verified. Ensure that all Merge Agent command line parameters
are specified correctly and that the subscription is correctly configured. If the Publisher no longer has information
about this subscription, drop and recreate the subsciption. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201019)
Get help: http://help/MSSQL_REPL-2147201019
The subscription could not be found. (Source: MSSQLServer, Error number: 20021)
Get help: http://help/20021
subscriber @@servername and serverproperty('servername') both return the same and correct value.
Retention period was changed to 30 days, last time subscriber successfully synchronized was on 5/19/2007 today is 5/30/2007
The only difference between the subscriber that wasn't working and the other subscribers that are working is the subscriber name was lower case on the following tables>>>
distribution.dbo.MSmerge_subscriptions
distribution.dbo.MSmerge_agents
publication.dbo.sysmergesubscriptions
Could this possibly been part of the problem?
Can somebody give me some ideas what I can do to get this subscriber communicating with the publisher again.
THank you,
Pauly C
View 8 Replies
View Related
