|
|
|
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 Data throughput Posted by Jim Abel at 4/28/2004 5:19:40 PM I am trying to understand what things affect the
throughput of data when queries are executed to SQL
Server. I'm trying to determine if there are
settings,pramiters or times that can improve the speed of
a recordset being returned to the application.
What I have noticed in our environmen...more >>
MDAC 2.8 Deployment Posted by Sam at 4/28/2004 11:20:12 AM We are thinking about deploying MDAC2.8 to resolve some
named instance and DNS alias connection problem. Input on
MDAC2.8 dependency and potential impact to expect would be
greatly appreciated. Thank You!...more >>
Cannot Create System DSN Posted by David Palmer at 4/28/2004 9:02:40 AM Hi,
I'm having some difficulty creating a system DSN on a
win2K machine for connecting to a SQL 2000 server. I'm not
sure if this may be a better question for the windows
group, but... Anyway, when I go through the odbc setup in
windows, the DSN does not appear in the list of system
ds...more >>
Linked Servers: Invalid schema Posted by Richard Greathead at 4/28/2004 6:06:11 AM I am having a problem referencing tables via a linked
server in SQL queries using the
syntax as exampled in the following simple illustration:
SELECT * FROM LinkedServerName.Catalog.Schema.TableName
The connection string I am using seems to be correct
because I can see the table names w...more >>
Write Conflict message while using bound Forms in Access Front End Posted by Scott Meyer at 4/27/2004 8:56:03 AM I am attempting to upsize my systems to SQL Server 2000. I have migrated a few tables over and made sure that they have Primary Keys setup. I have linked them into an Access 2002 mdb file and can open, add, delete, modify while in the datasheet view but when I create a bound form to the data, even...more >>
JOIN question Posted by jamesmgiordano NO[at]SPAM yahoo.com at 4/27/2004 7:35:10 AM Hi, I have a question concerning joining three tables together, and
getting the information to spit out correctly. Say I have three
tables:
products
ID Code Name
1 9000 Test Product
categories
ID Name
1 Test Category
2 Another Test
3...more >>
odbc advantages? Posted by Stefan Richter at 4/27/2004 3:06:32 AM What are the advantages / disadvantages of using odbc to connecting to a
(mysql) database???
Stefan
...more >>
ODBC Error Code = S1C00 (Driver not capable) Posted by Bill Youngman at 4/26/2004 4:54:23 PM I am attempting to write data to a database from a web form. I am using =
stored procedures to write the data to different tables in the db and =
using the transaction and rollback functionality to ensure that the sp =
have executed properly before commiting the data to the db.
All of my sp se...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Adding C++ var into db Posted by Jacky Luk at 4/25/2004 8:25:07 PM What is the syntax of adding C++ variables into SQL Server/mySQL?
Could anyone raise an example?
I've tried
insert into aTable (field1, field2) values (variable1, variable2)
But mySQL throws error messages at me saying varible1 is not in the field
list. Haven't tried it yet for SQL Server..
Th...more >>
Setting OSBC link Posted by Zafi at 4/25/2004 2:30:06 PM When you try to set up ODBC link at a workstation under
SQL Server, do you set up ODBC Engine Interface or ODBC
Client Interface or both?
Please advise.
Zafi...more >>
Access Pass through Query Executes Multiple Times Posted by Lance at 4/25/2004 6:06:02 AM Hi
I am using MSACCESS 2002 with SQL Server 2000. I have an unbound form when it opens I assign a pass through query to the rowsource of a combo box. The pass through query calls a stored procedure. On my form unload event I set the rowsource to empty. When I load the form I am only assigning...more >>
problem With 2000 client Posted by Zeljko Matic at 4/24/2004 5:03:47 PM One Winn 2000 workstatiom has problem with ACCESS 2003 ODBC conection to SQL
server on WIN 2003 server. Other clients are all WINXP. This cient is on the
different domain too. Some reports works, and some have error, ask for
password again but not accept it even if it is supplied again. Applicat...more >>
problem with WIN2000 client Posted by Zeljko Matic at 4/24/2004 4:59:19 PM One Winn 2000 workstatiom has problem with ACCESS 2003 ODBC conection to SQL
server on WIN 2003 server. Other clients are all WINXP. This cient is on the
different domain too. Some reports works, and some have error, ask for
password again but not accept it even if it is supplied again. Applicat...more >>
assigning user to a database programmatically Posted by Asif at 4/24/2004 1:00:44 PM Environment : vc.net , SQL Server
Hi All,
I have programmatically created an SQL Server database
by executing the script file for it. I have logged in as administrator
for creating the above database in my vc.net code using SQL APIs.
Now i need to assign a new user and pasword to this data...more >>
Hex no Posted by Jacky Luk at 4/24/2004 12:22:10 PM Can you store hex no in SQL Server or mySQL?
Thanks
Jack
...more >>
BLOB as primary key Posted by Jacky Luk at 4/24/2004 10:23:01 AM In SQL Server, Can you set a BLOB field as the primary key? Also in mySQL?
Thanks
Jack
...more >>
Error message Posted by Ashraf at 4/22/2004 1:06:36 PM I have installed the the MSSQL Server 2000 along with its
service pack 2. However, I am getting an error message
(pop window) that says:
isqlw.exe - Ordinal Not Found
"The ordinal 29 could not be located in the dynamic link
library odbcbcp.dll"
Please help me resolve this issue.
Thank...more >>
SQL-Server does not exist or access denied Posted by Ch. Marx at 4/22/2004 10:28:06 AM Hi all,
I have a VB6-application that opens a ADO connection to a sql server
database at startup. Everything is ok, as long as there is not much database
work to do. As soon as I start a calculation that works a lot in the
database (reads and writes in appr. 10 tables), it takes about 1 minut...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |