I have an application running on 2 w2k3 servers, each running IIS. (These
servers sit behind a load balancer.) Each server needs to connect to a
database on a remote server. The connection string to the remote server is
stored on another SQL server in the same LAN as the IIS ...

I want to fetch all records of a table where the datefield (datetime field)
equals getdate().
select * where mydatfield = getdate()
but this gives nothing because getdate() which also contains the min. and

I am having some dificulties with the extended procedure sp_OACreate, only
when using the SQL Server 2005.
I am using some COM+ objects inside a procedure, and to access these objects
and create them I was using these extended procedures : sp_OACreate,

I have seen example vb.net 1.1 code that uses a commandtext string that
includes a parameter. The commandtype is commandtype.text, not a SP. I did
not know it was possible to do this. I would like to understand what is
going on here and exactly how the use of parameters works ...

hi ,
i am getting the following error , it happens just in sqlserver, not in
oracle .
i replaces the driver from JTDS to the regular microsoft driver ,

I am getting the following error in MS SQL SERVER 2005 Enterprise Edition.
The IP reported does not even belong to our domain.
Does it means someone is trying to hack into our system or something else?
Any suggestions please?

If one of my third party applications makes a connection to a SQL database
and runs a select *.... and returns a {...} values?  Do I need x licenses
based on the # of users connecting to the database?, I expect multiples
connections might occur every minute?

I tried connecting to SQL server 2008 using the TDS jdbc driver & it throws
the connect exception:-
DBDriver exception java.net.ConnectExceptionConnection refused: connect
. Has anyone tried connecting to SQl server 2008 using jdbc.

I have developed the ODBC app which can work with Oracle as well as
MSSQL server databases. I need to use transactions at some level. By
setting AUTOCOMMIT OFF and using SET TRANSACTION and BEGIN WORK,
COMMIT WORK everything works fine with Oracle. But with MSSQL server

I'm getting the following error while executing a simple SELECT * FROM table
query. I'm using MS SQL Server 2005 JDBC Driver 1.2.
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Unhandled data
type: TDS_INT8

SQL 2005 with only an *.mdf file
When I attempt to attach an *.mdf file (no *.LDF) I keep getting the message
that the *.LDF file is missing - which it is.  How can I attach this XYZ.mdf
file and not be concerned that I wasn't provided the XYZ_ldf.LDF file?  I

All of my VARCHAR(24) columns are reported as size 7 from
java.sql.DatabaseMetaData::getColumns.  All other sizes from 1 to 49 report
the correct COLUMN_SIZE.
Any ideas?

I'm getting the following error trying to use 32-bit client on a Win2003
64-bit server to connect to an SQLserver 2005 on a 32-bit remote Win 2003
server.
IF I use the 64-bit ODBC manager (SQL Native client  or ODBC DSN), I got

does anyone encountered this error?
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

I'm trying to connect my SQL server to a Progress database.  I have the DSN setup but I don't have a clue how to get to it or the database I'm trying to access. All I want to do is be able to view all the tables in SQL from the Progress database so I can build reports.  I can't ...