|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 Net Library with ODBC SQL driver... Posted by Sam Anderson at 7/31/2003 12:12:05 PM I'm looking to find out how to set/change the default
Network Library (TCP/IP, Named Pipes, etc.) for the
Microsoft ODBC SQL Server Driver (Win2k, Win9x) - for any
drivers installed with MDAC 2.5 or higher. I realize that
MDAC 2.6 RTM and higher setup this driver to default to
TCP/IP, but...more >>
Transactions in ODBC Posted by Mikael Lindblom at 7/30/2003 11:49:34 PM I have an app running using the old MFC CDatabase classes
to work against a SQL2000 database.
The app makes use of a lot of stored procedures, which I
somtimes executes by using the ExecuteSQL method of the
CDatabase class and somtimes together with a CRecordset
derivate. I use the {CALL...more >>
odbc SPEC Posted by Duncan Winn at 7/30/2003 9:23:45 AM Does anyone know where the spec for writing ODBC drivers is? I can't seem to
fine the header files or any documentation on the web anywhere?
Thanks,
...more >>
Linked Exchange Server Posted by Luke at 7/29/2003 11:33:58 PM Hi,
I'm trying to set up a linked exchange server into sql
2000. Ive used the following sample code to set it up:
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
as per the help files. However...more >>
Problem with Yes/No data types - Access 2000 Linked ODBC tables in SQL Server Posted by Ragnar Midtskogen at 7/29/2003 12:30:25 PM Hello,
I have an Access 2000 application wich uses SQL Server linked ODBC tables
running on Windows 2000 Pro, with the SQL Server running on Widows 2000
Server..
It is a multi-user system with up to 5 users, connected to the server
machine through a Samba network.
The application has worke...more >>
Oracle ODBC driver BIGINT conversion Posted by Peter at 7/28/2003 6:13:24 PM Hi,
I want to bing a placeholder for stored procedure using following:
SQLBindParameter(m_hstmt, ++m_nParamCount, SQL_PARAM_INPUT,
SQL_INTEGER,
SQL_DECIMAL,
0, 0,(SQLPOINTER)piValue, 0, NULL));
but it works only for signed long .
How can I use SQLBindParameter for a BIGINT ...more >>
Server problem Posted by Dawn at 7/27/2003 11:51:57 PM I received the following message on my computer. It
appeared on a website, the computer crashed, then I saw
it again. Can someone tell me what it means?
Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
Thank You
Dawn...more >>
Bizarre Error Posted by James Griffith at 7/25/2003 7:19:55 AM Hi there. We are experiencing a serious error on one of
our machines connecting via an MS Access 2000 ADP
database to SQL Server. The problem is that when I open
the Access project (as any user) the database shows as
disconnected. When the connection window is opened
clicking on 'Test' rev...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server old ODBC driver Posted by Dragon29 at 7/21/2003 12:31:16 AM Hi everybody, I am looking for an old version of the ODBC
driver (like 2.65) that would work with windows XP
Professional. The 2.65 installer crashes when running it
under XP.
Thanks for your help...more >>
How to disable ODBC-error popups? Posted by ouTi at 7/18/2003 10:36:15 AM
Hi, currently i'm using a msql 2000 for db-purposes of an ivr
application.
i want to achieve that when an error or timeout on connect to db occurs
the ivr-application sends out an error-email. the problem is odbc
creates a popup with the error message. only after pressing ok odbc
forwards the...more >>
xpsql.cpp: Error 1314 from CreateProcessAsUser on line 636 Posted by mirek NO[at]SPAM eaglesystems.com at 7/17/2003 4:54:02 PM [Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp: Error 1314
from CreateProcessAsUser on line 636...more >>
ODBC Authentication problems. Posted by Rajan Murthy at 7/17/2003 3:47:31 PM Hello All,
Win XP and I have MDAC 2.7 in that.
The SQL Server driver I use is 2000.81.9030.04.
In Microsoft SQL Server DSN Configuration, it shows SQL Authentication . But
the user id is belongs to NT. So, I changed to user to a SQL User and
connected to the database successfully.
When I...more >>
Converting an SQL server table structure to an MS-Access table Posted by Andrew Chalk at 7/14/2003 1:23:51 PM I want to take an existing MS-SQL Server table in an SQL Server database and
create an MS-Access table with the same structure. Is there a standard
utility to do this?
Many thanks.
...more >>
SQL Server 7 and ODBC on NT 4 Server! Posted by Dennis Sigala at 7/11/2003 9:39:58 PM Our company is working with local Police Dept to replace
their NT4 Workstations with Workstations running Windows
XP Pro.
They are running NT 4 Server, and SQL Server7.
Software is for Police Dept, VisionAir911 custom program
for Law inforcement.
After installing the VisionAir software and ...more >>
Copying a record from one table to another Posted by Andrew Chalk at 7/11/2003 5:06:44 PM What is the easiest way to copy a record from one table to another (with
identical structure)?
Regards
...more >>
Enumerate SQL Servers Posted by Frank Cheng at 7/11/2003 12:59:25 PM Hi all,
I would like to get a list of SQL servers installed in the network,
just like the the combo box you see in MS SQL Server Manager.
I tried using NetServerEnum, but it only returns the name of the computer
that has SQL Server installed, not the name of the SQL Server itself.
There is on...more >>
After 30-40 minutes, conexion is broken Posted by Victor at 7/9/2003 11:00:25 PM It is an access97 application with tables linked to SQLServer2000 (installed
on win2000 domain controller), throught an ODBC connexion.
When the application is on win98 and win2000 plataforms there are not
problem, but when the application is on winXP profesional, about 30 minutes
after the net ...more >>
Fastest language to access SQl database?? Posted by zenlikerage NO[at]SPAM yahoo.ie at 7/9/2003 5:24:56 AM hi folks.
just wondering what do people consider the best [in terms of execution speed]
language?
at the minute im using VBScript [not the best i'd bet].
i have used java in the past but it's been a while so i can remember how it fared.
what about..
perl?
c++?
or any other that you'd c...more >>
transactions Posted by Mariusz_P³askowicki at 7/8/2003 12:57:03 PM How can i set timeout value for transactions in sql server 2000 from c++
application? Is this possible? There is SQL_ATTR_CONNECTION_TIMEOUT in
SQLSetConnectAttr but it sets the timeout for all operations. Is there any
method to change only timeouts for transactions?
--
Mariusz Plaskowicki
...more >>
ODBC Drivers error '80040e21' Posted by Ana at 7/6/2003 2:51:47 AM Hi,
I am trying to submit a listing to an online
marketplace/auction site (which uses html for item
description etc) and right at the end this error message
comes on to the screen:
Microsoft OLE DB Provider for ODBC Drivers
error '80040e21'[Microsoft][ODBC SQL Server Driver]String
data...more >>
SQL Server and Active Directory Posted by Simone at 7/5/2003 4:31:09 AM Hello,
Since Active Directory has a SQL server database can these
tables be queried by another SQL Server instance and what
kind of permissions is required for this type of job....more >>
SQLEndTran Posted by Mariusz_P³askowicki at 7/3/2003 11:47:39 AM Hello
I have trouble with transactions. I need to use transactions in manual
commit mode, and additionally i have multiple stmt on one connection handle.
Now, SQLEndTran accepts only connection or enviroment handles. So if i have
SQLEndTran in code it will COMMIT/ROLLBACK ALL my statements. Thi...more >>
SQL2K Trigger problem Posted by Joe Bertolini at 7/2/2003 3:36:17 PM I've got a problem with a trigger I've set on a table. This is the code for
the trigger:
CREATE TRIGGER Update_Allowance_Rule ON [dbo].[setting_allowance_rule]
FOR UPDATE
AS
UPDATE [dbo].[setting_allowance_condition_rule]
SET [dbo].[setting_allowance_condition_rule].rule_description =
del...more >>
SQLColumns .... Posted by Mariusz_P³askowicki at 7/2/2003 1:43:58 PM Hello
I need to get the columns names from the table. I'm using the SQLColumns,
then i bind some veriables to retrieve the data and then i fetch data. But
instead the data i got some numbers. I don't know what is wrong with this.
Here is part of the code (without the error check).
sql_retur...more >>
Timeout Expired Posted by Phil Grimpo at 7/2/2003 12:22:49 PM I programmed an ASP web app a while ago and all worked fine. All the sudden
one day I start getting the following error when trying to Insert, Update or
Delete:
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/admin/StoreManager/OrderDetail.asp, line 142
Th...more >>
Simplifiec Chinese Character Posted by ElaineB at 7/2/2003 4:03:15 AM
Hi,
I have setted in SQL server 2000 the column collation as
"Chinese_PRC_CI_AS" and the data type as "nvarchar".
When I try to update the value with ASP using the "update tblitem set
..." statement, I got the data stored in sql server like " & #24191;&
#1999;" which is not chinese simpl...more >>
SQL re-writes fields, not rows? Posted by Bill Walker at 7/1/2003 6:59:30 AM VB generated this statement when i wanted to update 2
fields of a SQL record:
Me.SqlUpdateCommand1.CommandText = "UPDATE Employees SET
LastName = @LastName, FirstName = @FirstName WHERE
(Employee" & _
"ID = @Original_EmployeeID) AND (FirstName =
@Original_FirstName) AND (LastName...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |