Delphi 4 tTable

Blair Allen Stark

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

SQL Server 7.0/Delphi 4 tTable

I have a tDatabase hooked through a BDE ->ODBC MS SQL - Server 7.0 driver. One
of my tables can't be seen!!! The table name is there, but no field info. If I
go through database explorer I get object not found when I try to get the tables
fields.
All other tables are fine. the ODBC driver works fine in MS Access.

How do I configure a native MSSQL driver for it?
I tried
database=Mydatabase
server name=MyServer

Error Message='your application is not configured for use of this driver'

bas

Blair Allen Star

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server 7.0/Delphi 4 tTable

I found my problem!!!!

BDE doesnt recognize SQL Servers nvarchar type

bas

Marcelo Rodriguez Mor

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server 7.0/Delphi 4 tTable

Hi:

BDE 5.01 have trouble if you use ODBC to connect SQL SERVER 7.0.
Try with BDE 5.10.

Blair Allen Stark escribi en mensaje <80ured$gb...@forums.borland.com>...

Quote

>I have a tDatabase hooked through a BDE ->ODBC MS SQL - Server 7.0 driver.
One
>of my tables can't be seen!!! The table name is there, but no field info.
If I
>go through database explorer I get object not found when I try to get the
tables
>fields.
>All other tables are fine. the ODBC driver works fine in MS Access.

>How do I configure a native MSSQL driver for it?
>I tried
>database=Mydatabase
>server name=MyServer

>Error Message='your application is not configured for use of this driver'

>bas

Other Threads

1. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server

2. Open connections with TTable-components to SQL - server 7.0 during runtime

3. Sql Server 2000 & Sql Server 7.0

4. Delphi with SQL Server 7.0

5. Dynaset in Delphi 5 with MS SQL 7.0 Server

6. Delphi 5.0, ADO and MS SQL Server 7.0

7. Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000

8. SQL Server 7.0 with Delphi 5.0 - stored procedures with parameters - Native BDE driver

9. Delphi 4 SProc Component & SQL Server 7.0

10. SQL server 7.0 and Delphi