all groups > sql server odbc > november 2003 > threads for november 1 - 7, 2003
Filter by week: 1 2 3 4 5
Win2003 enterprise- SQL2000enterprise - ODBC error
Posted by Clarise at 11/7/2003 5:30:41 PM
On one of our domains we have win2003 enterprise and SQL
2000 enterprise installed. The clients that access this
server are windows 2ooo prof or XP prof. When trying to
connect to the sql2000 server through ODBC. I get the
error [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
SQL Server ... more >>
MS Access Link Table list incomplete
Posted by Don Jellie at 11/7/2003 4:18:57 PM
Hi all,
I'm using the MS Access Link Tables function to link to a SQL Server 2000 DB
and the list only shows 1 table (actually, it's alphabetically the first
view in the DB. The server is new and we recently moved the DB to it, but
nothing in the DB itself looks different or suspicious. Perm... more >>
ODBC failure after applying SP3 to SQL70
Posted by Michele at 11/7/2003 9:58:36 AM
AFter upgrading a SQL 7.0 server to SP3, our previously
working odbc connections to a database are failing,
saying - SQL Server Error 18452. Login failed for user
sa - not
associated with a trusted SQL server connection.
Any ideas?... more >>
Equivalent of Oracle's Rrownum SQL
Posted by Aparna at 11/7/2003 5:37:02 AM
Hi,
We have a requirement to display records from MS SQL
database in pages of predefined rows. In Oracle, we can
incorporate this paging logic using "rownum" pseudocolumn.
I am new to SQL. Is there any equivalent of rownum funda
in SQL ?
Thanks & Regards,
Aparna S.... more >>
Load Access 97 *.db in SQL-Server
Posted by Jochen_Brüggemann at 11/7/2003 2:39:02 AM
Hi,
to load an Access 97 *.db-file in my SQL-Server I need an
appropiate ODBC-driver. Where do I get one?
Thanks in advance
Jochen
... more >>
ODBC error inserting data via ASP
Posted by Rodney at 11/6/2003 10:55:24 AM
I am working with a form on an ASP page and getting the
following error when attempting to insert data into my
MSSQL7 table which had been working fine.
Microsoft OLE DB Provider for ODBC Drivers
error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or
binary data would... more >>
ODBC Driver download
Posted by Piter at 11/6/2003 9:38:54 AM
Hi, i need an updated driver for Sql-Server ODBC...
I have Windows 2000 with SP4 and I really need it!
could You please help me by telling where can I find it?
thanks!
Piter... more >>
Stored Procedure and NextRecordset
Posted by Lynn Pennington at 11/6/2003 7:57:32 AM
How do I use "NextRecordset" in Access 2000?
I have a stored procedure that returns two recordsets and
when I execute from Access only one set opens.
Please advise.
Thanks,
Lynn.... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
FWD: Look at critical pack for Windows
Posted by MOURAGRO at 11/4/2003 12:47:36 PM
Microsoft Customer
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to he... more >>
Personal Oracle
Posted by Marek Gazda at 11/4/2003 9:22:50 AM
Hi
Please could you help me?
I installed Personal Oracle 8.0.4 on win98.
How could I connect to local database by ODBC driver.
When I go to ODBC administrator and chooise "ORACLE ODBC Driver", I can't
configure database source, because when I click Add - do nothing.
What I need to do, which ... more >>
Linked tables from Access97 in Sql7
Posted by Seven at 11/4/2003 7:40:14 AM
does anyone know what kind of locks links in Access97 to
tables in sql7 give? The tables in Sql change very often.
I am very suspicious concerning reading these tables from
Access through links. Am I right?
... more >>
Access Front End SQL 2000 backend
Posted by Jerry at 11/3/2003 4:50:33 PM
Anyone have a solution to the boolean datatype problem
where SQL 2000 changes the way that bit datatypes are
evaluated? When I try to use a checkbox control in Access
2000 to change the data in this field, the control works
greate with false values (0), but does not work with true
values(... more >>
SQL Server ODBC error
Posted by Quin at 11/3/2003 11:50:21 AM
Hello:
I have a VB program that establishes a connection to a
SQL server and insert some data. For some reason, I
receive the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:
Incorrect syntax near '17'.
Any idea what causes this error? I use the same met... more >>
Query Processor Error
Posted by cj at 11/3/2003 10:06:26 AM
I get the following message when I'm inserting a row into a table. The
statement is very simple, but there is a large amount of data going into one
column.
Internal Query Processor Error: The query processor ran out of stack space
during query optimization
All the KB articles I've found so... more >>
Cannot load the DLL mssdi98.dll
Posted by Jon Prisbe at 11/3/2003 8:59:29 AM
I'm trying to debug a stored procedure butkeep getting this message:
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLL
mssdi98.dll, or one of the DLLs it references. Reason: 126(The specified
module could not be found.).
mssdi98.dll is install... more >>
the setup routines for the SQL Server ODBC Driver could not be loaded due to sys
Posted by andrew.seah at 11/2/2003 7:18:55 PM
I am creating an ODBC connection from my PC to the SQL
Server. I got the above error msg.
Could anyone shed me some light into this?
Thanks in advance,
Andrew... more >>
ODBC connection fails for nonAdmins using MS XP machines
Posted by damiensanderson NO[at]SPAM hotmail.com at 11/1/2003 1:38:54 AM
In our Access 97 application, running on W2000 machines, we linked to
tables held on our MS SQL server 7.0. The SQL server is set for
trusted connections. So with a connection string property on the link
some thing like ...
ODBC;DRIVER=SQL SERVER;SERVER=server_name;
DATABASE=databas... more >>
|