all groups > sql server odbc > february 2004 > threads for february 15 - 21, 2004
Filter by week: 1 2 3 4
Provider not found
Posted by Allen Bruce Anderson at 2/21/2004 5:57:51 PM
Sorry for the cross-posting, but I'm not really sure in which newsgroup this
should be posted. Anyway...
I have SQL Server 2000 with SP3 installed on my computer. I'm able to use
Query Analyzer to open tables on the various databases running under SQL
Server, but whenever I try to do so with... more >>
Please Help with ODBC SQL Authentication
Posted by Randy Chow at 2/20/2004 9:29:01 PM
Hello everyone, I am trying to setup a ODBC source using SQL Authentication.
When I finish my settings and test the connection, the connection is
successful. But, when I click the finish to exit out of the configure
option of the ODBC source, and then go back into the ODBC DSN, the password
is ... more >>
SQL with Sybase
Posted by Anatoli Dontsov at 2/20/2004 7:09:46 PM
Hi, All
SQL2000/sp3 and Sybase 11.5
There is a SP on Sybase
CREATE PROC sp_test @t VARCHAR(32) = 'default string'
AS
SELECT @t
I want execute that from SQL
SELECT * FROM
OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test')
works file. But with the parameter it fails
... more >>
Ordinal 29 not found in odbcbcp.dll
Posted by Pat at 2/20/2004 8:56:10 AM
Our Webserver(win 2000) recently crashed and they were
able to get it back by using the Exchange2000 restore
disk. Since they restored, sql server(2000)/IIS 5.0 is
not functioning. We are unable to run an asp page on the
website, htm, html are the only pages that will load in
the browser... more >>
newbie question on SQL Server, ODBC
Posted by jp23 NO[at]SPAM myway.com at 2/19/2004 1:11:10 PM
Hi,
I'm trying to access a MS SQL Server db
from a CGI (pure C program).
Which is the most efficient (fast, incl. fetching
many records on a search term) ...using
embedded SQL in C, ODBC or any other methods?
Any suggestions?
Jon... more >>
SQL_Server_does_not_exist_or_access_denied
Posted by Brian Burgess at 2/19/2004 10:51:32 AM
Hi all,
Apologies for the cross-post. Just wasn't sure where to put this one:
I'm getting this error sporadically on an ADO connection. When it happens
I also cannot connect through the Enterprise Manager (or anything else!).
The environment is SQL Server 2000 running on Windows 2000 Ad... more >>
JSP connection string to SQL 2000
Posted by JasonHuang8888 at 2/18/2004 5:58:18 PM
Hi,
What will be the connection string in the JSP to SQL
Server 2000?
Thanks.
Jason... more >>
Login failed
Posted by mzarbei NO[at]SPAM yahoo.com at 2/18/2004 9:08:30 AM
Hi To All
i Have Encountered Such A Problem In SQLserver2k
Any One To Help ME
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'MZZ\IUSR_MZZ'.
/ostandari... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Table copy (DST)
Posted by Chris Savedge at 2/17/2004 3:43:02 PM
I'm trying to copy a table from one database to another using the DST
wizard. Everything works find until the last step.......at that point I get
an error that says "Error at destination for row number 1. Errors
encountered so far in this task: 1. Line 1: Incorrect syntax near 'Collate'.
" Alt... more >>
ODBC to linked server
Posted by Frederick G. Pierz at 2/17/2004 2:32:02 PM
I have created a linked server using an OLE DB service in a SQL Server 2000
database running on Windows NT 4.
I can see all the tables and views of the linked server in Enterprise
manager, but when I go to a client machine and try to setup a DSN to the
linked server using an SQL Server driver ... more >>
SQL server ODBC Open speed!
Posted by hostran at 2/17/2004 2:12:02 PM
I use Open(dbOpenDynaset,Sql,dbSeeChanges);
to open the SQL server ,lt's very slowly,
Are there any ways to accelerate ?
... more >>
ODBC Error
Posted by Rose at 2/17/2004 10:18:36 AM
Hello,
I=B4m having a problem with an specific client. When the=20
user try to connect to our application, the following=20
message appears:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
[Microsoft][ODBC SQL Server Driver][SQL Server]String or=20
binary data would be... more >>
Occasional "Timeout expired" message - on SP that should take 1 second
Posted by Beverley at 2/16/2004 9:10:27 AM
Hi there,
I've got something kind of weird going on. I have a stored procedure that
normally takes less than one second to execute, but it has started taking
over 30 seconds from time to time.
The SP is called by an ASP page on a web server, running on a separate
machine. The database ser... more >>
ODBC ACCESS
Posted by domed at 2/16/2004 7:44:55 AM
I have a VIEW SQL connected to an other database. How I can connect
this VIEWS in ACCESS inserting one key in runtime?
---
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/... more >>
Cannot open SQL Server Table
Posted by Mark A. Sam at 2/15/2004 10:31:41 PM
Hello,
Can a SQL Server table become corrupted? The tables are linked to an Access
DB and I cannot open the main Order table from Access. I am connected to
the system remotely via Terminal Server and do not have Enterprise manager
available.
I can't imagine what the issue could be otherwi... more >>
|