|
|
|
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 |
Is ODBC right for me? Posted by DIRN at 10/31/2006 1:56:01 PM I am a forum newbie - appreciate your patience.
We are embarking on a new adventure to scale up an Access DB up to SQL
Server. We are not going to use the upsizing wizardry, but have chosen to
build native SQL tables instead.
The question is which route to go with the Front-End?
- Access ...more >>
SQLConnect blocks COM calls? Posted by Aaron Lawrence at 10/31/2006 12:00:00 AM Hello,
We have a multithreaded service (testing under XP SP2).
One of it's threads connects to an ODBC database - currently MSDE 1.0
(SQL Server 7).
While the SQLConnect call is operating, all COM calls within the
service, or from clients to the service, seem to be blocked.
This becomes ...more >>
Is a newer version of odbcspy available for current systems (eg; MDAC 2.8) Posted by Paulaner at 10/27/2006 4:01:35 PM I didn't find it in MDAC 2.8 SDK....more >>
Runtime error 3155 inserting to linked SQL tables from Access Posted by Alistair Taylor at 10/25/2006 6:27:02 AM I have suddenly started getting a runtime error 3155 when attempting to
insert new rows into a linked SQL (2000 on Windows 2003 server) database
table from Access (2002 under XP).
A new bit of code in the Access database attempts to insert a database login
record into table Logins, as follows...more >>
MS SQL ODBC Driver and Parameter Passing Posted by Goofy at 10/24/2006 2:38:25 PM Can anyone tell me if this supports Parameter passing I am using
2000.85.1117.00
...more >>
fastest way to recieve results? Posted by Leon McCalla at 10/22/2006 7:17:55 PM Hi,
I want to call a stored proc. on SQL 2000 from VC 6.0. This stored proc
can return 1-4 rows. After extensive reading and overwhelming myself with
help files from MSDN 6.0, MDAC 2.8, SQL 2000 and hte platform SDK, I want
to optimize my software performance. I want to do only one round tr...more >>
SP with no results throws ODBC exception in CRecordset Posted by Mike C# at 10/20/2006 12:29:11 PM Hi all,
I'm writing a little app that uses ODBC to call a SQL 2K stored procedure
several times in a loop, with a different parameter each time. The SP can
return no results in some instances. When no results are returned, the
CRecordset throws an exception. I've tracked the problem down...more >>
SQL Blocking Posted by ngan at 10/19/2006 1:21:02 PM I have data in SQL 2000 tables with Access XP front end linking to the tables
via a DSN-less connection.
Once in awhile we get sql blocking and I don't know why or how to solve it.
Today, I get a call from someone in the road dept that said that when they
go to update the driver data, it w...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
RunSQL method with tables linked to SQL2005 Express Posted by Jason at 10/19/2006 8:21:02 AM In ACCESS 2003 :
1. The DoCmd.RunSQL method works fine with tables linked (ODBC) to SQL 2000
on a first machine. On this machine, SQL2005 is not installed.
2. On a second machine, with SQL2000 and SQL2005Express installed,
DoCmd.RunSQL fails with tables linked to SQL2000 or SQL2005Express. In ...more >>
MSDTC? Posted by Jim at 10/16/2006 2:14:02 PM I keep getting this message on my application server.
The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The
local computer may not have the necessary registry information or message DLL
files to display messages from a remote computer. The following information
is part ...more >>
location of ODBC drivers for SQL 2k5 x64 in Win Server 2003 x64 ST Posted by Olgun at 10/12/2006 9:01:02 AM Hi,
I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
standard 64bit edition however there is a problem.
I need to locate the ODBC driver in Win Ser.
I know where they are in the 32bit edition but not in the 64bit version.
can anyone help?
Thanks
Olgun.Ucurel@c...more >>
mdac and odbc Posted by Jason Huang at 10/12/2006 12:00:00 AM Hi,
I have installed a mdac 2.6 on my client's Windows XP PC, but the ODBC seems
to be the same.
What do I need to do so the ODBC will be changed to the ODBC comes up with
the MDAC?
Thanks for help.
Jason
...more >>
SQL Server 2005 ODBC - DateTime Problem Posted by Vlad Gerchikov at 10/11/2006 9:56:40 AM Hi there,
I hope somebody here can help me, as I have run out of ideas.
I am trying to export some data to SQL Server 2005 via ODBC. The data
consists, for testing purposes, of a single row and a single column. The
value itself is time, i.e. 08:20:54 (hh:mm:ss). I have created a test table
i...more >>
odbc driver? Posted by Sean at 10/9/2006 8:27:19 AM Hello,
It has been over 5 years since I've had to use MS SQL.
I'm finding out the interface has changed and now I can't figure out how
to install the ODBC driver to a Server 2003 R2 box.
It's not where it used to be.
I've searched MS knowledge base but can't find anything.
Can someone ...more >>
Incorrect parameters being received by SQL Server Stored Procedure ... Posted by Vipul Pathak at 10/7/2006 7:50:46 PM Hi Everybuddy,
I have a strange problem with VB6/SQL Server 2K. I am calling a stored
procedure from VB using ADODB.Command object. When I check the incomming
parameters into the stored procedure, that values in named parameters are
inter-changed (e.g. : Calling ABC(X=3, Y=7, Z=12) will result...more >>
HELP!!! -- SQL Server 2005 from 2000 Posted by segis bata at 10/6/2006 11:58:26 AM Hello everyone,
I'm writing you because I have this situation: I need to register a (remote)
SQL Server 2005 and currently we have SQL 2000. I can't do it using
Enterprise Manager.
Is there a way to do it *WITHOUT* upgrading to SQL 2005?!?
Please let me know if it's possible with SQL200...more >>
SQL Profiler and Access bound forms Posted by RLoski at 10/6/2006 9:22:02 AM We have noticed for a long time queries originating from Access 97 that had
very long durations when traced using SQL Server profiler (2000) . Queries
that would complete in less than a four seconds in Query Analyzer showed
durations of twenty minutes and in one case two and a half hours. In...more >>
locking on accessing tables on SQLServer through ODBC Posted by P. Scaram at 10/4/2006 6:41:02 AM Dear Sir,
Thank you in advance for your help.
I am using SQL Server and a view I have created between two fairly large
tables. I have put indexes but because the records between the two main
tables are many to many with the query analyser it uses hashing to find the
entries.
I am using th...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |