I am looking for a way to read a seperate .txt file and extract the
paramaters for a query.  I am given a .txt file with several thousand numbers
a day, to query against the database.  I would very much like to call the
file and read it's contents in as the paramater.  Is this ...

i get the following error
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'5'. (#170)
when trying to update or delete a record from an Access Linked table. Adding

I am trying to get ISA2004 to allow my SQL Server installation to talk to a
database on the outside world.
I have had port 1433 TCP/IP opened and this allows me to see the database.
The weird thing is that when I try and use the DTS Import/Export wizrd, it

I've installed SQL Express as the default 'SQLExpress' install (windows
authentication) and while I can connect fine to my created databases from VS
Web Edition 2005 (using the test server) I cannot get access to the databases
from IIS http://localhost/test.aspx for example.  ...

I have SQL Server 2000 installed on my XP Pro PC and the Client Tools (SQL
Query Analyzer) installed on my 98SE PC. On the 98SE PC, when I start SQL
Query Analyzer, I get a window titled "Connect to SQL Server" but the SQL
Server line is blank and the drop-down arrow is also ...

I installed Msde, the Sql server desktop engine in Windows 2003 server,
then I am trying to connect it via enterprise manager, but failed, the msde
instance do not show up in enterprise manager,  but do show up in system
service list, what can I do ?

We've got SQL 2000 clients (standard install, no sp) who are connecting
to our SQL 2000 Servers with Named Pipes even though we've disabled
named pipes in the client network utility. They should be connecting
via tcp/ip. Any ideas on what could be causing this?

I have two sql servers that reside in seperate AD forests and that are
separated by a firewall. I need to enalbe connectivity between the two sql
servers. In addition to port 1433 are there any other ports that need to be
opened

Is the protocol for SQL Server available anywhere? In other words, if I
TELNET to my server on port 1433, can I issue raw commands right there like
I could with, say, SMTP or POP3?

I'm getting the following syntax error while preparing my statement. I
believe the problem is caused by the use of bind variables within JDBC
escape sequences, eg. {fn YEAR( {d ?} )}.
JDBC driver is:

Is there any way to know any user Connect / Disconnect from the SQL Server?
Such as:    In any kind of "Method"  OR  "Event Log"

I have used the ole db services for odbc to utilise a informix odbc driver to
create my linked server in SQL server.  The Informix IDS server in question
is v9.4 on Suse Linux Enterprise V8.
If I use the informix ODBC via Query in Excel I can retrieve data from the

Ok, I can connect to the sql server instances using
tcp:ServerName,PortNumber.  However; I still cannot connect using
ServerName\InstanceName.  This would not be a big deal, if I could get
Enterprise Manager on a remote machine to register the instance using the

I followed an example from the Chap 12 of "Beginning Active Server
Pages 3.0 (Wrox 1999)" to connect to my Access and SQL Server databases
with the following Coonection Strings.
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _