Re: connect to Oracle database



Hi,

Project VBA programming calls are better made in the project.developer
group. In the mean time, search the web for Oracle OLEDB connection string
to create a connection string, then use oledb calls to your Oracle db. You
need to make sure you have the very latest Oracle drivers installed. See
msdn.microsoft.com for sample oledb code to create a recordset and read
data.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com


"docchang" <docchang.2islbj@xxxxxxxxxxxxx> wrote in message
news:docchang.2islbj@xxxxxxxxxxxxxxxx

I have the name of the server, login name & pass, and tables I like to
work with.

How can I make query calls in VBA?

Thanks,

DC


--
docchang
------------------------------------------------------------------------
docchang's Profile: http://forums.techarena.in/member.php?userid=19888
View this thread: http://forums.techarena.in/showthread.php?t=642105

http://forums.techarena.in



.



Relevant Pages

  • Re: My list D2007 annoyances/todos I would like to see resolved in D2008
    ... OnCalcFields event of the TADODataSet seems to lose track when concatenating ... The problem only shows up when using Oracle (OLEDB ... D2007 will mess up my project files uses ...
    (borland.public.delphi.non-technical)
  • Re: OLEDBCommand vs. SQLCommand
    ... You do not *have* to use OleDb for Oracle. ... SQL compliant - assuming that SQL is a general specification, ... Both of the above are considered to be SQL statements and both do the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Can someone please tell me...(maybe Frans Bouma)
    ... Why no vendor independent way to get all tables, views, & stored ... The OleDb info is in the registry and the Oracle info is ... everything it could to have tons of clients shipped with Windows. ...
    (microsoft.public.dotnet.framework.adonet)
  • Object reference error when using OleDbCommand object
    ... The Oracle client version is 8.1.6 and the Oracle DB version ... behavior, String method) ... Extra Information: ... Is this the problem with the OLEDB driver? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Can someone please tell me...(maybe Frans Bouma)
    ... Why no vendor independent way to get all tables, views, & stored ... The OleDb info is in the registry and the Oracle info is ... everything it could to have tons of clients shipped with Windows. ...
    (microsoft.public.dotnet.framework.adonet)