all groups > sql server odbc > october 2004 > threads for october 1 - 7, 2004
Filter by week: 1 2 3 4 5
SQL Connection stops working all of a sudden
Posted by Michael C. Gates at 10/7/2004 10:59:30 AM
Good Day,
Windows Server 2003 accessing SQL 2000 on another server in the network:
SQL Server is running great! Windows 2003 is running great! However, every
day, sometimes twice a day, the connection from ASP and ODBC to the SQL
server stops working. The error is:
[Microsoft][ODBC Driver... more >>
name pipe VS tcpip
Posted by ! at 10/6/2004 9:49:30 AM
I found that I can only use name pipe to connect to the sql server.
When I use tcpip, it fails to connect.
I am sure I have enabled the TCP/IP protocol in SQL server
What causes it?
sql is using port no.1433 and I have try using dynamically determine port
and force it to 1433 in ODBC setting.... more >>
binding input parameters leads to SQL_ERROR
Posted by ScottD at 10/4/2004 1:35:04 PM
I am trying to read the results from a query like
select a, b
from mytbl
where col0 = ?
The first time I run SQLExecute, everything works fine, but when I call
SQLExecute a second time with a modified input parameter, it returns
SQL_ERROR. Below is the code I'm running with the error ch... more >>
SQL server access problem
Posted by Pupo at 10/4/2004 9:46:51 AM
Hi
i have a windows xp pro, i using odbc to connect to sql 2000 server. i have
two connection that work fine. Now when i try to connect i receive a popup
message of error.
If i try to configure or recreate my odbc i receive the followin errors:
impossible make connection
sqlstate: '01000'
sql... more >>
logfile
Posted by Abaz at 10/4/2004 8:10:10 AM
Hi,
Is there any file that shows every transaction log during
work on SQL 2000
regards,... more >>
SQLParamData need the second param instead the first one
Posted by Infite at 10/3/2004 2:22:47 AM
Hello,
I'm tring to insert a large data to image fields.
It is an Update query of 2 image fields in the same table.
The problem occurs when the data length of the second
field is more than 400K.
I do:
SQLPrepare
SQLBindParameter
(handle,1,SQL_PARAM_INPUT,SQL_C_BINARY,SQL_LONGVARBINARY,... more >>
ODBC error
Posted by Pupo at 10/1/2004 11:39:41 AM
Hi
i have win xp pro Sp1 in SBS domain.
When i try to connect with sql server using ODBC i receive the following
error SQLState 08001 - SQLState 01000 with sql error 17 and i can't to
connect with DB. Until last week my odbc connection work ok, and now if i
try to modify or make new connectio r... more >>
DB is ReadOnly?
Posted by kpg at 10/1/2004 10:13:10 AM
Hi all,
I am using DAO 3.6 to connect to a SQL Server db on a remote machine.
I can open and close the connection, read records, run stored procedures
but when I try to add a record I get "object or database is read only"
If I connect to the database using ADO I can add records.
Here is m... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Cube Processing Error
Posted by Justin at 10/1/2004 9:51:27 AM
Hello,
I'm getting an error while processing some cubes. "Cannot lock object
'lazy processing token'. Error: Connection to the server is lost." This
only occurs while processing certain cubes on the 64-bit version of AS
and occurs just after the 'Writing Aggregations and indexes' portion of... more >>
|