This is a multi-part message in MIME format.

------=_NextPart_000_00CC_01C1733B.C0A09A60
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

hi,

    As far as Access is concerned, I have to try. But I can connect 
thro' SQL*Plus.

Thanks,
N.T.GOPALAKRISHNAN
  ----- Original Message -----
  From: Pardee, Roy E
  To: professional vb
  Sent: Wednesday, November 21, 2001 8:48 PM
  Subject: [pro_vb] Re: How to open a connection thro DSN


  Sounds like your DSN is not set up correctly.  If you have Access, can 
you
  link to your database through this DSN? (File -> Get External Data -> 
Link,
  and then choose "ODBC" in the "Files of type:" part of the resulting
  dialog).  Can you connect to the database via SQL*Plus?

  HTH,

  -Roy

  Roy Pardee
  Programmer/Analyst
  SWFPAC Lockheed Martin IT
  Extension 8487

  -----Original Message-----
  From: Gopalakrishnan [mailto:ntg@s...]
  Sent: Tuesday, November 20, 2001 8:20 PM
  To: professional vb
  Subject: [pro_vb] Re: How to open a connection thro DSN


  The error is
  
  "[Microsoft][Microsoft ODBC Driver for Oracle]" - That is all the 
error is
  coming.

  N.T.GOPALAKRISHNAN
  ----- Original Message -----
  From: Kyle Burns
  To: professional vb
  Sent: Tuesday, November 20, 2001 10:34 PM
  Subject: [pro_vb] Re: How to open a connection thro DSN


  "an error" could be just about anything.  Please post the error and we 
can
  provide a useful response.

  
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D
  Kyle M. Burns, MCSD, MCT
  ECommerce Technology Manager
  Centra Credit Union
  kburns@c...

  


  -----Original Message-----
  From: Gopalakrishnan [mailto:ntg@s...]
  Sent: Tuesday, November 20, 2001 1:58 AM
  To: professional vb
  Subject: [pro_vb] Re: How to open a connection thro DSN


  But it gives me an error while connecting, even though I have the DSN
  created. Any thoughts on that, please?

  N.T.GOPALAKRISHNAN
  ----- Original Message -----
  From: Harry Jega Nathan
  To: professional vb
  Sent: Friday, November 16, 2001 7:38 PM
  Subject: [pro_vb] Re: How to open a connection thro DSN


      Dim cnSQL As ADODB.Connection
      Dim rs As ADODB.Recordset
      Dim stSQL As String
    
      Set cnSQL =3D New ADODB.Connection
      Set rs =3D New ADODB.Recordset
     
      With cnSQL
          .Provider =3D "MSDASQL"
          .ConnectionString =3D 
"DSN=3DtheDSN;UID=3DuserID;PWD=3Dpassword"
      End With
     
      cnSQL.Open
     
      stSQL =3D "select * from TabelName"
      rs.Open stSQL, cnSQL
      rs.MoveFirst
  is it enough
  take care
  Harry
  Gopalakrishnan <ntg@s...> wrote:
  hi,

      Can anybody tell me how to open a Connection thro ADO using a DSN?

  thanks,
  N.T.GOPALAKRISHNAN





  Build your own website in minutes and for free at Yahoo! GeoCities.
  --- You are currently subscribed to pro_vb as: ntg@s... To
  unsubscribe send a blank email to $subst('Email.Unsub')