Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1496
  • Last Modified:

How to use VB script to setup an ODBC on remote PC

I have many client computers that I want to setup Microsoft ODBC for Oracle.
It is the System DSN I want to setup.

How can I use a VB script to do that? So that I can distribute the VBS cript to the client PCs and have the ODBC created automatically.

thanks.


0
ezlee
Asked:
ezlee
4 Solutions
 
CarlWarnerCommented:
Are you sure you want to have to do connections with DSN?

You could avoid the hassle by using DSN-less connections to Oracle.

ODBC DSN Less
ODBC Driver for Oracle - from Microsoft
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForOracleFromMicrosoft
0
 
Alan WarrenCommented:
Hi ezlee,

I am all for DSN-Less connections too, but this recently answered question may help you out with your deployment issues.

http://www.experts-exchange.com/Databases/Q_21164337.html

Alan
0
 
pfinchCommented:
Or else if you want to stick to DSN:

      Dim myConnStr
      myConnStr = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=username;password=password;Data Source=biz"
      set dbConn = Server.CreateObject("ADODB.Connection")
      dbConn.open myConnStr

Regards,
Peter
0
 
slightwv (䄆 Netminder) Commented:
I agree with the DSNless suggestions.

Just wanted to add:  the DSN entries are stored in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

Just export the DSN entry you want and on the client, apply the .reg file.

Off the top of my head, I don't know how to apply registry enteries with VBS but I'm sure it can be done.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now