Re: connect to Oracle database
- From: "Rod Gill" <rod AT project-systems DOT co DOT nz>
- Date: Thu, 14 Dec 2006 20:53:28 +1300
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
.
- References:
- connect to Oracle database
- From: docchang
- connect to Oracle database
- Prev by Date: connect to Oracle database
- Next by Date: remote connection with ssl tunneling
- Previous by thread: connect to Oracle database
- Next by thread: remote connection with ssl tunneling
- Index(es):
Relevant Pages
|