I created a form in Access 2003 who's recordsource is an ODBC linked table from
SQL Server 2000. The form has a subform that lists all the records in that
table. The form also has all the fields from that table as separate controls.
I have a command button to add new records, which ...

I upgrated SQL Server 2000 SP4 to SQL Server 2005 SP1 successfully. I'm
able to run my application with tomcat. With Websphere 5.1.1.7 I'm using
'WebSphere embedded ConnectJDBC driver for MS SQL Server' to create JDBC
provider and a dataSource. Test connection to SQL Server 2005 is

I currently have the SQL Server 2000 JDBC driver installed on my
production Tomcat host in /usr/local/tomcat/common/lib.  I have a
datasourced defined in server.xml (yeah, I know it's global, but I have
my reasons ;-)  ) which I link into my servlets via a ResourceLink.

Does the driver support statement caching?

Just installed the eval edition of 2005, and when I went to make a
connection, was told that the engine wasn't started.  How do I start the db
engine???

Statement statement = conn.createStatement();
statement.execute("CREATE PROCEDURE #ONE AS BEGIN SELECT 'ONE'  END");
statement = conn.createStatement();
statement.execute("{CALL #ONE}");

Does there exist an ODBC or OLEDB/ADODB driver for talking to SQL
server over HTTP/port 80?
In other words, I want to be able to issue SQL commands (INSERTs,
UPDATEs, SELECTs) from a client application to a database that happens

I have some application that fails to connect to my SQL Server 2005 Express
Edition (PC\SQLEXPRESS).
The application configuartion required providing connection string. I have
written:

We have a setup of two SQL server 2005 instances, where server B mirrors
databases from server A. We want to use fail over with jdbc so if server A
fails
B takes it's role. To accomplish this, we set the connection URL like this:

Some application I need cannot connect to my SQL Server 2005 Express Edition
because of the following problem:
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not
loaded. Check the java.library.path system property.

 How can I determine the size of my server in sql server? Please help!
Thanks!

I want to call a sql serrver stored proc from odbc (usigh c++) whicc
takes a single datetime parameter as input.
I've tried
SQLINTEGER sqlLength = 0;

Folks,
I have an MDF and LDF file which I am attempting to attach as a SQL db. I
keep getting the error 602 that begins with "could not find row in sysindexes
for database ID 13, object id 1, index id 1".

I need to access text files dinamicaly.
Here is the solution I used in SQL Server 2000...(unfortunately it didn't
work in SQL Server 2005)
Create a linked server using MSDASQL provieder, add login:

i have two inserts and one delete i want in one transaction, is there any
issue with this tsql strategy: http://rafb.net/paste/results/uY2KYP16.html