Oracle Connection string

Results 1 to 2 of 2

Thread: Oracle Connection string

  1. #1
    nath Guest

    Default Oracle Connection string

    I am using the following connection string inorder to connect to SQL server database. But to connect to Oracle database which part of this string should I change.<BR><BR>strCnn = "Provider=sqloledb;" & _<BR> "Data Source=srv;Initial Catalog=pubs;User Id=sa;Password=; "<BR> Set cnn1 = New ADODB.Connection cnn1.Open strCnn<BR><BR>thank You<BR>nath

  2. #2
    Doug Seven Guest

    Default RE: Oracle Connection string

    &nbsp;<BR>strCnn = "Provider=MSDAORA.1;" & _<BR>"Data Source=srv;User Id=sa;Password=; "<BR>Set cnn1 = New ADODB.Connection cnn1.Open strCnn<BR><BR>Doug Seven<BR>CodeJunkies.Net /<BR><BR>

Posting Permissions

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