I'm trying to call an  Oracle stored procedure from Sql server and I have
this error message
Could not execute procedure 'INTEGRE_INTERNET' on remote server 'ORA_DEV1'.
[OLE/DB provider returned message: One or more errors occurred during

Hi,
I'm trying to insert a time stamp into SQL Server (2005) and can't figure
out the right combination of column type and arguments to SQLBindParameter().
My C code currently looks like this:

All
Anyone know what is truly recommended for the NIC settings for SQL 2005 when
installed on Windows 2003?
Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be set

My issue like that....
I have SQL Server 2000 enterprise edition installed as named instance. I
have configured mixed mode authentication also. But the problem is whne i try
to register my sql server usuing windows authentication i get the following

I have SQL Server 2000 Client installed on Windows XP and SQL Server
2005 Database on Windows 2003 which is not on domain. I want to access
SQL Server 2005 database from SQL Server2000 Client. When i am trying
to connect it, i get access denied error. Is it possible to connect...?

I set up a package with runs from a batch file on my computer after creating
the script with DTSRunUI.  I cannot run it on another computer.  Do I have to
copy DTSRun.exe to the other computer with the related rll files to get it to
run ? Is there a recommended way to do this ?

Is there a way to specify the sysprocesses.program_name value in the OLE DB
connect string?  I can't find the syntax anywhere.
Thanks,
Tom

Just a few days ago, we changed the password on our server. After that, I
noticed that I could not open Query Analyzer from within Enterprise Manager.
I can open Query Analyzer from the start menu and login that way, but can
someone help in where to look to make it be able to ...

 When i try to attach my DB via a JDBC-Connection and the usage of
sp_attach_db [<dbName>], '<md fFile>','<ldf File>'
my db's are only attached "read only". Attaching them with the Management
console, using the same login, works fine and i can write into the database.

I have a SBS2003 server that required a re-install of Sharepoint.  I had 2
databases that are part of a document locator application, the application
made its' connection using sa and the associated password. I removed and
reinstalled Sharepoint and upgraded the sharepoint ...

I've just done my first install of SQL 2005 Express and am having
problems connecting from a remote workstation using a VB6 application
that I believe used OLE DB/ADO.
I did get the application to connect, but only by installing an

I have read all I can find and am just frustrated...
Our system uses SBS on a company network and Server 2003 for our web server
that is not in the company domain.  I am developing a web based system with
VS2005 Pro.

I set up a customer error messge and auto email which record form data and
error details on our web site in order to proactively to monitor what's going
on for eCommerce site.
Today, I got one message like this:

We need to connect a Java stand-alone program to conenct to a SQL server 7.0
database.
I can't find any drivers to connect to the database.
Can you please point me to a JDBC driver to access SQL Server 7.0?

e.g. in an local area network..
server = 192.168.0.1
me = 192.168.0.2
i just simply using Windows Authorization, then it could be abled to login