all groups > sql server odbc > july 2004 > threads for july 1 - 7, 2004
Filter by week: 1 2 3 4 5
SQL Profiler Download
Posted by Venkat at 7/7/2004 3:57:56 PM
Hi All,
Can someone point me to a site where i can download SQL Profiler for SQL
Server 2000 server.
Thanks In Advance,
Venkat
... more >>
IIS4 lockdown install conflicts with MS SQL 7.0
Posted by Grasshopper at 7/7/2004 12:42:39 PM
I need to install IIS4 lockdown for FTP services.
However, when i installed it, it caused problems with my
MS SQL 7.0 installation. I had to re-installed the old
odbc from the sql7 cd and rerun sql service pack 4 in
order to get the SQL7 to function again. Can you PLEASE
help me on how ... more >>
Problem with simplified chinese
Posted by David A. Caballero J. at 7/7/2004 10:53:26 AM
I have a 3 layer system, SQL Server 2000 database, COM+ dll's (VC++ 6) and
ASP frontend, this system has been in production for quite some time using
english, spanish and portuguese versions. Now I've been asked to test the
system to function with Simplified chinese. The development of the system... more >>
Runtime error 3146
Posted by sam at 7/7/2004 1:23:52 AM
hello!
I am currently using SQL 2000 and Access 97. My desktop
used to be Win NT. Recently i migrate to Win XP and I
got this error while SELECTING, UPDATING and INSERTING
record.
Full error is Runtime '3146'.ODBC call failed.
The documentation for this error is quite limited, anyone
c... more >>
Creating a linked server to DB2 from SQl server 2000 64bit
Posted by Geetha Dabbara at 7/6/2004 2:56:14 PM
Hi,
I am trying to create a linked server to DB2 using IBM
64 bit OLEDB provider, as Microsoft doesn't have a DB2
OLEDB driver for 64bit.
When I test the connection to DB2 using the driver, it
works, but when I try to query DB2 using a OPENQUERY it
gives me this message.
"Error 7399:... more >>
Access 2K + SQL Server: Data Retrieval Q
Posted by Jeffery Hawkins at 7/6/2004 6:25:39 AM
First, if I'm posting this in the wrong newsgroup, please let me know
and I'll re-post elsewhere.
Trying to get SQL Server 2K data into an Access 2K front-end application
(we're upsizing our back-end DB's to SQL Server, want to keep mdb
front-ends). To limit the returned recordsets for both f... more >>
field + nullfield = null
Posted by Matthew at 7/2/2004 5:40:48 PM
I have two fields in different tabels. I have a calcualated field in a view
that goes something like this:
mato.pmainT.product + mato.woodtype.short
It seemed to work OK, but I found if mato.woodtype.short is null, it won't
display mato.pmainT.product either!
I would like it to display mato.pm... more >>
Cannot update record through vb or Enterprise manager
Posted by John at 7/2/2004 3:37:46 AM
When trying to update a specific row in a table an error
occurs.
[Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER]
SQLDumExceptionhandler. Process 51 generated fatal
exception c0000005 ACCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
What could be the reason for this? The... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Suppress ODBC Dialog
Posted by Stefan Oedenkoven at 7/1/2004 11:10:39 PM
Hi ng,
is it possible to suppress the ODBC-Dialog, when i test the connection to my
linked tables an the connection is not alive?
(the dialog, which is asking for username, password, servername, etc....)
thanks,
Stefan
... more >>
ADO on MDAC 2.8
Posted by Melopezcaste at 7/1/2004 11:07:01 AM
I am running an application that runs fine on MDAC 2.6 but when I run it on MDAC 2.8 have the error:
Error on the DLL
How can I rollback MDAC 2.8 and what will be the consequences on the Windows XP system?
Application uses ADO.Open method and crashed here. Isn't MDAC 2.8 backward compatible... more >>
ODBC SQL Server Error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectioOpen (Connect()).
Posted by sqlak sqlak at 7/1/2004 4:36:49 AM
Hi,
I'm getting following error while creating a DSN from remote stations
PC. I could create DSN from the PCs available in the LAN.
Connection Failed:
SQL State: 01000
SQL Serve Error: 011001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectioOpen
(Connect()). Connection faile... more >>
|