Determine DBMS using ADO

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Koen Wed, 23 May 2007 06:49

#180

Author: Koen
Date: Wed, 23 May 2007 06:49

12 lines
1049 bytes

Hi,

I am creating an application comparable to the Borland SQL Explorer, but 
using ADO. The user can add a server by creating a connectionstring. I 
would like to know however which type of database i am connecting to. For 
example MS SQL Server, MySQL, Informix,... Depending on this, I can add 
functionality that is only available for that DBMS.
Is there a way to retrieve this information?

regards,

Koen

Re: Determine DBMS using ADO

#181

Author: Vassiliev V. V.
Date: Wed, 23 May 2007 07:08

25 lines
1983 bytes

Look at Provider in connection string.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Koen" <koen@ha.com> �������/�������� � �������� ���������: 
news:Xns993959C7BFB63koenhacom@207.105.83.66...
> Hi,
>
> I am creating an application comparable to the Borland SQL Explorer, but
> using ADO. The user can add a server by creating a connectionstring. I
> would like to know however which type of database i am connecting to. For
> example MS SQL Server, MySQL, Informix,... Depending on this, I can add
> functionality that is only available for that DBMS.
> Is there a way to retrieve this information?
>
> regards,
>
> Koen

Re: Determine DBMS using ADO

#182

Author: Koen
Date: Wed, 23 May 2007 07:59

13 lines
1090 bytes

If the connection uses odbc, it is impossible to know the dbms via the 
connectionstring. However, I've found a solution by querying the Properties 
of the connection. 

_di_Property_ property;

ADOConnection1->Properties->Get_Item(WideString ("DBMS Version"), 
property);
ADOConnection1->Properties->Get_Item(WideString ("DBMS Name"), property);

regards,

Koen

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads