Results 1 to 2 of 2

Thread: Open connection with Oracle SQL server HELP!!

  1. #1
    Phil Guest

    Open connection with Oracle SQL server HELP!!

    I'm trying to connect to a MS SQL DB and I'hve got a lot of problems when I open the connection with the DB with both DB.
    I need the complete code to do this . Is there anybody how can help me??

    Thanks a lot and sorry for my English



  2. #2
    Frank Guest

    Open connection with Oracle SQL server HELP!! (reply)

    Phil.
    The following are two files to connect to ORACLE using Client and also Server.

    -------- Client ---------
    <%
    Response.buffer = True
    Set X= Server.CreateObject(&#34;AspDB.Pro&#34

    X.dbQuickProps=&#34;(/,)1/DSN=oracle_Client; uid=demo; pwd=demo/price/dual-horiz/4,auto///ORACLE,client&#34;
    X.dbEditParams = &#34;TableName=DEMO.CUSTOMER, TableTag=border=1, BookMarkFlds=0&#34;
    X.dbNavigationItem = &#34;Top, Prev, Next, Bottom, Filter, download, Edit&#34;
    X.dbnavigation = &#34;both&#34;
    &#39;X.dbDebug=true &#39;turn on when have problem
    X.aspdbPro
    %>

    ---------- Server ---------

    <%
    Response.buffer = True
    Set X= Server.CreateObject(&#34;AspDB.Pro&#34
    X.dbQuickProps=&#34;(/,)1/DSN=demo; uid=demo; pwd=demo/sales/dual-horiz/4,auto///ORACLE,server&#34;

    X.dbEditParams = &#34;TableName=DEMO.CUSTOMER, TableTag=border=1, BookMarkFlds=0&#34;
    X.dbNavigationItem = &#34;Top, Prev, Next, Bottom, Filter, Edit&#34;
    X.dbnavigation = &#34;both&#34;
    &#39;X.dbDebug=true &#39;turn on when have problem
    X.aspdbPro
    %>

    Frank


    On 12/24/98 7:59:04 AM, Phil wrote:
    > I&#39;m trying to connect to a MS SQL DB and I&#39;hve got a lot of
    > problems when I open the connection with the DB with both DB.
    I need the
    > complete code to do this . Is there anybody how can help me??

    Thanks a
    > lot and sorry for my English



Posting Permissions

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