|
Time-out when querying large databases
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_002A_01C4F94C.03EDBFC0"
------=_NextPart_001_002A_01C4F94C.03EDBFC0
...
Thu, 13 Jan 2005 08:43:55 +0200
|
SQL Losing Data
We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and users
are complaining that unsaved data is being lost when they move to a new
record. This seems to be the case when there are multiple users. When there
is a sing ...
Wed, 12 Jan 2005 19:53:02 GMT
|
Performance problem
Hello,
I have a multiuser Access 2000 application that uses an SQL Server 2000 back
end, using ODBC linked tables. Some of the larger tables are pushing 100 K
records with 20 to 30 fields
At the client's facility the performance is good to very good, at my office
it is very poor. Some operations that ta ...
Wed, 12 Jan 2005 13:29:38 -0500
|
Ghost in the data source?
Hi All
This is a strange one, but hopefully you will know why.
Basically we use an ODBC connection for our program to connect to SQL
database - nothing more sinister as that.
However what seems to happen from time to time is that even though we
haven't touched the ODBC data source since it's conception ...
Tue, 11 Jan 2005 14:10:24 -0000
|
SQL server Login connection failed sqlstate 28000 sql server err 1
Just recently our company upgraded to Windows XP Pro SP2, running Mdac 2.8.
We have Access 2000 database, using sql 7 back ends. The applications run
fine until when we try to relink them, after making changes. They relink
fine to a DSN and then when I close the Access application, then reopen, I
get the ...
Mon, 10 Jan 2005 05:45:07 -0800
|
SQLNumResults() fails, when text parameter is binded as SQL_WLONGVARCHAR after calling SQLExecDirect
Hi,
I am trying to send large text to a stored procedure which takes parameter
as 'text' type as given below,
TestLargeText(largeText text, nValue1 int .. )
I am exeucting the above SP using ODBC apis as given below
- SQLBindParameter to bind the parameter with Data at execution time option
set
...
Mon, 10 Jan 2005 17:52:23 +0530
|
external link table
Does SQL server support external link database like DB2 or Oracle through
ODBC?
Any information is appreciated.
...
Sat, 8 Jan 2005 19:42:31 -0500
|
sql share lock issue
I have an issue with SQL 2000 Standard Edn (8.00.760 SP3) that I believe to
be "Bug #: 471578". It manifested after my SP3 install.
Manifest: I use a simple 3 table select "View" as a form recordsource in
read-only, no locks mode. SQL, however, places locks on all the records.
Then other forms cannot update ...
Fri, 7 Jan 2005 15:21:04 -0800
|
Iseries linked server problem data problem
We currently have a linked server setup between an Iseries running V5R2 and
an SQL server 2000 database. When trying to select data from a table on the
iseries one of the character fields is being converted to hex. Does anyone
know of a way around this or what might be causing this in the first place? ...
Thu, 6 Jan 2005 08:07:06 -0800
|
MSDE Installation Help
Hi
I am trying to instal MSDE 2000 on a Windows XP Pro SP2 machine. I type in
.....
"Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=" at the command prompt and the MSDE setup begins to take place. At
the nearly the end of the install, I get a pop-up dialog stating the t ...
Mon, 3 Jan 2005 19:19:02 -0800
|
MSDE via ODBC, code VC++ VS.NET 2003
Pal,
Anyone can give me clue how is to do MSDE connection via
ODBC.
My application is coded by VC++ .NET 2003
Thank you.
Rajo M
...
Mon, 3 Jan 2005 02:06:04 -0800
|
altering a column of a table
Hello,
I have an internet site, that supports ms-sql server 2000.
The hosting company for some reason have problems on there wizard of
creating columns on db,
and doesn't support the auto-increment.
How can I do alter to a column, with an sql command, to an auto-increment
one ?
Need sample code please.
...
Mon, 3 Jan 2005 10:46:34 +0200
|
Need sample code for asp + sql server
Hello,
I am developing for internet.
I need a good example for ASP page, that use sql-server with some update
commands + transactions (use insert/update command + beginTrans/EndTrans,
please.
Thanks :)
...
Sat, 1 Jan 2005 21:54:34 +0200
|
Need help finding root cause for crash.
Hi,
First, let me apologize because I've probably posted to the wrong NG.
HW & OS = NT4.0 sp6a HW: Dell Dimension PIII 600 256MB, gobs of HDD ...
Wed, 29 Dec 2004 15:49:59 -0500
|
localhost is not mapped to server name
Hi,
It is a long time that I have been using my box and have some .NET apps
running on it which use a connection string with Server=localhost and I have
not had any problem yet. Today I have updated my box Windows with recent
HotFixes (well I am not 100% sure it is the reason of this problem) and
after t ...
Wed, 29 Dec 2004 15:32:57 -0500
|