Board index » delphi » Change DB-Lib to CT-Lib - MSSQLServer 7.0

Change DB-Lib to CT-Lib - MSSQLServer 7.0

I saw at Borland Community the follow faq:

"
Question:

When I try to activate my Table/Query I get an error stating
"invalid field type", what does this mean?

Answer:

Microsoft no longer supports DB-LIB with the release of MS SQL Server 7
which means that
DB-LIB doesn't have support for the 4 new data types that SQL 7 offers -
namely NTEXT,
NCHAR, NVARCHAR and GUID. In order to successfully use new types offered by
SQL Server 7
and above you'll need to use CT-LIB. This should eliminate the error
message.
"

Does anyone know how can I change the DB-Lib to CT-Lib ?

Thanks in Advance

Norberto Hideaki Enomoto
Perfil Tecnologia
+55 11 5507-3320
norberto.per...@onetoone.com.br
www.onetoone.com.br

 

Re:Change DB-Lib to CT-Lib - MSSQLServer 7.0


I saw at Borland Community the follow faq:

"
Question:

When I try to activate my Table/Query I get an error stating
"invalid field type", what does this mean?

Answer:

Microsoft no longer supports DB-LIB with the release of MS SQL Server 7
which means that
DB-LIB doesn't have support for the 4 new data types that SQL 7 offers -
namely NTEXT,
NCHAR, NVARCHAR and GUID. In order to successfully use new types offered by
SQL Server 7
and above you'll need to use CT-LIB. This should eliminate the error
message.
"

Does anyone know how can I change the DB-Lib to CT-Lib ?

Thanks in Advance

Norberto Hideaki Enomoto
Perfil Tecnologia
+55 11 5507-3320
norberto.per...@onetoone.com.br
www.onetoone.com.br

Re:Change DB-Lib to CT-Lib - MSSQLServer 7.0


I saw at Borland Community the follow faq:

"
Question:

When I try to activate my Table/Query I get an error stating
"invalid field type", what does this mean?

Answer:

Microsoft no longer supports DB-LIB with the release of MS SQL Server 7
which means that
DB-LIB doesn't have support for the 4 new data types that SQL 7 offers -
namely NTEXT,
NCHAR, NVARCHAR and GUID. In order to successfully use new types offered by
SQL Server 7
and above you'll need to use CT-LIB. This should eliminate the error
message.
"

Does anyone know how can I change the DB-Lib to CT-Lib ?

Thanks in Advance

Norberto Hideaki Enomoto
Perfil Tecnologia
+55 11 5507-3320
norberto.per...@onetoone.com.br
www.onetoone.com.br

Re:Change DB-Lib to CT-Lib - MSSQLServer 7.0


I saw at Borland Community the follow faq:

"
Question:

When I try to activate my Table/Query I get an error stating
"invalid field type", what does this mean?

Answer:

Microsoft no longer supports DB-LIB with the release of MS SQL Server 7
which means that
DB-LIB doesn't have support for the 4 new data types that SQL 7 offers -
namely NTEXT,
NCHAR, NVARCHAR and GUID. In order to successfully use new types offered by
SQL Server 7
and above you'll need to use CT-LIB. This should eliminate the error
message.
"

Does anyone know how can I change the DB-Lib to CT-Lib ?

Thanks in Advance

Norberto Hideaki Enomoto
Perfil Tecnologia
+55 11 5507-3320
norberto.per...@onetoone.com.br
www.onetoone.com.br

Re:Change DB-Lib to CT-Lib - MSSQLServer 7.0


I saw at Borland Community the follow faq:

"
Question:

When I try to activate my Table/Query I get an error stating
"invalid field type", what does this mean?

Answer:

Microsoft no longer supports DB-LIB with the release of MS SQL Server 7
which means that
DB-LIB doesn't have support for the 4 new data types that SQL 7 offers -
namely NTEXT,
NCHAR, NVARCHAR and GUID. In order to successfully use new types offered by
SQL Server 7
and above you'll need to use CT-LIB. This should eliminate the error
message.
"

Does anyone know how can I change the DB-Lib to CT-Lib ?

Thanks in Advance

Norberto Hideaki Enomoto
Perfil Tecnologia
+55 11 5507-3320
norberto.per...@onetoone.com.br
www.onetoone.com.br

Re:Change DB-Lib to CT-Lib - MSSQLServer 7.0


I don't know why you posted 5 times, but I will point out that CT-LIB is
the way to access later version of Sybase SQL Server.... microsoft SQL
Server does not use CT-LIB at all to my knowledge, to access the new MS
SQL Server 7 features, you need to use OLE-DB or ADO.

Norberto Hideaki Enomoto <norberto.per...@onetoone.com.br> wrote in
message news:89kjc7$mic6@bornews.borland.com...

Quote
> I saw at Borland Community the follow faq:

> "
> Question:

> When I try to activate my Table/Query I get an error stating
> "invalid field type", what does this mean?

> Answer:

> Microsoft no longer supports DB-LIB with the release of MS SQL Server
7
> which means that
> DB-LIB doesn't have support for the 4 new data types that SQL 7
offers -
> namely NTEXT,
> NCHAR, NVARCHAR and GUID. In order to successfully use new types
offered by
> SQL Server 7
> and above you'll need to use CT-LIB. This should eliminate the error
> message.
> "

> Does anyone know how can I change the DB-Lib to CT-Lib ?

> Thanks in Advance

> Norberto Hideaki Enomoto
> Perfil Tecnologia
> +55 11 5507-3320
> norberto.per...@onetoone.com.br
> www.onetoone.com.br

Re:Change DB-Lib to CT-Lib - MSSQLServer 7.0


I believe MS changed the native access for SQL Server from DB-LIB to ODBC
between 6.5 and 7. Their management tools (e.g. backup/restore) now require
the latest ODBC driver 3.7.xxx to be present.

Regards,
Danny Mavromatis.

Quote
Kyle Cordes wrote in message <89msem$o...@bornews.borland.com>...
>I don't know why you posted 5 times, but I will point out that CT-LIB is
>the way to access later version of Sybase SQL Server.... microsoft SQL
>Server does not use CT-LIB at all to my knowledge, to access the new MS
>SQL Server 7 features, you need to use OLE-DB or ADO.

Other Threads