Timeout - why?
Tue, 22 Jan 2008 22:28:53 +0100
Hello,
I am using SQL-Server 2000 SP4 (on Windows 2003 SBS SP2 - not R2!).
I use MS Excel with ADO to connect to the SQL-Server. I get a timeout after
30 sec with this connection "Microsoft OLE DB Provider for SQL Server".
However, I do not get a timeout when using "SQL Server with ODBC". What
would be t ...
|
Binding to a DateTime variable
Mon, 21 Jan 2008 16:53:54 -0800
Hi, I'm trying to write some code to bind a C variable to DateTime in
SQL Server. I have tried using SQL_C_UBIGINT to SQL_DATETIME
but I get the runtime error "Optional feature not implemented". Also tried
SQL_C_CHAR hoping the driver would convert from a text string, but
got the same error. How do I do this ...
|
Primary Key Question
Mon, 21 Jan 2008 11:58:21 -0500
Can you define a primary key in a Select list...for example
Select
T.Fname Primary Key,
T.Lname
Into
Temp2Table
From
TempTable
...
|
Forever
Sun, 20 Jan 2008 12:49:53 -0800
...
|
Exporting Rich Text Field data
Thu, 17 Jan 2008 14:45:12 -0000
I have an SQL 2000 database (used by a CRM package), and the field that
contains what we call 'History' is a Rich Text Field.
It basically starts like this: {\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0
Tahoma;} [more follows here]. If I cut and paste this into a text document,
rename it to .rtf then it will d ...
|
What is the purpose of the OPENQUERY syntax?
Thu, 17 Jan 2008 14:04:04 +0100
Hello,
I am using linked servers over ODBC. Most queries fail, however, they work
when I use the OPENQUERY syntax. This appears to be a problem of at least
SQL server 2000 and 2005 express. Strange, but MS ACCESS databases work
perfectly with the ODBC-linked tables with "normal" sql-syntax.
I would like ...
|
Suppress ODBC message..?
Tue, 15 Jan 2008 20:01:15 GMT
Hi all,
I have an Access form with login to SQL-server.
If a user try to log in with wrong password he's promted with a messagebox.
================
If SetConnectString(Me.strUserId, Me.strPassword) = False
MsgBox "Wrong username. Use correct pwd"
End
Else
================
...but
he's also promted with a ...
|
|
|
Oracle Solaris connectivity from SQL Server 2000
Thu, 10 Jan 2008 22:54:01 -0800
Hi,
We have data in SQL Server 2000 database and we need to transfer this to
Oracle 9.2 database in SOLARIS environment. Oracle windows version alone can
connect to SQL Server and since we are using Oracle in Solaris, we cannot
establish a connection from here to SQL Server database.
Now, using Linked Se ...
|
error message in view to a linked server
Tue, 8 Jan 2008 12:17:36 +0100
Hello,
I have a firebird 1.5 application. In my sql-server 2000 I created a linked
server to firebird using the firebird odbc driver. I cannot query one table
because I get the following error:
" [Non-interface error: Column 'ERHALTENABSCHLAG' (compile-time ordinal 35)
of object 'LVVERW' was reported to ...
|
Adding a ODBC link to many computers
Mon, 7 Jan 2008 14:46:01 -0800
Is there any way of adding an OBDC connection to multiple computers without
going to each system. I need to push out a new SQL Server connection, does
anyone know an easy way.
Thanks! ...
|
