Access To Result Set From System Call For Cluster Discrimination

Mar 11, 2008



I'm trying to use the result set from this kind of dmx query running in SQL Management Studio 2005:



CALL System.Microsoft.AnalysisServices.System.DataMining.Clustering.GetClusterDiscrimination('Clustering1','001','',0.0005,true)


However, I can't seem to get access to the data. For example, I get errors if I try something like


select into #ttt

CALL System.Microsoft.AnalysisServices.System.DataMining.Clustering.GetClusterDiscrimination('Clustering1','001','',0.0005,true)

where Attributes = 'Task Dur'


or



DECLARE @myTableVar TABLE (

myAttributes text,

myValues text,

myScore double

)

SET @myTableVar = CALL System.Microsoft.AnalysisServices.System.DataMining.Clustering.GetClusterDiscrimination('Clustering1','001','',0.0005,true)

select * from @myTableVar



Thanks for any pointers!

View 7 Replies


ADVERTISEMENT

Cluster Discrimination

Feb 21, 2008

I have formed clusters on a data set using the default clustering algorithm and parameters with the exception of CLUSTER_COUNT which is set to 0. Eleven clusters formed. When examining the Cluster Discrimination tab to compare clusters with their complements, several of the screens are empty. For example, when comparing cluster 5 with it's complement, there are no variables, no values and no bars respresenting score. This happens for 3 of the 11 clusters formed. Any thoughts?

View 7 Replies View Related

Cluster Discrimination Scores

Aug 4, 2006



Dear all here:

I have a question about the cluster mining result.

In the discrimination tab shows the different between group 1 and group 2.

I just wonder how to calculate the discremination scores.

Do any expertise can answer the question?



Regards!



Jerry

View 1 Replies View Related

Access Denied To Cluster Storage When Restoring 2005 Full Text DB To 2014 Cluster

Jun 10, 2015

I am in the process of moving databases from a SQL 2005 Standard version to a 2-node 2014 cluster.All of my 2005 databases back up successfully.They all restore without issue except for one database that has a full text catalog. I get this message

Msg 7610, Level 16, State 1, Line 2
Access is denied to "fileStoragedataMSSQLSERVERFullTextCatalog", or the path is invalid.
Msg 3156, Level 16, State 50, Line 2
File 'sysft_FTCatalog' cannot be restored to 'fileStoragedataMSSQLSERVERFullTextCatalog'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 2
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

[code]....

I went as far as giving the folder full access to everyone temporarily and received the same error.

View 1 Replies View Related

Call Stored Procedure For Last 4 Months Then Combine Into Final Result Set Row

May 3, 2006

I want to call my stored proc for that last 4 months. Basically all I need to do is pass each month's first date and it will do the rest. Should I shove this into a UDF first? I'm not sure if I can do that. The struction is here behind my stored proc: http://www.webfound.net/storedproc.txt

EXEC IT_Get_Dashboard_Monthly '2006-05-03 12:03:43.910' <-- change to UDF or leave it? Then how can I loop and change each month to cover the last 4 months?

I also need to ensure all 4 values returned in each interation show up in one row in the final result set that is produced

View 1 Replies View Related

FileLoadException On The System.directoryServices When I Call A CLR TVF

Apr 10, 2008

Hello,
I created a CLR - TVF that query Active Directory.

1) because system.directoryServices canot be referenced directly from the CLR Project I manually created the Assembly as UNSAFE from Management Studio by peeking up the DLL stored in Windows/Microsoft .NET/v2.0 50727
2) I referenced the Dll on my CLR project
3) deployed my CLR as Unsafe.

When I try to select my TVF I get this error:
System.IO.FileLoadException: Could not load file or assembly 'System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)



Help!!!
What I have forgot to do?
Thank you
Marina

View 4 Replies View Related

Integration Services :: Call Stored Procedure Result In Message Box In SSIS Script Task

Sep 4, 2015

I had the SP, I want to call in Script Task , had the Result set data value then I need pop up message box. So how can I call stored procedure result in message box in ssis script task using C#.

and I want  to use SSIS -OLEDB connection.
 
ConnectionManager cm;
System.Data.SqlClient.SqlConnection sqlConn;
System.Data.SqlClient.SqlCommand sqlComm;
cm = Dts.Connections["OLE_TEST_"];
sqlConn = (System.Data.SqlClient.SqlConnection)cm.AcquireConnection(Dts.Transaction);
sqlComm = new System.Data.SqlClient.SqlCommand("Exec dbo.sOp_xx_XXXe_VXX 280", sqlConn);
sqlComm.ExecuteNonQuery();

above code , no message box.

View 2 Replies View Related

DB Engine :: Start Or Call System AUTO-SHRINK Process?

Jul 23, 2015

Is it possible to manually force/call/start the system AUTOSHRINK process? I have an issue that appears only when the engine shrinking process is running and I need this to reproduce my bug.

I know how to start a "regular" database shrink process with:DBCC SHRINKDATABASE(xxxx);, but this is not the same as one started from the database engine.

View 13 Replies View Related

Rebuilding System Databases On A Cluster

Jan 5, 2007

I am having trouble rebuilding the SQL 2005 system databases on my cluster.

The Cluster hardware failed completely and I am recovering from scratch (but only 1 node at this time)

The Win2K3 OS is recovered and communicating with the domain.
Cluster services have started and the quorum is online.
The clustered SQL instance is offline because there is no master.mdf present.

I run the setup command as per BOL:

start /wait setup.exe /qn VS=<VSName> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=<StrongPassword> SAPWD=<NewStrongPassword> SQLACCOUNT=<domainuser> SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domainuser> AGTPASSWORD=<DomainUserPassword>

The Summary.log reports the following:
Machine : CLUSTER1
Product : Microsoft SQL Server 2005
Product Version: 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL ServerSetup BootstrapLOGFilesSQLSetup0001_CLUSTERSVR1_SQL.log
--------------------------------------------------------------------------------

Setup succeeded with the installation, inspect the log file completely for status on all the components.



However the Microsoft SQL ServerMSSQL.1MSSQLDATA directory is empty. There are no system databases.

Without a rebuilt Master I cannot bring the clustered SQL instance online to then restore my database backups.

Any ideas?

D.

View 7 Replies View Related

(system) Variable That Holds The Record Count Of A Result Set?

Jan 18, 2006

Hellois there a variable that is available to me that contains the numberof rows contained in a dataset return from a database call?
have a class that runs a stored proc and returns a dataset/resultsetlooking to simply assign an integer this value if it is possible
i'm using (learning) vb.net and sql server
thanks in advance

View 4 Replies View Related

System Stored Procedure Doesn't Return Result (eg: Sp_update_schedule)

Apr 9, 2007

I am trying to catch the @retval which is returned finally after executing sp_update_schedule stored procedure (o or 1) but i cannot catch the final resultIf i put Print statement just before the return (@retval), then i am seeing 0 as output but i want to catch that value when i execute the SP with the parameters. How can i do that?? same thing with all other system stored procedures.thanks alot in advance....if you want more info on this Q, plz let me know 

View 5 Replies View Related

Call Stored Procedures Or Job From Access

Nov 20, 2003

How can I get a group of stored procedures or a job to run on the sql server from Access?

Thanks

View 1 Replies View Related

ODBC-Call Failed - Access

Sep 15, 2006

We have this fairly simple Access database with a link table to a view in an SQL Server. The Select Query in Access is a simple select from this view with a view criteria set. Nothing fancy. What is driving is moderately crazy is that this Select Query in Access seems to work fine for months and than all of a sudden (same query performed around the same time with about the same workload on the SQL-Server) it responses with the helpful "ODBC-Call Failed" message. Closing the Access database, taking a coffee, coming back againg and try the exact same Select Query normally works, no "ODBC-Call Failed" message.

It not happens always, mosty we're fine.
When it happens it happens for all subsequent queries tried. We have to close and reopen the Access database and pray to the good Lord that it works.

We would be very interested in someone with a solution to this problem.

View 20 Replies View Related

MS Access ODBC Call Failed

Nov 14, 2007

I am having an issue that i can't seem to resolve. By no means am I an expert with odbc connections and what not but any help would be great.

here is my issue. I have a 64 Bit terminal server that is running MS Access. I have defined my DSN within the 32 bit admin utility and it connects without a problem As soon as i try to link tables and make a connection to the database from within Access i recieve an "ODBC CALL FAILED" message.

I enabled tracing and here is what i got.....this doesn't mean anything to me but hopefully it does to someone.....


PaintJobShip_Ma 1388-ecc ENTER SQLAllocEnv
HENV * 002DB3C4

PaintJobShip_Ma 1388-ecc EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x002DB3C4 ( 0x07f42538)

PaintJobShip_Ma 1388-ecc ENTER SQLAllocConnect
HENV 07F42538
HDBC * 002DB4D4

PaintJobShip_Ma 1388-ecc EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC * 0x002DB4D4 ( 0x07f425e0)

PaintJobShip_Ma 1388-ecc ENTER SQLSetConnectOption
HDBC 07F425E0
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014

PaintJobShip_Ma 1388-ecc EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 07F425E0
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)

PaintJobShip_Ma 1388-ecc ENTER SQLSetConnectAttrW
SQLHDBC 07F425E0
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3

PaintJobShip_Ma 1388-ecc EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 07F425E0
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3

PaintJobShip_Ma 1388-ecc ENTER SQLDriverConnectW
HDBC 07F425E0
HWND 000800D4
WCHAR * 0x4BF78088 [ -3] "****** 0"
SWORD -3
WCHAR * 0x4BF78088
SWORD 2
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>

PaintJobShip_Ma 1388-ecc EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 07F425E0
HWND 000800D4
WCHAR * 0x4BF78088 [ -3] "****** 0"
SWORD -3
WCHAR * 0x4BF78088
SWORD 2
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>

DIAG [S1000] [Oracle][ODBC][Ora]ORA-06413: Connection not open.
(6413)

DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4458
SWORD 4095
SWORD * 0x002DB3C8

PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (6413)
WCHAR * 0x036A4458 [ 102] "[Oracle][ODBC][Ora]ORA-06413: Connection not open. a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0"
SWORD 4095
SWORD * 0x002DB3C8 (102)

PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A44D6
SWORD 4032
SWORD * 0x002DB3C8

PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (0)
WCHAR * 0x036A44D6 [ 66] "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"
SWORD 4032
SWORD * 0x002DB3C8 (66)

PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A456C
SWORD 3957
SWORD * 0x002DB3C8

PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (0)
WCHAR * 0x036A456C [ 66] "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"
SWORD 3957
SWORD * 0x002DB3C8 (66)

PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4602
SWORD 3882
SWORD * 0x002DB3C8

PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4602
SWORD 3882
SWORD * 0x002DB3C8

PaintJobShip_Ma 1388-ecc ENTER SQLFreeConnect
HDBC 07F425E0

PaintJobShip_Ma 1388-ecc EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 07F425E0


any help would be great....thanks.

View 3 Replies View Related

How Can I Call MS Access Records From A SQL Store Procedure

Nov 30, 2004

How can I get MS ACCES database records from an sql Stored Procedure. Idea is I have a SQL stored procedure, which wants to calculate a few things using some data from an MS access DB. Is it possible or am I talking against any DB principles?

View 1 Replies View Related

Random Access In A Result Set

Oct 6, 2005

I use an SQL task to produce a result set which I store in a package variable.

View 15 Replies View Related

Access DB Via SqlDataSource....need Result In DataSet

Jun 21, 2006

Hi all...I've set the DataSourceMode = SqlDataSourceMode.DataSet, and did a .Type return and found that it is actually returning a DataView.  A component I am trying to avoid rewriting....requires a dataset that loops through the table, does some cool formatting to a datagrid and then rebinds.Here's the code that I'm trying to send the dataset to....maybe there's just a couple of changes that could make it work with a DataView?          int i = 0;        string prevsub = "";        while (i <= ds.Tables[0].Rows.Count - 1)        {            DataRow dr = ds.Tables[0].Rows[i];            string sub = dr["SubHeading"].ToString();            if (sub != prevsub)            {                prevsub = sub;                DataRow newrow = ds.Tables[0].NewRow();                newrow["Title"] = "SubHeading";                newrow[columnName] = dr[columnName];                ds.Tables[0].Rows.InsertAt(newrow, i);                i++;            }            i++;        }

View 2 Replies View Related

Access To Decision Tree, Cluster... Charts From C# Or Word

Nov 20, 2007



Hi!
We use SS2005.

a.)
Let's assume you already have defined "mining model" and they are visible in object explorer for Analysis Services.

How to show the picture in an web form (and no I don't want to right click, taking an snapshot of the picture in SSMS or Visual Studio) using c#-api? Alternative: for some time ago I read something about that you can do this in Word, but I can't find the article...

I could see there is an C#-api for Reporting Services so I would expect similar for Analysis Services ;-)

b.)
Lets assume I don't want to go through Visual Studio to creating models. How to store/create new datamining models via C#? And of course: how to force the calculation of the values for node splits etc.?


The solution for "a" will ensure that I always get an actual version of the charts.
Why I ask for "b": Management thinks this will be great for root cause analysis. But I think there is the risk that the
many resulting models, which probably differ will be more confusing than helping.

Thanks

View 1 Replies View Related

VIEW On MS SQL Giving Different Result That Query On ACCESS

Mar 13, 2008

Good morning,
I'm trying to create a view on SQL Server based on a query that i use on Access. The query returns detailed data from a table based on ID's selected and saved into another table.

the thing is, on access it returns back 5 records<which is a correct output> , while on SQL. its returning only one record. what could be the issue here ?

thank you,

View 3 Replies View Related

Recovery :: Access To Files On Shared Drive When Cluster Is Shut Down?

Aug 31, 2015

Is there a way to get access to the files on the shared drive from either of the nodes when the SQL Cluster is shut down?

It doesn't look like there is, but hoping there is some trick. I see how it can be done with a Windows Cluster but not a SQL Cluster.

View 4 Replies View Related

Xml Result Set To A Variable In Ssis And To Access It In Script Task

Apr 28, 2007

Hi!

I have an sproc that gives an xml result set. I want to save this to a file but by using ssis and script task. Now, I do exec usp_myProc in execute sql task and get the result as xml. (I can get it as result set too but niether has worked). Now I pass this variable to my script task User::XRset.

In the script task I create a file and then I want to write xml result of User::XRset to my file. I am at loss.

View 4 Replies View Related

Dbase Access On A 64-bit System

Nov 21, 2006

Hello all...

I created several SSIS packages on a 32-bit system, using odbc to to access the dbase source file. Finally, after setting up a proxy, etc., we got the package to run and import data. We then needed to move the packages to a 64-bit system. So, we built our manifests, and installed all of our packages. We are using several dtsConfig files for our packages, and in there we specify the DSN that we will be accessing. I understand that MS does not support odbc drivers in a 64-bit world (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=85703&SiteID=1). Has anyone been faced with this issue? How did you get past it? I accessed the 32-bit odbc drivers on the 64-bit system, and i setup a dsn that points to the dbase file, but when i run the job, the log file has an error that the dsn was not found. However, when I run the package itself, it runs as expected...

Please help!!  :-)

Craig

View 1 Replies View Related

System Information Tables For MS Access

Oct 24, 2005

Hi

Sorry if i am posting in the wrong section but i can't find a forum for MS Access.

Does Access know of a equivelent to SQL Servers INFORMATION_SCHEMA tables?

I am writing a application that needs to extract information from a access database like, table names, relationships etc..

Please note that i need to do this via SQL.


Thanks Wayne

View 1 Replies View Related

Importing From Access With System Database

Jul 13, 2004

I am trying to import tables from my access database.

1st trying simple table, In ent mgr i right clicked the db folder
all task
import data
data source : Microsoft access
file name : c:Data Management SystemDMS.mdb
User name : mike (same used for lonin in access)
password : (same used for lonin in access)

advanced button:
jet Oledb: System database c:Data Management SystemSecured1.mdw

windows authentication
server (local)
database New -> dms

copy tables

now i see the items in my access database so i am guessing every step so far was correct

hey it worked !

ha,, hope u dont mind if i leave this here for anyone else, i ansd my own ?

View 2 Replies View Related

How To Access System Catalog Views From A UDF

Nov 26, 2007

I'm trying to access a System Catalog View (sys.database_permissions, and others) from a table valued function. I need to be able to pass the database name into the function so that I can operate on any database. Typically I'd use dynamic SQL to do something like





INSERT INTO #tempTable

EXEC ('SELECT * FROM ' + @DBName + '.sys.database_permissions')



But of course I can't use dynamic SQL inside of a UDF. I know I could do this using a stored procedure, but I'd need the output to be a recordset that I can query.

Has anyone done anything like this? I think I'm stuck.

View 5 Replies View Related

SQLCLR File System Access

May 11, 2006

I have just begun to delve into the SQLCLR objects in SQL Server 2005. I have created a simple VB function as a SQLFunction. Here's the code:

Imports System

Imports Microsoft.SqlServer.Server

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction()> _

Public Shared Function FileDate(ByVal FilePath As String) As Date

Return FileDateTime(FilePath)

End Function

End Class

The function is run with this T-SQL:

declare @FileDate datetime

select @FileDate = dbo.FileDate('C:setup.bat)

select @FileDate

This works fine, but I had to set the Permission Level of the Visual Studio project to "Unsafe" rather than "External" in order to avoid the following error message:

A .NET Framework error occurred during execution of user defined routine or aggregate 'FileDate':

System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Is there any way to avoid having to set the permission level to "Unsafe"? If not, what does "unsafe" mean in terms of overall system security? Is it acceptable to use on an internal LAN?

Thanks,

Ron

View 1 Replies View Related

Access To SQL Server System Logs

Jul 6, 2006

I'm a developer and mostly develop Service Broker applications for my company. I do have logging for my application but unforseen errors will normally show up in the SQL Server System Logs. What would be a good way to give a developer access to read the SQL Server logs without giving away the keys to kingdom. Would that be through xp_readerrorlog or is there a better way of accomplishing this?

View 1 Replies View Related

How To Access Data From Different Database And Display Result Set In Managed Stored Procedure

Jan 31, 2008

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports System.Data.OleDb
Imports System.Configuration
Imports System.Text
Imports System.Collections

Partial Public Class StoredProcedures
<Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub StoredProcedureTest(ByVal strAS400ServerName As String, _
ByVal strCompany As String, _
ByVal decSerial As Decimal, _
ByVal strSerialCode As String, _
ByVal strSerialScan As String, _
ByVal decMasterSerialNumber As Decimal, _
ByVal strCustomerPart As String, _
ByVal strTakataPart As String, _
ByVal strCustomerRanNo As String, _
ByVal strCustomerAbv As String, _
ByVal strDestinationAbv As String, _
ByVal decQty As Decimal, _
ByVal strCreatDate As String, _
ByVal decVoidSerialNo As Decimal, _
ByVal strProductionLineNo As String, _
ByVal strProcType As String)

Dim sp As SqlPipe = SqlContext.Pipe
Dim strResult As Integer = 0
Dim strErrorText As String = String.Empty
Dim dsData As New DataSet
Dim parameter(15) As OleDbParameter
If Not strAS400ServerName Is Nothing And strAS400ServerName <> String.Empty Then
' Populate parameter collection

parameter(0) = (CreateParameter("PARM1", OleDbType.Char, 20, ParameterDirection.InputOutput, strAS400ServerName))
parameter(1) = (CreateParameter("PARM2", OleDbType.Char, 2, ParameterDirection.InputOutput, strCompany))
parameter(2) = (CreateParameter("PARM3", OleDbType.Decimal, 10, ParameterDirection.InputOutput, decSerial))
parameter(3) = (CreateParameter("PARM4", OleDbType.Char, 2, ParameterDirection.InputOutput, strSerialCode))
parameter(4) = (CreateParameter("PARM5", OleDbType.Char, 25, ParameterDirection.InputOutput, strSerialScan))
parameter(5) = (CreateParameter("PARM6", OleDbType.Decimal, 10, ParameterDirection.InputOutput, decMasterSerialNumber))
parameter(6) = (CreateParameter("PARM7", OleDbType.Char, 30, ParameterDirection.InputOutput, strCustomerPart))
parameter(7) = (CreateParameter("PARM8", OleDbType.Char, 15, ParameterDirection.InputOutput, strTakataPart))
parameter(8) = (CreateParameter("PARM9", OleDbType.Char, 15, ParameterDirection.InputOutput, strCustomerRanNo))
parameter(9) = (CreateParameter("PARM10", OleDbType.Char, 6, ParameterDirection.InputOutput, strCustomerAbv))
parameter(10) = (CreateParameter("PARM11", OleDbType.Char, 6, ParameterDirection.InputOutput, strDestinationAbv))
parameter(11) = (CreateParameter("PARM12", OleDbType.Decimal, 9, ParameterDirection.InputOutput, decQty))
parameter(12) = (CreateParameter("PARM13", OleDbType.Char, 10, ParameterDirection.InputOutput, strCreatDate))
parameter(13) = (CreateParameter("PARM14", OleDbType.Decimal, 10, ParameterDirection.InputOutput, decVoidSerialNo))
parameter(14) = (CreateParameter("PARM15", OleDbType.Char, 3, ParameterDirection.InputOutput, strProductionLineNo))
parameter(15) = (CreateParameter("PARM16", OleDbType.Char, 2, ParameterDirection.InputOutput, strProcType))

RunDB2Sp("FABLE.MAP", parameter, dsData)

If dsData.Tables.Count > 0 Then
dsData.Tables(0).TableName = "Supreeth"
Dim bitresult As String = dsData.Tables(0).Rows(0)(0).ToString()
Dim errorstring As String = dsData.Tables(0).Rows(0)(1).ToString()

' I am not sure here
SqlContext.Pipe.Send(bitresult)
SqlContext.Pipe.Send("No errors")


End If

Else
Throw New ArgumentException("AS400Db.GetAS400TraceabilityResult: AS400 server name is empty or invalid")
End If

End Sub

Public Shared Sub RunDB2Sp(ByVal strProcedure As String, ByRef parms As OleDbParameter(), ByRef dsData As DataSet)
'*********************************************
' Declare Variables
'*********************************************
Dim daAdaptor As OleDbDataAdapter
Dim cmdAS400 As OleDbCommand
'Dim dstestMe As New DataSet
Try
cmdAS400 = CreateCommand(strProcedure, parms)
daAdaptor = New OleDbDataAdapter(cmdAS400)

' Fill the Data Set
daAdaptor.Fill(dsData)
Catch expError As OleDbException
daAdaptor = Nothing
Finally
daAdaptor = Nothing
cmdAS400.Dispose()
'Me.Close()

End Try

End Sub
Public Shared Function CreateParameter(ByVal name As String, _
ByVal type As OleDbType, _
ByVal size As Integer, _
ByVal direction As ParameterDirection, _
ByVal paramValue As Object) As OleDbParameter
Dim param As OleDbParameter = New OleDbParameter
param.ParameterName = name
param.OleDbType = type
param.Size = size
param.Direction = direction
param.Value = paramValue
Return param
End Function

Private Shared Function CreateCommand(ByVal strProcedure As String, ByVal prams As OleDbParameter()) As OleDbCommand
Dim CmdSAS400 As OleDbCommand
Dim parameter As OleDbParameter
Dim connAS400 As OleDbConnection
connAS400 = New OleDbConnection("Provider=IBMDA400;Data Source=AHISERIESDEV1;User Id=****;Password=****;")
connAS400.Open()

CmdSAS400 = connAS400.CreateCommand()
CmdSAS400.CommandText = strProcedure
CmdSAS400.CommandType = CommandType.StoredProcedure
CmdSAS400.Parameters.Clear()
'CmdAS400.CommandTimeout = intTimeOut
If (prams Is Nothing) Then
Else
For Each parameter In prams
CmdSAS400.Parameters.Add(parameter)
Next

End If

Return CmdSAS400

End Function

I have a UI which supplies 16 parameters to my stored procedure , which in turn call another sored procedure on as400 which returns result set. So far i am able to send 16 parms and get the values in dataset.
My question here how would i send the result set to UI for display, please feel free to comment on any changes need to be made on code . I badly need to find a solution for this and i appreciate any feed backs

Thanks

View 3 Replies View Related

Access Linked Server System Function

Mar 16, 2007

Could anyone shed some light on the syntax of accessing system function on a linked server?I'm trying to get the recovery models of databases on a linked. However using databasepropertyex locally generates wrong results.e.g. select databasepropertyex(name, 'recovery') RecoveryModel from [server/databasename].master.dbo.SysDatabases I tried select [server/databasename].databasepropertyex(name, 'recovery') RecoveryModel from [server/databasename].master.dbo.SysDatabases which does not work.  Thanks. 

View 1 Replies View Related

SQL - System Table In Data Access Layer?

Apr 5, 2007

How do I get a System Table like 'Sysobjects' into the Data Access Layer?
My app generates tables on the fly, and has to check in the sysobjects table which tables are present.

View 5 Replies View Related

How Do I Access Sql System Stored Procs From Code

Jun 2, 2004

Hello:

Okay not really understanding how to do this, but how do I access system stored procedures from code? Basically I would like to determine information about each table in my database, the primary key, number of columns, the names of the columns and the datatypes of the columns in each table. Not too much to ask. How do I go about accessing this information. I have a fairly good idea on how to do it using T-SQL but how do I do it using an assembly? Has anyone else done this before? Any help would be greatly appreciated!

Thanks

View 2 Replies View Related

SQL Security :: How To Stop System Database Access

Jun 2, 2015

We created one SA login [login name: test_db] and give the Db_owner permission for particular user db, but this test_db login able to access the all system database except model database.Here problem is I am giving the only one particular user database but that login why able to access the system database.Here how to stop the system database access…

View 8 Replies View Related

Logging With Another System User Cannot Access My Database

Mar 3, 2008

Hi,

I am using SQL Server Express Edition 2005 as a backend database working with Visual Basic 2005.

I am using Vista and having two users to access to my computer. User-1 and User-2.

I created a database in User-1 and works fine Visual Basic 2005.

Now the problem is when i login to my computer system with User-2. I cannot able to access the database with encountering error like "User-1/SQLExpress". I know that i cannot able to access to database which was created in User-1.

Do you any solution to this problem. when i login with user-1 and user-2 it should able to access database.

Thanks.

Regards
Kashif Chotu

View 1 Replies View Related







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