Does anybody know how to bind parameter of type SQL_TIMESTAMP_STRUCT to
datetime columns in such a way that execution ({call XXX(?)) will not give me
"Invalid precision value" if I specify SQL_TIMESTAMP_STRUCT.fraction > 0. It
seems that if bind directly to SQL_TIMESTAMP_STRUCT ...

I have a network with 6 machines sitting on it.
All PC`s are configued in the same way. 5 of the machines connect to a SQL
server via ODBC with no problems.
The sixth PC however does not connect to the server giving the following :-

What are the limitations for SQL 2005 Express. ie How many concurrent users
can you have, what size database can you have etc.
Where can I find this type of information? I have searched the MS site with
success.

I've installed SQL server 2k5 and all services on a WIN2k3 SR2 server as a
named instance (SQL2k5_01)  (There is no default instance and this is a
brand new server), and while I was able to establish a local connection from
the management studio I needed to type in the instance ...

Hello, I have a SQL 2000 server running on English Windows 2003 server. My
test program is running on a Windows 2000 professional, Chinese version. I
created some big5 data in a dummy table, when I read it via JDBC driver,
that data becomes ???????? in the output. How can I read ...

I have a connection string I use in a communication program I have created
and I'm curious about something.
Here is the string I use:
connection-string="Driver={SQL

Anyone know workaround/info for the following errors?  I'm using the
new MS jdbc driver against SQL Server 2005 64 bit.
Error 1:
Error from command 1!!!!!!

Hello World,
Microsoft SQL Server Management Studio Express 9.00.2047.00
From ASP (ASP3) code, coudn't connect SQL Server 2005 Express (on the same
local machine)

This is a small test network while
studying for my MCDBA.
I have 2 MS 2003 servers, 1 XP Pro WS.
SQL 2k SP4 is loaded on one server and

Is this a known issue?  I am using the MS JDBC driver to connect to SQL
Server 2000 SP3a.  The driver version is either SP2 or SP3.  I tested both
with the same results.  The database collation is Latin1.  Sun java 1.3.1 or
1.4.2.  When using the ...

I am trying to restructure the current system now. I would like to consult
which programming is good for front end application to link to SQL DB?
Thanks
Char

I'm trying to simulate a pure HTTP connection between two SQL servers.
I have 2 machines on the same LAN both running SQL Server 2000.  On both
machines I have turned on the firewalls and only allowed traffic on port 80.
In the Client Network utility on one machine I create an ...

I installed SQL Server 2005 yesterday on a freshly installed Windows 2003 R2
standard server.  I installed with mixed-mode authentication and was able to
connect to the database.
The server was then changed to a PDC with a new forest and domain.  I am now

I installes sqlserver 2005 express on windows server 2000 sp4
(name=pen1800).
When running this:
'sqlcmd -S pen1800 -U administrator'

we downloaded the final release of the JDBC driver for 2005 and tested it
with our application.
Unfortunately, we found the following problem:
If a batch insert is performed with a PreparedStatement on a connection