I'm new to SQL and am in the process of migrating to a SQL backend for my
Access 2000 front end. I'm going the ODBC route to get my databases up and
running quickly and then move to an Access Project but I'm haveing problems
understanding the relinking issue. Is there a white ...

I’ve run into an issue with a user trying to make an ODBC connection to an
SQL Server database and I have no clue as to why this one thing happens (or
more precisely doesn’t happen). She logs on to her PC with her Id. She can
make a connection to a database on one server with no ...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
Hi all,
I am getting this error while trying to insert a record into the database table.  We are using SQL SERVER 2000/ODBC/ASP combination.

I am running SQL Server 2000 with SP 4 on Windows Server 2003.  Every hour I
receive several notifications with the following:
   Reply: Message not found. Insertion strings:Error: 17805, Severity: 20,
State: 3 Invalid buffer received from client.

any one can suggest me wich is the best provider connection I can use
for my program to connect to an MSSQL 2000, currently I use the
"Microsoft ADO OLEDB for SQL" .
Thanks,

Anybody know why I'm having problems connecting with SQL Server Management
Studio to SQL Server 2005 Developer (September CTP) running on WindowsXP
Professional.  I'm able to connect to the instance just fine when logged into
the machine but not able to connect from other ...

When i connect to the sql server 2000 and find the host_id() function it
gives the result * which is terrifice. I never seen this type of host_id() is
'*'. Any body knows why it gives the * result . Please Help for solution. why
the host id is '*'

i have the same problem with connecting to the sql server 2005 version
9.00.1314 .....i m trying from past two days now....i have installed
sql management studio...but everytime i try to connect with it...using
the server name as SHUCHI...it gives me error as:

We have two applications that connect to three SQL databases on another
machine. Both applications access and update the databases.
One application is a web application (ASP.NET) the other one is a Windows
service.

I have some code that I am testing to read data from a FoxPro file.
I have copied the FoxPro file locally to test.
I have created a linked server that points to this file.  Enterprise manager
correctly shows the tables available.

Using a SQL2000 server on Windows 2003 linked to a SQL2000 server on NT4 we
keep getting a sp_reset_connection on the NT4 box. I'm running a job which
pulls data from the NT4 to the 2003 machine wrapped in a transaction. It
seems to be closing the connection between transactions.

SQL Server Personal edition
Enterprise Manager
on Win 2000
I have the above installed on my own computer

Is there any place where I could find the best way to query a sql table or
access table via ODBC through either a web interface or a transact SQL query
that would post the results to a http page record by record.  (open a web
browser window for each record)  that way if we had to ...

I am writing ASP to connect to SQL server. In the connection
string,when I write the database server as "(Local)" or ".", it will
connected sucessfully. But When I used "127.0.0.1" or "localhost", it
complains with the message "SQL server does not exist or access

Hello newsgroup,
after searching around the web, some reading and testing I'm still having
problems using MARS via ODBC with the SQLServer2005 June CTP.
I'm trying to enable MARS by connection string, after some looking about