|
SQL Server Driver Not Marked
I am trying to connect to a SQL Server after installing MDAC 2.8 however it
faults with a SQL Server error message 126. It appears that the MDAC does
not fully install, however it says completed successfully. I have done this
from 5 other machines successfully.
When viewing the ODBC drivers installed on t ...
Wed, 13 Oct 2004 08:39:03 -0700
|
ADO V's ODBC Data types and formatting.
Hi,
I am replacing a VB5 application that handles database communication
directly through ODBC API calls with a VB5 application that uses ADO
to handle database communication.
The back end database is SQL Server 7.
I am having some issues with mapping the data types returned by ODBC
to the data types retu ...
13 Oct 2004 06:07:09 -0700
|
use a variable for -table selection- in my ASP SQL statement
Hi All,
I have a small issue that I can't seem to figure out. I have a SQL
statement that is dependant on the results of a drop down to chose
which table to select from. Unfortunately it does not seem to work.
Could anyone point me in the right direction? Unfortunately the
datebase cannot be changed.
I gues ...
12 Oct 2004 06:18:22 -0700
|
odbc error
Hi,
when I right click and design table my table,I am gettin this error
odbc error:[Microsoft][odbc sql server driver ] communication link failure
How can I solve this error?
thanks
...
Tue, 12 Oct 2004 03:47:02 -0700
|
How to set isolation level in a Windows ODBC DSN
I wnat to link an MS Access 2000 database to an SQL Server 7 database.
The MS Access client is running on Windows 2000. Due to the nature of
this connection and the existence of other connections also connecting
to the same SQL Server database, I want this DSN to connect at
isolation level 0 (read uncommitted). ...
11 Oct 2004 11:00:33 -0700
|
ODBC Administrator app fails only on SQL Server
Make sure this isn't a rights-issue
You could reinstall mdac 2.8 or sql server client.
>-----Original Message-----
>Hello,
>
>I am on an XP SP1 system and when I use the ODBC
Administrator application
>to establish a new SQL Server DSN the process fails.
>
>After launching the ODBC Administrator I pus ...
Mon, 11 Oct 2004 02:13:45 -0700
|
MsAccess 2000 and 64bit SQL Server
Hi,
Does anyone know if there are any issues with Access 2000
connecting to the 64bit version of SQL Server as we are
thinking about upgrading.
Ta
Paul ...
Sun, 10 Oct 2004 09:24:12 -0700
|
SQL_SUCCESS_WITH_INFO
I get the following from a SQL Trace log on our UPS system communicatiiong
with a SQL2K DB:
==============================================
ShipUps 3a-e2 ENTER SQLExecDirect
HSTMT 01D3DEA0
UCHAR * 0x01E9CB90 [ -3] "INSERT INTO tblShipLog
(TotalFreight, PackageTrac ...
Fri, 8 Oct 2004 10:50:14 -0700
|
ODBC Administrator app fails only on SQL Server
Hello,
I am on an XP SP1 system and when I use the ODBC Administrator application
to establish a new SQL Server DSN the process fails.
After launching the ODBC Administrator I push the "Add" button and select
"SQL Server" from the list of available drivers. When I then push the
"Finish" button I am immedi ...
Fri, 8 Oct 2004 09:33:57 -0700
|
Missing SQL instance in ODBC DSN Setup
Hello, I am having difficulty setting up an ODBC
connector to my SQL2000 server from a remote site.
I have a central site where I'm running SQL2000 with one
instance called Production. When I configure a client at
the central site to access the Production SQL instances
the server and instance name appea ...
Thu, 7 Oct 2004 13:44:46 -0700
|
String data, right truncation error
Hello,
I'm experiencing the above error on a Nullable Varchar(50) column at the
time I call SQLExcecute on a SQLPrepare'd statement.
The error only occur ...
Thu, 07 Oct 2004 18:55:38 GMT
|
Refreshing OLAP Cube
Can anyone help, I am getting the following message when refreshing my Cube
'Client safety Options do not allow passthrough statements to be issued to
the data source' I think it is to do with the Safety Options changed when
SP3 has been appiled, but how do I get around this? ...
Thu, 7 Oct 2004 13:23:06 -0700
|
SQL Connection stops working all of a sudden (2)
One more note:
Active X Objects cannot be created either. It is almost like a subsystem is
not running correctly to allow communication with odbc, activeX, etc. So it
may be a windows issue and not SQL Server.
Best regards,
--
Michael C. Gates
www.gateshosting.com
Hosting Your Success
...
Thu, 7 Oct 2004 11:01:28 -0400
|
SQL Connection stops working all of a sudden
Good Day,
Windows Server 2003 accessing SQL 2000 on another server in the network:
SQL Server is running great! Windows 2003 is running great! However, every
day, sometimes twice a day, the connection from ASP and ODBC to the SQL
server stops working. The error is:
[Microsoft][ODBC Driver Manager] Data s ...
Thu, 7 Oct 2004 10:59:30 -0400
|
name pipe VS tcpip
I found that I can only use name pipe to connect to the sql server.
When I use tcpip, it fails to connect.
I am sure I have enabled the TCP/IP protocol in SQL server
What causes it?
sql is using port no.1433 and I have try using dynamically determine port
and force it to 1433 in ODBC setting.
thank you ve ...
Wed, 6 Oct 2004 09:49:30 +0800
|