DB-Library vs. OLE DB

Are there any benefits in choosing OLE DB interface instead of using the native DB-Library connectivity?
What is recommended?
Thanks,
AdamSupportability would be the #1 reason for choosing OLEDB over DB Library.
DB Library is considered an a legacy interface and as such was not updated
from what shipped with SQL Server 6.5 and 7.0.
--
--Brian
(Please reply to the newsgroups only.)
"Adam Ticktin" <anonymous@.discussions.microsoft.com> wrote in message
news:AD2D6770-2EBF-4886-BD6D-550AF7D6E6E7@.microsoft.com...
> Are there any benefits in choosing OLE DB interface instead of using the
> native DB-Library connectivity?
> What is recommended?
> Thanks,
> Adam|||Thanks Brian! Any known loss of available functionality in 2000 that can't be accessed DB-Library?
Adam|||Adam,
> Any known loss of available functionality in 2000
> that can't be accessed DB-Library?
Well, basically everything that was added to SQL Server after
version 6.5 is not supported by DB-Library.
DB-Library became obsolete years ago. Don't even think about using
it.
Linda|||I would not recommend using DB-Library. Yukon, the next release of SQL
Server, will not include the files needed to develop DB-Library
applications. The following warning has been in the readme of every SQL
Server 2000 service pack and in every update to the SQL Server 2000 Books
Online:
Warning While the DB-Library API is still supported in Microsoft SQL Server
2000, no future versions of SQL Server will include the files needed to do
programming work on applications that use this API. Connections from
existing applications written using DB-Library will still be supported in
the next version of SQL Server, but this support will also be dropped in a
future release. When writing new applications, avoid using DB-Library. When
modifying existing applications, you are strongly encouraged to remove
dependencies on DB-Library. Instead of DB-Library, you can use Microsoft
ActiveX® Data Objects (ADO), OLE DB, or ODBC to access data in SQL Server.
Also, this topic in the SQL Server 2000 Books Online outlines the types of
features not available to DB-Library applications:
http://msdn.microsoft.com/library/?url=/library/en-us/bldgapps/ba_highprog_56pc.asp?frame=true
And a third point against DB-Library: the SQL Server client components used
in ADO.NET, ADO, OLE DB, and ODBC are also native interfaces for SQL Server.
The SQLClient managed provider, the SQLOLEDB provider, and SQL Server ODBC
driver all use the native SQL Server protocol (TDS) to send their requests
to the database engine. DB-Library will not have an inherent performance
advantage over any of these APIs.
--
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights|||=?Utf-8?B?QWRhbSBUaWNrdGlu?= (anonymous@.discussions.microsoft.com) writes:
> Thanks Brian! Any known loss of available functionality in 2000 that can't
> be accessed DB-Library?
Quite a bit.
I have a list on
http://www.sommarskog.se/mssqlperl/mssql-sqllib.html#restrictions_with_new_datatypes
This text is in the context of two Perl modules that I have.
DB-Library is a very nice interface, fast and simple that does not
do things behind your back. Unfortunately, Microsoft does not at all
share my opinion on this matter.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

DB-Library vs. OLE DB

Are there any benefits in choosing OLE DB interface instead of using the nat
ive DB-Library connectivity?
What is recommended?
Thanks,
AdamSupportability would be the #1 reason for choosing OLEDB over DB Library.
DB Library is considered an a legacy interface and as such was not updated
from what shipped with SQL Server 6.5 and 7.0.
--Brian
(Please reply to the newsgroups only.)
"Adam Ticktin" <anonymous@.discussions.microsoft.com> wrote in message
news:AD2D6770-2EBF-4886-BD6D-550AF7D6E6E7@.microsoft.com...

quote:

---

> Are there any benefits in choosing OLE DB interface instead of using the
> native DB-Library connectivity?
> What is recommended?
> Thanks,
> Adam

---

|||Thanks Brian! Any known loss of available functionality in 2000 that can't b
e accessed DB-Library?
Adam|||Adam,

quote:

---

> Any known loss of available functionality in 2000
> that can't be accessed DB-Library?

---

Well, basically everything that was added to SQL Server after
version 6.5 is not supported by DB-Library.
DB-Library became obsolete years ago. Don't even think about using
it.
Linda|||I would not recommend using DB-Library. Yukon, the next release of SQL
Server, will not include the files needed to develop DB-Library
applications. The following warning has been in the readme of every SQL
Server 2000 service pack and in every update to the SQL Server 2000 Books
Online:
Warning While the DB-Library API is still supported in Microsoft SQL Server
2000, no future versions of SQL Server will include the files needed to do
programming work on applications that use this API. Connections from
existing applications written using DB-Library will still be supported in
the next version of SQL Server, but this support will also be dropped in a
future release. When writing new applications, avoid using DB-Library. When
modifying existing applications, you are strongly encouraged to remove
dependencies on DB-Library. Instead of DB-Library, you can use Microsoft
ActiveX Data Objects (ADO), OLE DB, or ODBC to access data in SQL Server.
Also, this topic in the SQL Server 2000 Books Online outlines the types of
features not available to DB-Library applications:
http://msdn.microsoft.com/library/?...>
p?frame=true
And a third point against DB-Library: the SQL Server client components used
in ADO.NET, ADO, OLE DB, and ODBC are also native interfaces for SQL Server.
The SQLClient managed provider, the SQLOLEDB provider, and SQL Server ODBC
driver all use the native SQL Server protocol (TDS) to send their requests
to the database engine. DB-Library will not have an inherent performance
advantage over any of these APIs.
Alan Brewer [MSFT]
Lead programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights|||examnotes (anonymous@.discussions.microsoft.com) writes:

quote:

---

> Thanks Brian! Any known loss of available functionality in 2000 that can't
> be accessed DB-Library?

---

Quite a bit.
I have a list on
es" target="_blank">http://www.sommarskog.se/mssqlperl/...tatyp
es
This text is in the context of two PERL modules that I have.
DB-Library is a very nice interface, fast and simple that does not
do things behind your back. Unfortunately, Microsoft does not at all
share my opinion on this matter.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

DB-library network communications layer not loaded

Hi guys. I'm a pleb in a POS company and I'm learning SQL server on the fly. I'm sure that'll sound familiar.
I've got one client's having problems with our system. We have a program that runs at night that performs database maintenance tasks. This program has worked in all our other clients sites except this one.
At first I thought it might be a missing "sa" user due to the following error:

RUNTIME ERROR "-2147203048 (80044818): [Microsoft][ODBC SQL
Server driver][SQL Server]Login failed for user 'sa'

I've spoken to the programmers and they have no idea as to why:
1. The user isn't there
2. A quick way of fixing.
The best suggestion that they've come up with is to install Enterprise manager. Something is better then nothing I guess.
Anyway, in the mean time, I've contacted a former associate of the company and asked him to ask error. He then came back with some helpful stuff, one of which jogged my memory to just run a quick test of the 'sa' user to see if it's there. So I run just a simple command line query (isql -U sa, no password) which returned the following error:

DB-Library: Db-library network communications layer not loaded.

This leads me to believe that 'sa' is in fact there. The thing that further compounds this belief is that the main POS can logon through that driver except this particular database maintenance application.

I'd appreciate any help you've got. Please bear with me if this is posted on the wrong forum. Thanks.

Kind regards,

ka Kwok
Customer Service OperatorRE:
... a simple command line query (isql -U sa, no password) which returned...
Hopefully the issue is simply that the sa account HAS a password other than nothing (if not it would be wise to consider immediately issuing the sa account a strong password).
Q1 I'd appreciate any help you've got. Please bear with me if this is posted on the wrong forum. Thanks. Kind regards, ka Kwok Customer Service Operator

A1 Some things to consider and / or check may include:

Create and try another TestConnection account with a known (strong) password. What type of connections does the server support, and has it been verified that the Sql Service is in fact always running? Is Sql Server security configured for the connection type being attempted (standard Sql Server login, in the case of sa)? Is it possible to connect using Query Analyzer and a TestConnection account locally (if not, verify that the correct protocol, ports, etc., is being accessed)? Check and / or update MDAC levels as necessary / appropriate.

{More detailed information (including the Sql Server, MDAC, etc. versions involved, etc.), should make it easier for others to provide more useful / helpful feedback.}|||Thanks for your response. I've been thinking about this issue a fair bit.
I want to provide more information but given my position, I'm having problem trying to source that information. Currently, I'm not even been given a lot of help or support from any one with in the company to resolve this situation. However I'm pretty adamant on fixing this problem since it's an important client (if anything politcal happens I'll just treat it as the trigger).
Anyway, I'm starting to think that it might be a corrupted MDAC library. The server that's running our POS is serviced by another company and I'm starting to suspect something happened that no one's telling me stuff about.
I'm going to try a lot of what suggested with the other posts (on related matter) and see if that helps.
I'm still pretty much learning MS SQL on the fly.
I've bought a book on it but I'd value some better sources. Would you happen to have some sort good links or a list of good references.
I appreciated your help.
Thanks again.

Kind regards,

Broomer|||RE:
Thanks for your response. I've been thinking about this issue a fair bit.
I want to provide more information but given my position, I'm having problem trying to source that information. Currently, I'm not even been given a lot of help or support from any one with in the company to resolve this situation. However I'm pretty adamant on fixing this problem since it's an important client (if anything political happens I'll just treat it as the trigger).

Q1 Anyway, I'm starting to think that it might be a corrupted MDAC library.

The server that's running our POS is serviced by another company and I'm starting to suspect something happened that no one's telling me stuff about.
I'm going to try a lot of what suggested with the other posts (on related matter) and see if that helps.
I'm still pretty much learning MS SQL on the fly.
I've bought a book on it but I'd value some better sources.

You are welcome.

A1 You might consider having the MDAC component status determined with the compatibility checking tool. See:

http://www.microsoft.com/data/download.htm#CCinfo

http://download.microsoft.com/downl...XP/EN-US/cc.exe

RE:
Q2 Would you happen to have some sort of good links or a list of good references. I appreciated your help. Thanks again. Kind regards, Broomer

A2 Yes. Here are a few references: (on the fly, as it were)

* Best "On the fly", and general resource:
Upgrade to the SP3 update to BOL = Books On Line, http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp and use the F1 key (also shift - F1 on hilighted Query Analyzer text)

For some Links See:
http://www.microsoft.com/sql/techinfo/administration/2000/default.asp
http://www.sswug.org/ (great source compiling other resources, membership $ includes Sql server Mag.)
http://www.MSSqlServer.com
http://www.databasejournal.com/features/mssql/

Reference texts:
* Inside Microsoft SQL Server:
- Kalen Delaney for >= Ver 7.0
- Ron Soukop for <= Ver 6.5

- MS Press - Sql Server Performance Tuning

- Solomon for 6.5 Sql Server Unleashed
- Solomon for TSQL - Teach Yourself tsql in 21 Days
- Hotek for 7.0 (mostly still valid in 2k may have newer materials out)
- C. Date for RDBMS fundamentals (not vendor specific)
- Louis Davidson for design - Sql Server 2k DB Design
- Utley for Web Dev
- Peterson for DTS

Note: Those in general admin type roles sometimes prefer something like the SAMS DBA survival guide and a "complete" type reference like Shapiro's (as an alternative to obtaining a collection multiple advanced reference texts). Lots of good texts exist, however, quite a few "survival", fundamentals, and beginners type books offer nothing beyond BOL, and are less well organized.|||Cool Thanks.

All the best.

Kind regards,

Ka Kwok|||Hi, you guys have been extremely helpful. Anyway, I kinda nutted out the problem. Some shmoll has renamed the sa password. I came across the following MSKBA(#322336):
1. Goto the BINN dir
2. osql -U sa <enter><enter> ::This test the password
3. If you get a password file then at least you know the user's there.

To change the password:
1. Goto the BINN dir
2. osql -E <enter> ::Logs you in using Windows authentication
3. sp_password @.old = null, @.new = <password>, @.loginame = 'sa' <enter> ::Where <password> is the new 'password ' (in single quotes) or null for no password
4. go <enter>

My application needed no password (weak security I know, but it ain't my code), and that got them going (touch wood).

Thanks again.

All the best.

Kind regards,

Ka Kwok

Db-library network communications layer not loaded

I have an application that needs to to talk to MS SQL Server 2000.
When I connect from a client machine, I am getting db-library network
communications layer not loaded.
What component is it missing?
--
Cathy BIs the file Ntwdblib.dll in the system32 directory?
Ntwdblib is used for db-lib communications usually found in
older applications. It's not installed with MDAC.
-Sue
On Fri, 28 Jul 2006 07:43:02 -0700, Cathy Boehm
<CathyBoehm@.discussions.microsoft.com> wrote:

>I have an application that needs to to talk to MS SQL Server 2000.
>When I connect from a client machine, I am getting db-library network
>communications layer not loaded.
>What component is it missing?

Db-library network communciations layer not loaded

:( the error is :"Db-library network communciations layer not loaded" it coming with I setup the "BDE", who can help me ,thanks!!!!What is the SQL statement?

DB-LIBRARY error, pls help !

Hello,
i work on a simulationsprogramme. it reads data from a server and then use
it for the simulation. then puts the result in a file. i have a big
problem. i have this error and have no idea what should i do...
please anybody help me .
this is a piece of the output in the file within the error is contained:
..
..
..
LA 07.01.2004 07:59:20 auft_id=28
id | bezeichnung | vari_id | stueckzahl
P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
Auftragsende fuer auft_id = 29
LA 07.01.2004 00:06:45 auft_id=29
id | bezeichnung | vari_id | stueckzahl
Auftragsende fuer auft_id = 30
..
..
..
thanks in advance
lyuboe
Looks like the data and time in the data does not confirm to valid datetime
values.
Speak to the software vendor who wrote your application.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"lyuboe via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:445fef15717a4976845e73f8f7b93a76@.droptable.co m...
> Hello,
> i work on a simulationsprogramme. it reads data from a server and then use
> it for the simulation. then puts the result in a file. i have a big
> problem. i have this error and have no idea what should i do...
> please anybody help me .
> this is a piece of the output in the file within the error is contained:
> .
> .
> .
> LA 07.01.2004 07:59:20 auft_id=28
> id | bezeichnung | vari_id | stueckzahl
> P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> Auftragsende fuer auft_id = 29
> LA 07.01.2004 00:06:45 auft_id=29
> id | bezeichnung | vari_id | stueckzahl
> Auftragsende fuer auft_id = 30
> .
> .
> .
> thanks in advance
> lyuboe

DB-LIBRARY error, pls help !

Hello,
i work on a simulationsprogramme. it reads data from a server and then use
it for the simulation. then puts the result in a file. i have a big
problem. i have this error and have no idea what should i do...
please anybody help me .
this is a piece of the output in the file within the error is contained:
.
.
.
LA 07.01.2004 07:59:20 auft_id=28
id | bezeichnung | vari_id | stueckzahl
P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
SQL Server.
Auftragsende fuer auft_id = 29
LA 07.01.2004 00:06:45 auft_id=29
id | bezeichnung | vari_id | stueckzahl
Auftragsende fuer auft_id = 30
.
.
.
thanks in advance
lyuboeLooks like the data and time in the data does not confirm to valid datetime
values.
Speak to the software vendor who wrote your application.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"lyuboe via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:445fef15717a4976845e73f8f7b93a76@.SQLMonster.com...
> Hello,
> i work on a simulationsprogramme. it reads data from a server and then use
> it for the simulation. then puts the result in a file. i have a big
> problem. i have this error and have no idea what should i do...
> please anybody help me .
> this is a piece of the output in the file within the error is contained:
> .
> .
> .
> LA 07.01.2004 07:59:20 auft_id=28
> id | bezeichnung | vari_id | stueckzahl
> P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: ?berpr?fen Sie Meldungen vom Computer mit
> SQL Server.
> Auftragsende fuer auft_id = 29
> LA 07.01.2004 00:06:45 auft_id=29
> id | bezeichnung | vari_id | stueckzahl
> Auftragsende fuer auft_id = 30
> .
> .
> .
> thanks in advance
> lyuboe

DB-LIBRARY error, pls help !

Hello,
i work on a simulationsprogramme. it reads data from a server and then use
it for the simulation. then puts the result in a file. i have a big
problem. i have this error and have no idea what should i do...
please anybody help me .
this is a piece of the output in the file within the error is contained:
.
.
.
LA 07.01.2004 07:59:20 auft_id=28
id | bezeichnung | vari_id | stueckzahl
P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
SQL Server message 241, state 1, severity 16:
Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
Zeichenfolge.
DB-LIBRARY error:
Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
SQL Server.
Auftragsende fuer auft_id = 29
LA 07.01.2004 00:06:45 auft_id=29
id | bezeichnung | vari_id | stueckzahl
Auftragsende fuer auft_id = 30
.
.
.
thanks in advance
lyuboeLooks like the data and time in the data does not confirm to valid datetime
values.
Speak to the software vendor who wrote your application.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"lyuboe via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:445fef15717a4976845e73f8f7b93a76@.SQ
droptable.com...
> Hello,
> i work on a simulationsprogramme. it reads data from a server and then use
> it for the simulation. then puts the result in a file. i have a big
> problem. i have this error and have no idea what should i do...
> please anybody help me .
> this is a piece of the output in the file within the error is contained:
> .
> .
> .
> LA 07.01.2004 07:59:20 auft_id=28
> id | bezeichnung | vari_id | stueckzahl
> P 07.01.2004 -842150451:-842150451:-842150451 Ende der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> P 07.01.2004 -842150451:-842150451:-842150451 Anfang der Pause
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> SQL Server message 241, state 1, severity 16:
> Syntaxfehler beim Konvertieren einer Zeichenfolge in eine datetime-
> Zeichenfolge.
> DB-LIBRARY error:
> Allgemeiner SQL Server-Fehler: berprfen Sie Meldungen vom Computer mit
> SQL Server.
> Auftragsende fuer auft_id = 29
> LA 07.01.2004 00:06:45 auft_id=29
> id | bezeichnung | vari_id | stueckzahl
> Auftragsende fuer auft_id = 30
> .
> .
> .
> thanks in advance
> lyuboe

DB-Library error 10038

Hi There,
We have VC++6.0 based application which uses DB-Library calls to communicate with the SQL Server2000 database.
There is typical scenario in the application where we want to process the result of a multiple-row based query in WHILE loop and execute another query inside WHILE loop based on the data in the result fetched.
The psuedo-code is as below
While (result.fetch())
{
//prepare where clause based on the data in the row fetched
char* strWhere= ...
//Execute the Query on the same connection using db-lib API
//Fetch the result
}
But DB-Library do not allow such scenario and throws below error
"DB-Library error 10038: Attempt to initiate a new SQL Server operation with results pending."
Because of the tightly coupled business logic, its impossible to change the WHILE LOOP and also the flow of the application.
Is there any solution for above said problem?
Thanks in advance.
Regards,
Yog
Hi. You have the wrong newsgroup, but one thing that would fix it
is to make the inner query with a different connection than the
outer query. An alternative would be to switch away from DbLib, so you
could do fetches in a cursor-based approach.
Joe Weinstein at BEA
Yog wrote:

> Hi There,
> We have VC++6.0 based application which uses DB-Library calls to communicate with the SQL Server2000 database.
> There is typical scenario in the application where we want to process the result of a multiple-row based query in WHILE loop and execute another query inside WHILE loop based on the data in the result fetched.
> The psuedo-code is as below
> While (result.fetch())
> {
> //prepare where clause based on the data in the row fetched
> char* strWhere= ...
> //Execute the Query on the same connection using db-lib API
> //Fetch the result
> }
> But DB-Library do not allow such scenario and throws below error
> "DB-Library error 10038: Attempt to initiate a new SQL Server operation with results pending."
> Because of the tightly coupled business logic, its impossible to change the WHILE LOOP and also the flow of the application.
> Is there any solution for above said problem?
> Thanks in advance.
> Regards,
> Yog

DB-Library error 10038

Hi There,
We have VC++6.0 based application which uses DB-Library calls to communicate with the SQL Server2000 database.
There is typical scenario in the application where we want to process the result of a multiple-row based query in WHILE loop and execute another query inside WHILE loop based on the data in the result fetched.
The psuedo-code is as below
While (result.fetch())
{
//prepare where clause based on the data in the row fetched
char* strWhere= ...
//Execute the Query on the same connection using db-lib API
//Fetch the result
}
But DB-Library do not allow such scenario and throws below error
"DB-Library error 10038: Attempt to initiate a new SQL Server operation with results pending."
Because of the tightly coupled business logic, its impossible to change the WHILE LOOP and also the flow of the application.
Is there any solution for above said problem?
Thanks in advance.
Regards,
Yog
Yog,
You will need to either fetch all the values first, close the result set,
and then do your inner loop query logic or use two separate connections to
the same database. Just like the error message says, the problem is that you
have initiated an operation that still has data to be retrieved from the
server and then attempted to execute another query.
Jim
"Yog" <y.bang@.zensar.com> wrote in message
news:C638CAD8-C4E2-49DE-955B-BE0B34977DD2@.microsoft.com...
> Hi There,
> We have VC++6.0 based application which uses DB-Library calls to
communicate with the SQL Server2000 database.
> There is typical scenario in the application where we want to process the
result of a multiple-row based query in WHILE loop and execute another query
inside WHILE loop based on the data in the result fetched.
> The psuedo-code is as below
> While (result.fetch())
> {
> //prepare where clause based on the data in the row fetched
> char* strWhere= ...
> //Execute the Query on the same connection using db-lib API
> //Fetch the result
> }
> But DB-Library do not allow such scenario and throws below error
> "DB-Library error 10038: Attempt to initiate a new SQL Server operation
with results pending."
> Because of the tightly coupled business logic, its impossible to change
the WHILE LOOP and also the flow of the application.
> Is there any solution for above said problem?
> Thanks in advance.
> Regards,
> Yog

DB-Library error 10038

Hi There,
We have VC++6.0 based application which uses DB-Library calls to communicate
with the SQL Server2000 database.
There is typical scenario in the application where we want to process the re
sult of a multiple-row based query in WHILE loop and execute another query i
nside WHILE loop based on the data in the result fetched.
The psuedo-code is as below
While (result.fetch())
{
//prepare where clause based on the data in the row fetched
char* strWhere= ...
//Execute the Query on the same connection using db-lib API
//Fetch the result
}
But DB-Library do not allow such scenario and throws below error
"DB-Library error 10038: Attempt to initiate a new SQL Server operation with
results pending."
Because of the tightly coupled business logic, its impossible to change the
WHILE LOOP and also the flow of the application.
Is there any solution for above said problem?
Thanks in advance.
Regards,
YogYog,
Have you tried opening a second connection for the internal result set?
Russell Fields
"Yog" <y.bang@.zensar.com> wrote in message
news:0E65530E-C692-4850-8DF4-800912D22DBD@.microsoft.com...
> Hi There,
> We have VC++6.0 based application which uses DB-Library calls to
communicate with the SQL Server2000 database.
> There is typical scenario in the application where we want to process the
result of a multiple-row based query in WHILE loop and execute another query
inside WHILE loop based on the data in the result fetched.
> The psuedo-code is as below
> While (result.fetch())
> {
> //prepare where clause based on the data in the row fetched
> char* strWhere= ...
> //Execute the Query on the same connection using db-lib API
> //Fetch the result
> }
> But DB-Library do not allow such scenario and throws below error
> "DB-Library error 10038: Attempt to initiate a new SQL Server operation
with results pending."
> Because of the tightly coupled business logic, its impossible to change
the WHILE LOOP and also the flow of the application.
> Is there any solution for above said problem?
> Thanks in advance.
> Regards,
> Yog|||You need to fetch all the rows to completion before issueing another query.
Ex do while .not eof()
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

DB-Library error 10038

Hi There,
We have VC++6.0 based application which uses DB-Library calls to communicate with the SQL Server2000 database.
There is typical scenario in the application where we want to process the result of a multiple-row based query in WHILE loop and execute another query inside WHILE loop based on the data in the result fetched.
The psuedo-code is as below
While (result.fetch())
{
//prepare where clause based on the data in the row fetched
char* strWhere= ...
//Execute the Query on the same connection using db-lib API
//Fetch the result
}
But DB-Library do not allow such scenario and throws below error
"DB-Library error 10038: Attempt to initiate a new SQL Server operation with results pending."
Because of the tightly coupled business logic, its impossible to change the WHILE LOOP and also the flow of the application.
Is there any solution for above said problem?
Thanks in advance.
Regards,
Yog
This is a problem which typically arises when the results from an ongoing
command are still being processed.
In your scenario, you have probably sent a command to the server before all
results from a previous command have been processed.
To overcome this problem, the only way is to wait for the results to
process from the first query and then start the new query in the same
session.
Please also review this very helpful link:
http://msdn.microsoft.com/library/de...us/dblibc/dbc_
pdc02_4sxl.asp
Hope this helps.
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

DB-Library error 10038

Hi There,
We have VC++6.0 based application which uses DB-Library calls to communicate with the SQL Server2000 database.
There is typical scenario in the application where we want to process the result of a multiple-row based query in WHILE loop and execute another query inside WHILE loop based on the data in the result fetched.
The psuedo-code is as below
While (result.fetch())
{
//prepare where clause based on the data in the row fetched
char* strWhere= ...
//Execute the Query on the same connection using db-lib API
//Fetch the result
}
But DB-Library do not allow such scenario and throws below error
"DB-Library error 10038: Attempt to initiate a new SQL Server operation with results pending."
Because of the tightly coupled business logic, its impossible to change the WHILE LOOP and also the flow of the application.
Is there any solution for above said problem?
Thanks in advance.
Regards,
Yog
1. Create another connection and execute your "subquery" in that connection
2. Wait for Yukon release - it is announced that Yukon will support
simultaneous queries on the same connection
3. Use T-SQL procedure for doing such a processing instead of client-side
cursor emulation
"Yog" <y.bang@.zensar.com> wrote in message
news:E50F797E-9F9D-4487-ADAF-AD251F1DC620@.microsoft.com...
> Hi There,
> We have VC++6.0 based application which uses DB-Library calls to
communicate with the SQL Server2000 database.
> There is typical scenario in the application where we want to process the
result of a multiple-row based query in WHILE loop and execute another query
inside WHILE loop based on the data in the result fetched.
> The psuedo-code is as below
> While (result.fetch())
> {
> //prepare where clause based on the data in the row fetched
> char* strWhere= ...
> //Execute the Query on the same connection using db-lib API
> //Fetch the result
> }
> But DB-Library do not allow such scenario and throws below error
> "DB-Library error 10038: Attempt to initiate a new SQL Server operation
with results pending."
> Because of the tightly coupled business logic, its impossible to change
the WHILE LOOP and also the flow of the application.
> Is there any solution for above said problem?

DB-Library error 10038

Hi There,
We have VC++6.0 based application which uses DB-Library calls to communicate
with the SQL Server2000 database.
There is typical scenario in the application where we want to process the re
sult of a multiple-row based query in WHILE loop and execute another query i
nside WHILE loop based on the data in the result fetched.
The psuedo-code is as below
While (result.fetch())
{
//prepare where clause based on the data in the row fetched
char* strWhere= ...
//Execute the Query on the same connection using db-lib API
//Fetch the result
}
But DB-Library do not allow such scenario and throws below error
"DB-Library error 10038: Attempt to initiate a new SQL Server operation with
results pending."
Because of the tightly coupled business logic, its impossible to change the
WHILE LOOP and also the flow of the application.
Is there any solution for above said problem?
Thanks in advance.
Regards,
Yog1. Create another connection and execute your "subquery" in that connection
2. Wait for Yukon release - it is announced that Yukon will support
simultaneous queries on the same connection
3. Use T-SQL procedure for doing such a processing instead of client-side
cursor emulation
"Yog" <y.bang@.zensar.com> wrote in message
news:E50F797E-9F9D-4487-ADAF-AD251F1DC620@.microsoft.com...
> Hi There,
> We have VC++6.0 based application which uses DB-Library calls to
communicate with the SQL Server2000 database.
> There is typical scenario in the application where we want to process the
result of a multiple-row based query in WHILE loop and execute another query
inside WHILE loop based on the data in the result fetched.
> The psuedo-code is as below
> While (result.fetch())
> {
> //prepare where clause based on the data in the row fetched
> char* strWhere= ...
> //Execute the Query on the same connection using db-lib API
> //Fetch the result
> }
> But DB-Library do not allow such scenario and throws below error
> "DB-Library error 10038: Attempt to initiate a new SQL Server operation
with results pending."
> Because of the tightly coupled business logic, its impossible to change
the WHILE LOOP and also the flow of the application.
> Is there any solution for above said problem?

DB-Library error 10038

Hi There,
We have VC++6.0 based application which uses DB-Library calls to communicate with the SQL Server2000 database.
There is typical scenario in the application where we want to process the result of a multiple-row based query in WHILE loop and execute another query inside WHILE loop based on the data in the result fetched.
The psuedo-code is as below
While (result.fetch())
{
//prepare where clause based on the data in the row fetched
char* strWhere= ...
//Execute the Query on the same connection using db-lib API
//Fetch the result
}
But DB-Library do not allow such scenario and throws below error
"DB-Library error 10038: Attempt to initiate a new SQL Server operation with results pending."
Because of the tightly coupled business logic, its impossible to change the WHILE LOOP and also the flow of the application.
Is there any solution for above said problem?
Thanks in advance.
Regards,
Yog1. Create another connection and execute your "subquery" in that connection
2. Wait for Yukon release - it is announced that Yukon will support
simultaneous queries on the same connection
3. Use T-SQL procedure for doing such a processing instead of client-side
cursor emulation
"Yog" <y.bang@.zensar.com> wrote in message
news:E50F797E-9F9D-4487-ADAF-AD251F1DC620@.microsoft.com...
> Hi There,
> We have VC++6.0 based application which uses DB-Library calls to
communicate with the SQL Server2000 database.
> There is typical scenario in the application where we want to process the
result of a multiple-row based query in WHILE loop and execute another query
inside WHILE loop based on the data in the result fetched.
> The psuedo-code is as below
> While (result.fetch())
> {
> //prepare where clause based on the data in the row fetched
> char* strWhere= ...
> //Execute the Query on the same connection using db-lib API
> //Fetch the result
> }
> But DB-Library do not allow such scenario and throws below error
> "DB-Library error 10038: Attempt to initiate a new SQL Server operation
with results pending."
> Because of the tightly coupled business logic, its impossible to change
the WHILE LOOP and also the flow of the application.
> Is there any solution for above said problem?

DB-Library Error - Severity 5 Error No 10007 OS Error: -1

DB-Library Error - Severity 5 Error No 10007 OS Error: -1
General SQL Server error: Check messages from SQL Server
We are getting this error after moving our SQL Server 2000 database to a
Windows 2003 server from a Windows 2000 server.
Any ideas?
TIA.
It means exactly what it says: DB-Lib had an execution error--for numerous possible reasons. You need to post the specific SQL Server error returned to determine the nature of the issue.
Sincerely,
Anthony Thomas

"Rohan" <Rohan@.discussions.microsoft.com> wrote in message news:7730B417-2A7B-4D89-85BB-B1FDFC72A470@.microsoft.com...
DB-Library Error - Severity 5 Error No 10007 OS Error: -1
General SQL Server error: Check messages from SQL Server
We are getting this error after moving our SQL Server 2000 database to a
Windows 2003 server from a Windows 2000 server.
Any ideas?
TIA.

DB-Library Error - Severity 5 Error No 10007 OS Error: -1

DB-Library Error - Severity 5 Error No 10007 OS Error: -1
General SQL Server error: Check messages from SQL Server
We are getting this error after moving our SQL Server 2000 database to a
Windows 2003 server from a Windows 2000 server.
Any ideas?
TIA.It means exactly what it says: DB-Lib had an execution error--for numerous p
ossible reasons. You need to post the specific SQL Server error returned to
determine the nature of the issue.
Sincerely,
Anthony Thomas
--
"Rohan" <Rohan@.discussions.microsoft.com> wrote in message news:7730B417-2
A7B-4D89-85BB-B1FDFC72A470@.microsoft.com...
DB-Library Error - Severity 5 Error No 10007 OS Error: -1
General SQL Server error: Check messages from SQL Server
We are getting this error after moving our SQL Server 2000 database to a
Windows 2003 server from a Windows 2000 server.
Any ideas?
TIA.

DB-Library C API and SQL Server 2005 (ntwdblib.lib and ntwdblib.dl

We own a software package that has a SQL Server driver based on ntwdblib.dll
.
Will we be able to run this software on SQL Server 2005? In other words, wil
l
the DB library be supported?Hi
No. It has been in end of life mode since SQL Server 7.0 and no new data
types added in SQL Server 7/2000 are supported. In SQL server 2005, it is no
t
supported at all.
http://msdn.microsoft.com/data/mdac...mdacroadmap.asp
Regards
Mike
"BizTalk" wrote:

> We own a software package that has a SQL Server driver based on ntwdblib.d
ll.
> Will we be able to run this software on SQL Server 2005? In other words, w
ill
> the DB library be supported?

DB-Library and sp_dbcmptlevel in Sql Server 2005

Hello!
We are currently running SQL Server 7.0 with databases in 6.5-compatibility
mode for DB-Library.
- Will this still be supported in Sql Server 2005?
- If so, any changes in behaviour?
- What new features will we be "missing out of" by continuing with the above
setup (db-lib + 6.5-mode) also in Sql Server 2005?
- Any future plans of dropping the support for DB-Lib with Sql Server?
ThanxAFAIK, the dblib interface will be supported in the next version of sql
server. MS has indicated that they do intend to stop supporting it but they
have not announced when. MS has indicated that the dblib api is
feature-frozen and will not be enhanced to take advantage of any new
features introduced after sql server version 6.5.
The most important feature that dblib does not support is char columns > 255
characters. Beyond that, I don't know of any particular features that
cannot be accessed. It is NOT necessary to set the database into 6.5
compatibility mode when using the dblib interface; you may want to review
the process that lead you to this decision. BOL has a section that
discusses the changes between the most current versions of sql server - that
is what you are missing out of by setting the compatibility mode.
"Tomas" <Tomas@.discussions.microsoft.com> wrote in message
news:8694521C-0379-4B00-A5C0-36A98CE63191@.microsoft.com...
> Hello!
> We are currently running SQL Server 7.0 with databases in
6.5-compatibility
> mode for DB-Library.
> - Will this still be supported in Sql Server 2005?
> - If so, any changes in behaviour?
> - What new features will we be "missing out of" by continuing with the
above
> setup (db-lib + 6.5-mode) also in Sql Server 2005?
> - Any future plans of dropping the support for DB-Lib with Sql Server?
> Thanx|||SEE
http://msdn.microsoft.com/library/d...y/en-us/dnmdac/
html/data_mdacroadmap.asp
DB-Library: This is a SQL Server-specific programming model that
includes C APIs. There have been no feature enhancements to the
DB-Library since SQL Server 6.5. Its final release was with SQL Server
2000 and it will not be ported to the 64-bit Windows operating system.
Tim S
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

DB-Library and sp_dbcmptlevel in Sql Server 2005

Hello!
We are currently running SQL Server 7.0 with databases in 6.5-compatibility
mode for DB-Library.
- Will this still be supported in Sql Server 2005?
- If so, any changes in behaviour?
- What new features will we be "missing out of" by continuing with the above
setup (db-lib + 6.5-mode) also in Sql Server 2005?
- Any future plans of dropping the support for DB-Lib with Sql Server?
Thanx
AFAIK, the dblib interface will be supported in the next version of sql
server. MS has indicated that they do intend to stop supporting it but they
have not announced when. MS has indicated that the dblib api is
feature-frozen and will not be enhanced to take advantage of any new
features introduced after sql server version 6.5.
The most important feature that dblib does not support is char columns > 255
characters. Beyond that, I don't know of any particular features that
cannot be accessed. It is NOT necessary to set the database into 6.5
compatibility mode when using the dblib interface; you may want to review
the process that lead you to this decision. BOL has a section that
discusses the changes between the most current versions of sql server - that
is what you are missing out of by setting the compatibility mode.
"Tomas" <Tomas@.discussions.microsoft.com> wrote in message
news:8694521C-0379-4B00-A5C0-36A98CE63191@.microsoft.com...
> Hello!
> We are currently running SQL Server 7.0 with databases in
6.5-compatibility
> mode for DB-Library.
> - Will this still be supported in Sql Server 2005?
> - If so, any changes in behaviour?
> - What new features will we be "missing out of" by continuing with the
above
> setup (db-lib + 6.5-mode) also in Sql Server 2005?
> - Any future plans of dropping the support for DB-Lib with Sql Server?
> Thanx
|||SEE
http://msdn.microsoft.com/library/de.../en-us/dnmdac/
html/data_mdacroadmap.asp
DB-Library: This is a SQL Server-specific programming model that
includes C APIs. There have been no feature enhancements to the
DB-Library since SQL Server 6.5. Its final release was with SQL Server
2000 and it will not be ported to the 64-bit Windows operating system.
Tim S
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!