|
Prevent ODBC connections
Greetings,
Our company uses Great Plains 6.0 for accounting purposes. The application
uses SQL 2000 as its back-end database. I would like to know if there is
any way to prevent odbc connections directly to the tables in. I think the
application may be using an odbc connection as well too. If this is the
...
Thu, 11 Nov 2004 11:30:25 -0800
|
Connecting to Named Instances
We have a few servers with named instances, 2003 Server w/ SQL 2000 SP3a
running Named Pipes only.
Our users primarily use IIS 5, 5.1, and 6 to connect to these servers with
ColdFusion and ASP .NET applications. Right now the ASP .NET applications
aren't able to connect to the server, here is an example of t ...
Wed, 10 Nov 2004 11:13:43 -0800
|
Remote connection to SqlServer
Hello Guys
We are developing a CRM application using Delphi Front end &
Sqlserver as back end which is
residing on Windows 2000 server. I need a best possible solution,
if this CRM app fornt end is installed in different Location and
making connection to the Sqlserver which is al ...
Wed, 10 Nov 2004 17:05:39 -0000
|
Connecting from outside world
Hello,
I have just set up SQL server on our system.
I would like to be able to connect from accross the internet, like I can
with exchange. (Using EM)
What do I have to do in order to do this?
Many thanks,
NEIL
...
Wed, 10 Nov 2004 16:24:26 -0000
|
How to get all users permissions on different objects of a database in a query
...
Wed, 10 Nov 2004 17:40:00 +0530
|
SQL Server 2000 Linked server to Access data base
We have a production server that is running SQL Server 7.0. On this
server we have a linked server set up that is connected to an Access
2000 data base using an ODBC connection for the data source. The
Access 2000 data base has a linked table that points to an Access 97
database. There is a view created from ...
9 Nov 2004 08:25:58 -0800
|
Number of connections
Hi Gurus,
Is there any way which I can know the number of connections to SQL Server
2000?
Thanks.
--
Best regards,
Lurc
...
Tue, 9 Nov 2004 15:26:25 +0800
|
Encryption not enabled on Server
Trying to get5 SSL work between SQL server and Query Analyzer. I have enabled
encryption on the Query Analyzer client and installed a certificate on SQL
server,
When I connect from QA, i get a message saying "Encrytion not supported on
SQL server".
I enabled "Force Protocol Encryption" on Server and di ...
Mon, 8 Nov 2004 14:30:02 -0800
|
SQL Server communicating on the wrong NIC
Has anyone had problems with SQL Server trying to
communicate on the private network of a cluster setup? I'm
trying to setup replication with a remote server at
another company. Everything was working fine with SQL
properly communicating on the public network until I
installed the FTP service. For some re ...
Mon, 8 Nov 2004 07:31:24 -0800
|
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
We are randomly experiencing this error when connecting to SQL W2K from web
servers using ODBC. I see numerous links on the web but real answers.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
...
Fri, 5 Nov 2004 20:25:33 -0600
|
Problem connecting to SQL server
Using a UDL ,on a WIn2K machine, I attempt to connect to SQL server
(Sql server 7) CLicking on the "test connection" button returns
connection failed with the error message :
Test connection failed because of an error in initializing provider.
Client unable to establish connection
If I create a DSN on this m ...
5 Nov 2004 14:04:38 -0800
|
Connecting to Mssql 2000 From Freebsd 5.x
Hi,
Is there anyone here who has successfully connected to Mssql 2000 from
Freebsd 5.x while using freetds 0.62.x and used the Ct-Library provided by
it in your C language based Program? If you have been able to do this,
please forward me your configure statement for freetds. If you were
successfull in ...
Fri, 5 Nov 2004 11:40:34 -0500
|
Detect servers on the network?
I'm wondering how to detect SQL servers on the network, the way Enterprise
Manager locates servers when it populates combo boxes or list boxes with
active servers on the network. Can anybody give me a hint? Some C# code
would be a plus. Thanks! ...
Fri, 5 Nov 2004 07:45:05 -0800
|
How to get source IP address of a database connection
Hi,
Is there a way to find out the source IP address of a database connection?
In trace there are only netbios names available, while I need to log the IP
addresses that connect to the database.
Thx,
Jacek Skaznik
...
Fri, 5 Nov 2004 10:50:39 +0100
|
Invalid authorization specification
MS OLE DB Provider for SQL Server Error: Invalid authorization specification
This is a basic 3-tier system, front end, data broker, database. The front
end software is written in VB 6. There are many front end users. This
error is coming up on one computer only. No users can access the database
through ...
Thu, 4 Nov 2004 08:43:09 -0800
|