|
what's the problem?
the error string is as follow:
"The text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator."
...
Mon, 13 Sep 2004 17:40:05 +0800
|
Win2K3 Client / Win2K3 & 2K SQL Server DBNETLIB Problem!
Hi all,
I am having a major problem with a simple application that queries a
database.
Firstly we have SQL2000 SP3a running on a Windows 2003 Server with all the
latest patches and updates. Windows 2003 is running the shipped MDAC 2.8 and ...
Mon, 13 Sep 2004 16:47:59 +0930
|
Data Link properties don't show any istance
Hi
Data Link Properties, open by test.udl file, when open don't show any
istance of MSDE sp3 installed.
By Visual Studio.NET 2003 Server Manager I can see the server and database.
If I insert manually name istance and try test connect it return me this
message:
Test connection failed because of an error i ...
Sun, 12 Sep 2004 21:48:08 GMT
|
ADODB connection mode adModeShareExclusive still allows other connections. I need the SQL database to myself!
Hello,
I'm opening an ADODB connection to an SQL database in VB6 using the
adModeShareExclusive mode for the connection object. The connection opens
successfully, but I'm still able to modify records in the database using
Enterprise Manager. Why is this? I want to open the SQL database and lock
out al ...
Sat, 11 Sep 2004 20:17:36 -0600
|
Benchmark of ODBC vs Oracle Net8 for Connectivity
Do any one have any unbiased benchmarks of the performance differences of
connecting an Oracle 9i DB to MS SQL Server 2000 via ODBC vs NET8?
References for any pros and cons.
Any guidance would be appreciated!!!! ...
Fri, 10 Sep 2004 15:05:02 -0700
|
LinkedServer Failure to connect Oracle 8.1.7
The Error Occured while connecting to oracle from
SQLServer 2000 in WINDOWS 2003, I have tried with MDAC
2.8, MDAC 2.7 and restarted the Server, nothing is
working. We are always getting the Same Error
Error 7399: OLE DB Provider 'MSDAORA' Reported an error.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
Fri, 10 Sep 2004 14:56:44 -0700
|
Registration from Enterprise Manager
Here is my problem:
I have a sqlserver SQLA which I have registered in EM with a sqlserver
authentication with a uid and password and that connection works fine. The
problem is that when I look at the security log of SQLA, i see continuous
failure audits but with a uid that I am logging in to my local machine w ...
Fri, 10 Sep 2004 15:44:06 GMT
|
Intermittent connection loss?
Hi all,
I have a .Net windows application that uses the micrsoft application block
to make calls to the database. I am doing a few thousand records that must
be inserted. I have a problem where on occasion I get an exception that
says "SQL Server does not exist or access denied." This seems to be an
intermi ...
Fri, 10 Sep 2004 10:57:10 -0400
|
Linked SQL 2000 server and views
I only have basic SQL knowledge and am trying to modify some previously
created views, the problem I have is the views were originally only accessing
tables on the local SQL 2000 server which was fine, but now one of the
databases has been moved to another server and I'm trying to modify the views
to collec ...
Fri, 10 Sep 2004 03:35:01 -0700
|
Error:7399 strange behaviour??
Hi people,
Does Anyone Encounter this problem or know how to fix
this please help!
I have linked server ORA 8.05 from my SQL2000. Everything is working fine
for a couple of mounths. Last week I start to receive message
after executing
insert into MyServer..MySCHEMA.MyTABLE
values(' value ')
Se ...
Fri, 10 Sep 2004 11:01:02 +0200
|
stale connection handle in ODBC
A quick question from an SQL novice trying to debug problems of connection
link failures between client and server. Here is the scenario:
- application opens connection from client to SQL server
- lots of intermittent activity between client and server (connection to
server stays alive throughout)
- s ...
Thu, 9 Sep 2004 16:43:01 -0700
|
New to SQL
Hi
I am setting for the first time SQL to access a database. I can get the
Enterprise Manager and the Network Utility to see the databases (on 2
computers) but when I go to the program to access the databases, I get a
Connection error.
Strangely, I set up the exact replica on the server and it can only ...
Fri, 10 Sep 2004 07:36:35 +1000
|
SQL connection Failure
I had PHP installed on as CGI on a Window 2000 Server and connected to an
MSSQL 2000 on another server. Both server were upgraded to Windows Server
2003 and problems developed that I could no longer run PHP any more.
What I did next was to uninstall PHP and re-installed it as ISAPI, and make
necessary c ...
Thu, 9 Sep 2004 13:09:03 -0700
|
Connection problems to named SQL 2k instance on Win2k3 cluster
Hi there,
I have a rather strange problem I'm trying to resolve:
I have a 2-node Win2k3 cluster running 2 named instances of SQL 2k in
active/active. All updates are applied to the OS and SQL server to
the most current releases.
Using Enterprise manager or ODBC, I have been able to connect to both
inst ...
9 Sep 2004 12:26:16 -0700
|
freedom software
I run Freedom software on my clients machines. When the
computer name changes
we have to completely reinstall the Freedon software or it
will not connect
to the MSSQL server. Someone told us that there is a
command in MSSql that
will allow us to change the computer name of the client
Any ideas?
...
Thu, 9 Sep 2004 09:47:17 -0700
|