Our application has run for years using the SQL 2000 JDBC and the jTDS
driver. I recently tried using the SQL 2005 driver, and I'm getting
unexpected behavior. Here is the scenario...
We have code that inserts data into an SQL table that has a primary key

DearAll group menbers,
I am using SQL Server 2005 and 2000. I want to link SQL Serve 2005 with
2000. When i use linked server configuration i get this message.
OLE DB provider "SQLNCLI" for linked server "linked_server_name" returned

I'm trying to limit the recordset retuned in the sub below by a
variable called vcnumber.  I'm not sure what the problem is but I keep
getting the error "Invalid Column Name" when I set sqlstring to "select
* from vc_names where vc_case_number =" & vcnumber.  If I don't try to

some registry entries about sql server odbc driver was accidently
deleted by me.  now, in the driver page of odbc data source administor,
i can not found the sql server driver in the list.  for the reason, the
SQL Server 2000 can not complete its installation normally, and the

New to ASP2.0 programming, I need some help on the Connection String that I
want to place in the web.config file.
I am running Visual Studio 2005 Web Developer and  the web hosting company
has is using SQL Server 2000.

I have a database on a SQL2000 server that I am trying to connect for viewing
in Access 2003 with the client running Windows 2000.  I have created the
connection, but when I try to view the tables, I get "#Deleted" in all the
rows, for both tables.  I installed the latest MS Jet ...

I have installed MSDE on my machine, it is installed on default port.
When I try to connect using this url it is OK:
jdbc:sqlserver://127.0.0.1;instanceName=PARTNER
But when I "force" the port to 1433 the connection fails ("The TCP/IP

Sorry for the wordiness.
VC++ 8.0, XP Pro SP2, etc.  We're porting from Borland C++
Builder/ADO to VC++/ODBC.  This worked fine with BCB/ADO.
First, the rationale.  We have a number of 'batch' (console) apps

I got the question, how can i connection MS Access Project to a SQL Server
in vba in runtime.
The situation is i create a new MS Access Project, it's didn't have any
connection with any SQL-server. It's just consist a couple of form. What i

I am developing an ACCESS ADP that links to MS SQL, the SQL is on a server,
the ACCESS links to it via a wireless network.  When it goes out of wireless
range, I will lose the link to the database.  Is there a standard way to have
it re-link effortlessly (quickly) when it comes ...

Please let me know whether Microsoft Access(2000), running on our office
computers, will be able to link (over the Internet) to the tables in our SQL
Server (2000) database on your server.

I was doing some testing with client configuration and I'm seeing
something I don't understand. Let me explain the setup.
My setup involves a single machine running "SQL Server Express 2005".
As you probably know, SSE includes the "SQL Server Native Client". I

Hi there,
this is probably a common question,
how can i include the "enabled Quoted Identifiers" settings in the
connection string of the  sqlconnection.

I am trying to use Delphi to create a DSN programatically using the
SQLConfigDatasource function and that seems to work fine.
However when I try  to create a DSN using a specific user name and
password  it does not work.

I have a sql server in the local network.I am able to connect to this
server through my .net windows application using both dsnless and dsn
connection.But using the same code in my web application it is not
connecting to this server.In this case while using dsn-less connection,