Re: Delphi.net is Beta?

Hi Bob,

"Bob Swart"
Did you try to connect using the regular SqlDataSource? To which SQL
Server database? (did you build the connectionstring yet, or does the
error message come up before you have a chance to do that?)

Yes I used the regular SqlDataSource.
I tried both MSDE2000 and MS SQL EXPRESS getting different error messages.
I tried both Local Authentication and login via "sa" with no luck.
I let the wizard build the connection string and after it when it comes to
"Confgure the Select Statement" stage I get the below errors.
I can see the list of tables in the database but if I choose any of them,
the error message is displayed again.
I tried on two different PCs with one having a fresh installation and fully
updated version of RAD Studio

The automatically generated Connenction String looks like this:
Provider=SQLOLEDB;Data Source=ELITE-PRIME;User ID=sa;Initial
Catalog=ACCESS_MAIN

******Errors******
<SQL EXPRESS ERROR>
Schema could not be retrieved for this table. Please make sure the
connection settings are correct and that the database is online.

Invalid object name 'SYSOBJECTS'.
</SQL EXPRESS ERROR>

<MSDE ERROR>
Schema could not be retrieved for this table. Please make sure the
connection settings are correct and that the database is online.

Invalid object name 'SYSINDEXKEYS'.
Invalid object name 'SYSINDEXES'.
</MSDE ERROR>


.

Relevant Pages

  • Re: Accessing mdb file via VB code
    ... but then I encountered the error message "Unable to find ... installable ISAM" when a connection to my database was attempted on another ... Dim strConn As String ... By using UserID and Password in the connection string one is telling Jet ...
    (microsoft.public.vb.general.discussion)
  • Re: Mailmerge using a secure database
    ... Database does not have a long path name. ... When I tried re-opening my mail merge documents I get an error message ... Do you need or want specifically to connect with ODBC? ... likely to run into problems where Word truncates the connection string ...
    (microsoft.public.word.mailmerge.fields)
  • connecting to mysql using jsp
    ... I am trying to connect to database using jsp and mysql.java1.4.0,mysql5.0. ... type Exception report ... //initializing database connection ... //print error message ...
    (comp.lang.java.databases)
  • DataEnvironment Connection to a remote SQL Server database
    ... I am trying to connect one PC to SQL Server located on another PC ... but am failing with an error message: ... Test connection failed because of an error in initializing provider. ... I am able to connect locally to SQL Server on winxp1 so i know the database ...
    (microsoft.public.vb.database.ado)
  • Re: Delphi.net is Beta?
    ... Invalid object name 'SYSINDEXKEYS'. ... </annoying error message> ... I think the database metadata is provided by the IDE not the framework, ...
    (borland.public.delphi.non-technical)