Results 1 to 3 of 3

Thread: Error in VB Script connection with Oracle 11g 64 bit

  1. Feb 15th, 2012, 09:18 AM #1
    anjani_02oct
    anjani_02oct is offline

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    1

    Error in VB Script connection with Oracle 11g 64 bit

    Hi All,

    I am trying to connect oracle 11g with VBscript for windows 64 bit.But while connecting with code it is throwing me error as "Provider not specified" the same code in windows 32 bit edition works fine.I have created DNS and trying to connect through that the DSN is successfully getting connected.

    Below if the code that iam using :

    Set objcon=createobject("ADODB.Connection")
    objcon.Open "DSN=MYDSN;User Id=Myid;Password=Mypassword"



    Please help,

    Thanks and Regards,
    Anjani Kumar Deo.
    Reply With Quote Reply With Quote
  2. Feb 15th, 2012, 10:02 AM #2
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Error in VB Script connection with Oracle 11g 64 bit

    Welcome to VBForums

    Thread moved from the 'VB6 and Earlier' forum to the 'VBScript' forum
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  3. Feb 16th, 2012, 05:15 PM #3
    Darren M.
    Darren M. is offline
    Addicted Member Darren M.'s Avatar
    Join Date
    Nov 2005
    Location
    D/FW
    Posts
    200

    Re: Error in VB Script connection with Oracle 11g 64 bit

    Are you sure the 32 bit ODBC drivers are loaded? I've never hit Oracle via VBS but in other environments the 32 ODBC admin was required.

    My attempt at a thought provoking sig.
    * Remove ALL assumptions. You'll probably find your problem.
    * New to the forums? READ THIS! The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft
    * Learn how to fish!
    * Subscribing to every thread I post in is like having a book mark in my mind. Every now and then I get to review a fond memory.
    * If you find my post helpful do me a 15 second favor and RATE it. (Rate Post. Over there <----)
    * Please mark all resolved threads as such. It makes searching for fixes SO much easier!
    * Have fun. We aren't on this rock for long, enjoy it.
    * Sometimes I'm wrong. When I am I admit it. Never am I malicious. If reading my post and you think otherwise, then it MAY be tongue in cheek. Read it again.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width