What is the equivalent for INOUT parameter in SQLServer.
In Oracle storedprocedure we can declare a  variable as INOUT parameter.
Can we have a equivalent in SQLServer.
If so, how can i set value for that parameter in jdbc.

Please forgive me if this is the wrong forum and suggest a better place to
ask, but here goes:
1. How can you discover in vb.net code what servers are connected to the
network your PC is talking to? (I.E. How to the various MS tools that have a

I keep getting an ODBC error (varies)  I have SQL 7 on windows 2000 server
with all the updated service packs and patches for the OS and SQL.  I also
updated MDAC to 2.8 sp2.  We use a third party software program that connects
to the SQL database to store all our data.  Every so ...

i install a windows 2000 family and a sql server enterprise.
I don't set any db params,but it is only let one client to link.
what? can you help me!

I am trying to set up MySQL as linked server for SQL Server 2000.
These are the steps I already have taken.
1- Installation of MyODBC 3.51 driver
2- Creation of ODBC Data source with name 'MySQLODBC' and connecting to

Hello all,
When I used DTS, I found out that network library pointed Named pipes at
Process Info in Current activity panel. As my understanding, the network
library should points TCP instead.

I am trying to register a new SQL server with enterprise manager and I get
the following error message:
SQL Server does not exist or access denied
The SQL Server (its name is SATURN) is running Windows 2003 SP1.

I need to be able to determine the method used to close a Context menu.  It
appears that there are three possibilities: 1) a menu selection was clicked,
2) the User clicked outside the menu or 3) the User hit ESC.  I need to
determine if the menu closed due to either of the last two ...

I am using MS SQL Server JDBC Driver. I call a stored procedure from my java
code. The Stored Procedure does some inserts. One of the insert failed but
in my java code the SQLException is not thrown. Can anybody tell me how to
fix this bug?

I am having trouble connecting to SQL 2005 June CTP on Windows 2003
Enterprise from remote  SQL 2000 SP4.
I get the folloewing message:
SQL Server does not exist or access denied.

I would like to create a System DSN on a server (named IO running Windows
2003 SP1 and IIS 6)  to connect to an SQL Server (named SATURN running
Windows 2003 SP1 and SQL Server 2000 SP4).
SATURN is using the Windows authentication and the account creating the DSN

I have two computers, a Windows XP machine with MDAC 2.7 SP1 (sqlsrv32.dll
version 2000.81.9042.0) and a Windows Server 2003 machine with MDAC 2.8 SP2
for Server 2003 (sqlsrv32.dll version 2000.86.1830.0) as confirmed by MDAC
Component Checker.

We are using SQL 2k(sp3) with Win2k3.
I started getting this error lately, every time someone connects to the
server, we end up in this error. if i reboot the machine , it works fine for
a while and then again the error.

Hi all, newbie of SQL2000.
Running in LAN SBS2003 with SQL2000 SP3. From a client (InfoPath) I want
to make a dataconnection to SQL2000, but access is denied.
How can I check from the client-PC whether a connection is possible with

We have a client application which runs on about 15 workstations
(Windows XP). This application connects to a SQLServer 2000 database
held on a Windows 2003 server.
The connection is done through ODBC.