Connect to SQL Server or Oracle vs Access

[James]

Hi all

I was wondering how I can connect a VB program to either SQL Server or to
an Oracle database. I've written several programs that work with and even
create an Access database, and have always used Microsoft's ADO to do so.
I've not seen anything that shows how I can connect to SQL Server or Oracle.
Can I still use ADO?

Thanks

James

[Michael Lee]

James,
You can start by referring to this article in the MS Knowledge Base:
Q176936 - INFO: Visual Basic Accessing an Oracle Database Using ADO
There are numerous other links that should provide a good starting place.

Michael

"James" <james359@shaw.ca> wrote:
>
>Hi all
>
>I was wondering how I can connect a VB program to either SQL Server or to
>an Oracle database. I've written several programs that work with and even
>create an Access database, and have always used Microsoft's ADO to do so.
>I've not seen anything that shows how I can connect to SQL Server or Oracle.
>Can I still use ADO?
>
>Thanks
>
>James

[wilson]

yes. programming oracle with visual basic comes with an extension look for
the documentation of oracle objects. the same thing as with sql server.

"James" <james359@shaw.ca> wrote:
>
>Hi all
>
>I was wondering how I can connect a VB program to either SQL Server or to
>an Oracle database. I've written several programs that work with and even
>create an Access database, and have always used Microsoft's ADO to do so.
>I've not seen anything that shows how I can connect to SQL Server or Oracle.
>Can I still use ADO?
>
>Thanks
>
>James

[Paul Clement]

On 7 Mar 2002 11:23:06 -0800, "James" <james359@shaw.ca> wrote:

¤
¤ Hi all
¤
¤ I was wondering how I can connect a VB program to either SQL Server or to
¤ an Oracle database. I've written several programs that work with and even
¤ create an Access database, and have always used Microsoft's ADO to do so.
¤ I've not seen anything that shows how I can connect to SQL Server or Oracle.
¤ Can I still use ADO?

See the following:

http://www.able-consulting.com/ADO_Conn.htm

In addition, Oracle also requires that client software be installed and configured.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)