Does SDAC support SQL Server Express?

jaska45 · Post by **jaska45** » Fri 23 Dec 2005 03:58

I can not connect to my SQL Server Express database. Server dropdown in TMSConnection does not contain any item.
Best regards,
Jaakko

jaska45 · Post by **jaska45** » Fri 23 Dec 2005 06:15

I write the name of the server in the Server field and now it works.

I have another question. In MySQL components there is TMyTable.IndexDefs property that can be used to get the indexes of the table.

However in SDAC there is no such function. How do I find out the indexes of the table.

Best regards,
Jaakko

Ikar · Post by **Ikar** » Fri 23 Dec 2005 10:49

Use TMSMetaData to perform this operation.