Board index » delphi » Creating Data Dictionary on MS SQL Server 6.0

Eric Slippern

Delphi Developer
Sun, 20 Sep 1998 03:00:00 GMT

Creating Data Dictionary on MS SQL Server 6.0

Has anyone had any success creating a Delphi 2.0 data
dictionary on an MS SQL Server 6.0 database?

I'm using the Dictionary/New... option from SQL Explorer. I've
tried it using both a native SQL and an ODBC alias to SQL 6.0.
With the native drivers, I get a 'Table is not indexed'
message.  With ODBC, I get a 'Dictionary is corrupt' message.

Any similar or different experiences?

Thanks,

Eric Slippern
UDP Consulting Services

 
Shaun Arunde

Delphi Developer
Tue, 22 Sep 1998 03:00:00 GMT

Re:Creating Data Dictionary on MS SQL Server 6.0


Quote
In article <4jsgsv$...@dns.ogitel.net>, Eric Slippern <er...@udp.com> wrote:
>Has anyone had any success creating a Delphi 2.0 data
>dictionary on an MS SQL Server 6.0 database?

>I'm using the Dictionary/New... option from SQL Explorer. I've
>tried it using both a native SQL and an ODBC alias to SQL 6.0.
>With the native drivers, I get a 'Table is not indexed'
>message.  With ODBC, I get a 'Dictionary is corrupt' message.

>Any similar or different experiences?

>Thanks,

>Eric Slippern
>UDP Consulting Services

I have successfully created a data dict on MS Sql Server 6.0.
Don't try and create a Data Dict as 'sa', this does not work.
There are plenty of other problem with the Explorer and MS SQL.
There are lots of little things that don't work.

Give youself 'grant all to xxx' in your database, create a
new BDE database connection in the explorer, and give it a go.

Let me know how you work out.

shaun

Other Threads

1. I can not store Blob data more than 32KB to MS SQL SERVER 6.0

2. Data Dictionary In Delphi 2.0 w MS SQL

3. Can't create data dictionary on Oracle server

4. SQL Server 6.5 and Data Dictionary

5. MS SQL 6.0/Create Database?????

6. Delphi, Banyan, Windows 95, and MS SQL Server 6.0

7. Help: Delphi 16 bit client to MS SQL Server 6.0

8. MS SQL Server 6.0

9. Problem with MS SQL Server 6.0/TTable/Sybase driver

10. MS SQL Server 6.0 Extended Stored Procedures