Why does connection connect to Master instead of my database?

This is a multi-part message in MIME format.

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

No matter what combination I try, unless we issue an "Execute immediate =
'use PBTestCompat'" after the connection is made, the connection is made =
to the Master database instead of to the PBTestCompat database.

1. In this scenario the connection is made to the "Master" database =
instead of PBTestCompat. To get around this we issue "Execute immediate =
'use PBTestCompat' using sqlca" Why is it not connecting to =
PBTestCompat?

ls_dbparm =3D "Provider=3D'SQLNCLI10',DATABASE=3D'" + "'PBTestCompat'" + =
& ",TrimSpaces=3D1,Providerstring=3D'MARS Connection=3DFALSE;' "

sqlca.autocommit =3D false

sqlca.LOGID =3D "MyID"

sqlca.logpass =3D "MyPassword"

sqlca.servername =3D "AXDevDB\SQL2005"

sqlca.dbparm =3D ls_dbparm

sqlca.dbms =3D "TRACE SNC"

CONNECT USING sqlca;

//li_return =3D dw_1.SetTransObject(sqlca)

li_return =3D dw_1.SetTrans(sqlca)



2. Database is moved from dbparm to sqlca.database. In this scenario, =
too, the connection is made to Master instead of PBTestCompat.

ls_dbparm =3D "Provider=3D'SQLNCLI10'" + &

",TrimSpaces=3D1,Providerstring=3D'MARS Connection=3DFALSE;' "

sqlca.autocommit =3D false

sqlca.LOGID =3D "MyID"

sqlca.logpass =3D "MyPassword"

sqlca.servername =3D "AXDevDB\SQL2005"

sqlca.dbparm =3D ls_dbparm

sqlca.dbms =3D "TRACE SNC"

sqlca.database =3D "PBTestCompat"

CONNECT USING sqlca;

li_return =3D dw_1.SetTrans(sqlca)



3. If I put the database name in both places, I still get the same =
result.

------=_NextPart_000_006D_01CADAEF.B8BC7D80
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16945" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>
<P><FONT face=3DArial size=3D2>No matter what combination I try, unless =
we issue an=20
"Execute immediate 'use PBTestCompat'" after the connection is made, the =

connection is made to the Master database instead of to the PBTestCompat =

database.</FONT></P>
<P><FONT face=3DArial size=3D2>1. In this scenario the connection is =
made to the=20
"Master" database instead of PBTestCompat. To get around this we issue =
"Execute=20
immediate 'use PBTestCompat' using sqlca" Why is it not connecting to=20
PBTestCompat?</FONT></P>
<P><FONT face=3DArial size=3D2>ls_dbparm =3D =
"Provider=3D'SQLNCLI10',DATABASE=3D'" +=20
"'PBTestCompat'" + &amp; ",TrimSpaces=3D1,Providerstring=3D'MARS =
Connection=3DFALSE;'=20
"</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.autocommit =3D false</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.LOGID =3D "MyID"</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.logpass =3D "MyPassword"</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.servername =3D =
"AXDevDB\SQL2005"</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.dbparm =3D ls_dbparm</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.dbms =3D "TRACE SNC"</FONT></P>
<P><FONT face=3DArial size=3D2>CONNECT USING sqlca;</FONT></P>
<P><FONT face=3DArial size=3D2>//li_return =3D =
dw_1.SetTransObject(sqlca)</FONT></P>
<P><FONT face=3DArial size=3D2>li_return =3D =
dw_1.SetTrans(sqlca)</FONT></P>
<P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
<P><FONT face=3DArial size=3D2>2. Database is moved from dbparm to =
sqlca.database.=20
In this scenario, too, the connection is made to Master instead of=20
PBTestCompat.</FONT></P>
<P><FONT face=3DArial size=3D2>ls_dbparm =3D "Provider=3D'SQLNCLI10'" + =
&amp;</FONT></P>
<P><FONT face=3DArial size=3D2>",TrimSpaces=3D1,Providerstring=3D'MARS=20
Connection=3DFALSE;' "</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.autocommit =3D false</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.LOGID =3D "MyID"</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.logpass =3D "MyPassword"</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.servername =3D =
"AXDevDB\SQL2005"</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.dbparm =3D ls_dbparm</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.dbms =3D "TRACE SNC"</FONT></P>
<P><FONT face=3DArial size=3D2>sqlca.database =3D =
"PBTestCompat"</FONT></P>
<P><FONT face=3DArial size=3D2>CONNECT USING sqlca;</FONT></P>
<P><FONT face=3DArial size=3D2>li_return =3D =
dw_1.SetTrans(sqlca)</FONT></P>
<P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
<P><FONT face=3DArial size=3D2>3. If I put the database name in both =
places, I still=20
get the same result.</FONT></P></DIV></BODY></HTML>

------=_NextPart_000_006D_01CADAEF.B8BC7D80--

0
Laurel
4/13/2010 1:57:27 PM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

3 Replies
708 Views

Similar Articles

[PageSpeed] 15

This is a multi-part message in MIME format.

------=_NextPart_000_0020_01CADC82.7E2F51D0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Try putting DATABASE=3D in the PROVIDERSTRING.

  "Laurel" <FakeMail@Hotmail.com> wrote in message =
news:4bc47847@forums-1-dub...
  No matter what combination I try, unless we issue an "Execute =
immediate 'use PBTestCompat'" after the connection is made, the =
connection is made to the Master database instead of to the PBTestCompat =
database.

  1. In this scenario the connection is made to the "Master" database =
instead of PBTestCompat. To get around this we issue "Execute immediate =
'use PBTestCompat' using sqlca" Why is it not connecting to =
PBTestCompat?

  ls_dbparm =3D "Provider=3D'SQLNCLI10',DATABASE=3D'" + "'PBTestCompat'" =
+ & ",TrimSpaces=3D1,Providerstring=3D'MARS Connection=3DFALSE;' "

  sqlca.autocommit =3D false

  sqlca.LOGID =3D "MyID"

  sqlca.logpass =3D "MyPassword"

  sqlca.servername =3D "AXDevDB\SQL2005"

  sqlca.dbparm =3D ls_dbparm

  sqlca.dbms =3D "TRACE SNC"

  CONNECT USING sqlca;

  //li_return =3D dw_1.SetTransObject(sqlca)

  li_return =3D dw_1.SetTrans(sqlca)



  2. Database is moved from dbparm to sqlca.database. In this scenario, =
too, the connection is made to Master instead of PBTestCompat.

  ls_dbparm =3D "Provider=3D'SQLNCLI10'" + &

  ",TrimSpaces=3D1,Providerstring=3D'MARS Connection=3DFALSE;' "

  sqlca.autocommit =3D false

  sqlca.LOGID =3D "MyID"

  sqlca.logpass =3D "MyPassword"

  sqlca.servername =3D "AXDevDB\SQL2005"

  sqlca.dbparm =3D ls_dbparm

  sqlca.dbms =3D "TRACE SNC"

  sqlca.database =3D "PBTestCompat"

  CONNECT USING sqlca;

  li_return =3D dw_1.SetTrans(sqlca)



  3. If I put the database name in both places, I still get the same =
result.

------=_NextPart_000_0020_01CADC82.7E2F51D0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.5897" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Try putting DATABASE=3D in the=20
PROVIDERSTRING.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Laurel" &lt;<A=20
  href=3D"mailto:FakeMail@Hotmail.com">FakeMail@Hotmail.com</A>&gt; =
wrote in=20
  message <A=20
  =
href=3D"news:4bc47847@forums-1-dub">news:4bc47847@forums-1-dub</A>...</DI=
V>
  <DIV>
  <P><FONT face=3DArial size=3D2>No matter what combination I try, =
unless we issue=20
  an "Execute immediate 'use PBTestCompat'" after the connection is =
made, the=20
  connection is made to the Master database instead of to the =
PBTestCompat=20
  database.</FONT></P>
  <P><FONT face=3DArial size=3D2>1. In this scenario the connection is =
made to the=20
  "Master" database instead of PBTestCompat. To get around this we issue =

  "Execute immediate 'use PBTestCompat' using sqlca" Why is it not =
connecting to=20
  PBTestCompat?</FONT></P>
  <P><FONT face=3DArial size=3D2>ls_dbparm =3D =
"Provider=3D'SQLNCLI10',DATABASE=3D'" +=20
  "'PBTestCompat'" + &amp; ",TrimSpaces=3D1,Providerstring=3D'MARS=20
  Connection=3DFALSE;' "</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.autocommit =3D false</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.LOGID =3D "MyID"</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.logpass =3D =
"MyPassword"</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.servername =3D =
"AXDevDB\SQL2005"</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.dbparm =3D ls_dbparm</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.dbms =3D "TRACE SNC"</FONT></P>
  <P><FONT face=3DArial size=3D2>CONNECT USING sqlca;</FONT></P>
  <P><FONT face=3DArial size=3D2>//li_return =3D =
dw_1.SetTransObject(sqlca)</FONT></P>
  <P><FONT face=3DArial size=3D2>li_return =3D =
dw_1.SetTrans(sqlca)</FONT></P>
  <P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
  <P><FONT face=3DArial size=3D2>2. Database is moved from dbparm to =
sqlca.database.=20
  In this scenario, too, the connection is made to Master instead of=20
  PBTestCompat.</FONT></P>
  <P><FONT face=3DArial size=3D2>ls_dbparm =3D "Provider=3D'SQLNCLI10'" =
+=20
  &amp;</FONT></P>
  <P><FONT face=3DArial size=3D2>",TrimSpaces=3D1,Providerstring=3D'MARS =

  Connection=3DFALSE;' "</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.autocommit =3D false</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.LOGID =3D "MyID"</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.logpass =3D =
"MyPassword"</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.servername =3D =
"AXDevDB\SQL2005"</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.dbparm =3D ls_dbparm</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.dbms =3D "TRACE SNC"</FONT></P>
  <P><FONT face=3DArial size=3D2>sqlca.database =3D =
"PBTestCompat"</FONT></P>
  <P><FONT face=3DArial size=3D2>CONNECT USING sqlca;</FONT></P>
  <P><FONT face=3DArial size=3D2>li_return =3D =
dw_1.SetTrans(sqlca)</FONT></P>
  <P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
  <P><FONT face=3DArial size=3D2>3. If I put the database name in both =
places, I=20
  still get the same result.</FONT></P></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0020_01CADC82.7E2F51D0--

0
Roland
4/15/2010 2:00:32 PM
This is a multi-part message in MIME format.

------=_NextPart_000_000D_01CADE7D.0508EDF0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm not sure I understand.  Is there a "ProviderString" that's different =
than "Provider"?  And, if "provider" what's the sytnax, since it's =
already equal to "SQLNCLI10"?  Can you just show me what you're =
suggesting?

  "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com> wrote in =
message news:4bc71c00$1@forums-1-dub...
  Try putting DATABASE=3D in the PROVIDERSTRING.

    "Laurel" <FakeMail@Hotmail.com> wrote in message =
news:4bc47847@forums-1-dub...
    No matter what combination I try, unless we issue an "Execute =
immediate 'use PBTestCompat'" after the connection is made, the =
connection is made to the Master database instead of to the PBTestCompat =
database.

    1. In this scenario the connection is made to the "Master" database =
instead of PBTestCompat. To get around this we issue "Execute immediate =
'use PBTestCompat' using sqlca" Why is it not connecting to =
PBTestCompat?

    ls_dbparm =3D "Provider=3D'SQLNCLI10',DATABASE=3D'" + =
"'PBTestCompat'" + & ",TrimSpaces=3D1,Providerstring=3D'MARS =
Connection=3DFALSE;' "

    sqlca.autocommit =3D false

    sqlca.LOGID =3D "MyID"

    sqlca.logpass =3D "MyPassword"

    sqlca.servername =3D "AXDevDB\SQL2005"

    sqlca.dbparm =3D ls_dbparm

    sqlca.dbms =3D "TRACE SNC"

    CONNECT USING sqlca;

    //li_return =3D dw_1.SetTransObject(sqlca)

    li_return =3D dw_1.SetTrans(sqlca)



    2. Database is moved from dbparm to sqlca.database. In this =
scenario, too, the connection is made to Master instead of PBTestCompat.

    ls_dbparm =3D "Provider=3D'SQLNCLI10'" + &

    ",TrimSpaces=3D1,Providerstring=3D'MARS Connection=3DFALSE;' "

    sqlca.autocommit =3D false

    sqlca.LOGID =3D "MyID"

    sqlca.logpass =3D "MyPassword"

    sqlca.servername =3D "AXDevDB\SQL2005"

    sqlca.dbparm =3D ls_dbparm

    sqlca.dbms =3D "TRACE SNC"

    sqlca.database =3D "PBTestCompat"

    CONNECT USING sqlca;

    li_return =3D dw_1.SetTrans(sqlca)



    3. If I put the database name in both places, I still get the same =
result.

------=_NextPart_000_000D_01CADE7D.0508EDF0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16945" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<P><FONT face=3DArial size=3D2>I'm not sure I understand.&nbsp; Is there =
a=20
"ProviderString" that's different than "Provider"?&nbsp; And, if =
"provider"=20
what's the sytnax, since it's already equal to "SQLNCLI10"?&nbsp; Can =
you just=20
show me what you're suggesting?</FONT></P></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Roland Smith [TeamSybase]" &lt;rsmith_at_trusthss_dot_com&gt; =
wrote in=20
  message <A=20
  =
href=3D"news:4bc71c00$1@forums-1-dub">news:4bc71c00$1@forums-1-dub</A>...=
</DIV>
  <DIV><FONT face=3DArial size=3D2>Try putting DATABASE=3D in the=20
  PROVIDERSTRING.</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <BLOCKQUOTE dir=3Dltr=20
  style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    <DIV>"Laurel" &lt;<A=20
    href=3D"mailto:FakeMail@Hotmail.com">FakeMail@Hotmail.com</A>&gt; =
wrote in=20
    message <A=20
    =
href=3D"news:4bc47847@forums-1-dub">news:4bc47847@forums-1-dub</A>...</DI=
V>
    <DIV>
    <P><FONT face=3DArial size=3D2>No matter what combination I try, =
unless we issue=20
    an "Execute immediate 'use PBTestCompat'" after the connection is =
made, the=20
    connection is made to the Master database instead of to the =
PBTestCompat=20
    database.</FONT></P>
    <P><FONT face=3DArial size=3D2>1. In this scenario the connection is =
made to the=20
    "Master" database instead of PBTestCompat. To get around this we =
issue=20
    "Execute immediate 'use PBTestCompat' using sqlca" Why is it not =
connecting=20
    to PBTestCompat?</FONT></P>
    <P><FONT face=3DArial size=3D2>ls_dbparm =3D =
"Provider=3D'SQLNCLI10',DATABASE=3D'" +=20
    "'PBTestCompat'" + &amp; ",TrimSpaces=3D1,Providerstring=3D'MARS=20
    Connection=3DFALSE;' "</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.autocommit =3D false</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.LOGID =3D "MyID"</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.logpass =3D =
"MyPassword"</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.servername =3D =
"AXDevDB\SQL2005"</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.dbparm =3D ls_dbparm</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.dbms =3D "TRACE SNC"</FONT></P>
    <P><FONT face=3DArial size=3D2>CONNECT USING sqlca;</FONT></P>
    <P><FONT face=3DArial size=3D2>//li_return =3D=20
    dw_1.SetTransObject(sqlca)</FONT></P>
    <P><FONT face=3DArial size=3D2>li_return =3D =
dw_1.SetTrans(sqlca)</FONT></P>
    <P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
    <P><FONT face=3DArial size=3D2>2. Database is moved from dbparm to=20
    sqlca.database. In this scenario, too, the connection is made to =
Master=20
    instead of PBTestCompat.</FONT></P>
    <P><FONT face=3DArial size=3D2>ls_dbparm =3D =
"Provider=3D'SQLNCLI10'" +=20
    &amp;</FONT></P>
    <P><FONT face=3DArial =
size=3D2>",TrimSpaces=3D1,Providerstring=3D'MARS=20
    Connection=3DFALSE;' "</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.autocommit =3D false</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.LOGID =3D "MyID"</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.logpass =3D =
"MyPassword"</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.servername =3D =
"AXDevDB\SQL2005"</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.dbparm =3D ls_dbparm</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.dbms =3D "TRACE SNC"</FONT></P>
    <P><FONT face=3DArial size=3D2>sqlca.database =3D =
"PBTestCompat"</FONT></P>
    <P><FONT face=3DArial size=3D2>CONNECT USING sqlca;</FONT></P>
    <P><FONT face=3DArial size=3D2>li_return =3D =
dw_1.SetTrans(sqlca)</FONT></P>
    <P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
    <P><FONT face=3DArial size=3D2>3. If I put the database name in both =
places, I=20
    still get the same=20
result.</FONT></P></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_000D_01CADE7D.0508EDF0--

0
Laurel
4/18/2010 2:26:22 AM
This is a multi-part message in MIME format.

------=_NextPart_000_0030_01CADEE0.4894EAC0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Go to connections menu in PB IDE, create a connection using the GUI and =
then copy the pb connection code from last tab.
  "Laurel" <FakeMail@Hotmail.com> wrote in message =
news:4bca6dce$1@forums-1-dub...
  I'm not sure I understand.  Is there a "ProviderString" that's =
different than "Provider"?  And, if "provider" what's the sytnax, since =
it's already equal to "SQLNCLI10"?  Can you just show me what you're =
suggesting?

    "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com> wrote in =
message news:4bc71c00$1@forums-1-dub...
    Try putting DATABASE=3D in the PROVIDERSTRING.

      "Laurel" <FakeMail@Hotmail.com> wrote in message =
news:4bc47847@forums-1-dub...
      No matter what combination I try, unless we issue an "Execute =
immediate 'use PBTestCompat'" after the connection is made, the =
connection is made to the Master database instead of to the PBTestCompat =
database.

      1. In this scenario the connection is made to the "Master" =
database instead of PBTestCompat. To get around this we issue "Execute =
immediate 'use PBTestCompat' using sqlca" Why is it not connecting to =
PBTestCompat?

      ls_dbparm =3D "Provider=3D'SQLNCLI10',DATABASE=3D'" + =
"'PBTestCompat'" + & ",TrimSpaces=3D1,Providerstring=3D'MARS =
Connection=3DFALSE;' "

      sqlca.autocommit =3D false

      sqlca.LOGID =3D "MyID"

      sqlca.logpass =3D "MyPassword"

      sqlca.servername =3D "AXDevDB\SQL2005"

      sqlca.dbparm =3D ls_dbparm

      sqlca.dbms =3D "TRACE SNC"

      CONNECT USING sqlca;

      //li_return =3D dw_1.SetTransObject(sqlca)

      li_return =3D dw_1.SetTrans(sqlca)



      2. Database is moved from dbparm to sqlca.database. In this =
scenario, too, the connection is made to Master instead of PBTestCompat.

      ls_dbparm =3D "Provider=3D'SQLNCLI10'" + &

      ",TrimSpaces=3D1,Providerstring=3D'MARS Connection=3DFALSE;' "

      sqlca.autocommit =3D false

      sqlca.LOGID =3D "MyID"

      sqlca.logpass =3D "MyPassword"

      sqlca.servername =3D "AXDevDB\SQL2005"

      sqlca.dbparm =3D ls_dbparm

      sqlca.dbms =3D "TRACE SNC"

      sqlca.database =3D "PBTestCompat"

      CONNECT USING sqlca;

      li_return =3D dw_1.SetTrans(sqlca)



      3. If I put the database name in both places, I still get the same =
result.

------=_NextPart_000_0030_01CADEE0.4894EAC0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16535">
<STYLE></STYLE>
</HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 bgColor=3D#ffffff=20
CanvasTabStop=3D"true" name=3D"Compose message area">
<DIV><FONT size=3D2 face=3DArial>Go to connections menu in PB IDE, =
create a=20
connection using the GUI and then copy the pb connection code from last=20
tab.</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"=20
dir=3Dltr>
  <DIV>"Laurel" &lt;<A=20
  href=3D"mailto:FakeMail@Hotmail.com">FakeMail@Hotmail.com</A>&gt; =
wrote in=20
  message <A=20
  =
href=3D"news:4bca6dce$1@forums-1-dub">news:4bca6dce$1@forums-1-dub</A>...=
</DIV>
  <DIV>
  <P><FONT size=3D2 face=3DArial>I'm not sure I understand.&nbsp; Is =
there a=20
  "ProviderString" that's different than "Provider"?&nbsp; And, if =
"provider"=20
  what's the sytnax, since it's already equal to "SQLNCLI10"?&nbsp; Can =
you just=20
  show me what you're suggesting?</FONT></P></DIV>
  <BLOCKQUOTE=20
  style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"=20
  dir=3Dltr>
    <DIV>"Roland Smith [TeamSybase]" &lt;rsmith_at_trusthss_dot_com&gt; =
wrote in=20
    message <A=20
    =
href=3D"news:4bc71c00$1@forums-1-dub">news:4bc71c00$1@forums-1-dub</A>...=
</DIV>
    <DIV><FONT size=3D2 face=3DArial>Try putting DATABASE=3D in the=20
    PROVIDERSTRING.</FONT></DIV>
    <DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
    <BLOCKQUOTE=20
    style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"=20
    dir=3Dltr>
      <DIV>"Laurel" &lt;<A=20
      title=3D"mailto:FakeMail@Hotmail.com&#10;CTRL + Click to follow =
link"=20
      href=3D"mailto:FakeMail@Hotmail.com">FakeMail@Hotmail.com</A>&gt; =
wrote in=20
      message <A=20
      =
href=3D"news:4bc47847@forums-1-dub">news:4bc47847@forums-1-dub</A>...</DI=
V>
      <DIV>
      <P><FONT size=3D2 face=3DArial>No matter what combination I try, =
unless we=20
      issue an "Execute immediate 'use PBTestCompat'" after the =
connection is=20
      made, the connection is made to the Master database instead of to =
the=20
      PBTestCompat database.</FONT></P>
      <P><FONT size=3D2 face=3DArial>1. In this scenario the connection =
is made to=20
      the "Master" database instead of PBTestCompat. To get around this =
we issue=20
      "Execute immediate 'use PBTestCompat' using sqlca" Why is it not=20
      connecting to PBTestCompat?</FONT></P>
      <P><FONT size=3D2 face=3DArial>ls_dbparm =3D =
"Provider=3D'SQLNCLI10',DATABASE=3D'" +=20
      "'PBTestCompat'" + &amp; ",TrimSpaces=3D1,Providerstring=3D'MARS=20
      Connection=3DFALSE;' "</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.autocommit =3D =
false</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.LOGID =3D "MyID"</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.logpass =3D =
"MyPassword"</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.servername =3D =
"AXDevDB\SQL2005"</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.dbparm =3D =
ls_dbparm</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.dbms =3D "TRACE =
SNC"</FONT></P>
      <P><FONT size=3D2 face=3DArial>CONNECT USING sqlca;</FONT></P>
      <P><FONT size=3D2 face=3DArial>//li_return =3D=20
      dw_1.SetTransObject(sqlca)</FONT></P>
      <P><FONT size=3D2 face=3DArial>li_return =3D =
dw_1.SetTrans(sqlca)</FONT></P>
      <P><FONT size=3D2 face=3DArial></FONT>&nbsp;</P>
      <P><FONT size=3D2 face=3DArial>2. Database is moved from dbparm to =

      sqlca.database. In this scenario, too, the connection is made to =
Master=20
      instead of PBTestCompat.</FONT></P>
      <P><FONT size=3D2 face=3DArial>ls_dbparm =3D =
"Provider=3D'SQLNCLI10'" +=20
      &amp;</FONT></P>
      <P><FONT size=3D2 =
face=3DArial>",TrimSpaces=3D1,Providerstring=3D'MARS=20
      Connection=3DFALSE;' "</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.autocommit =3D =
false</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.LOGID =3D "MyID"</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.logpass =3D =
"MyPassword"</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.servername =3D =
"AXDevDB\SQL2005"</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.dbparm =3D =
ls_dbparm</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.dbms =3D "TRACE =
SNC"</FONT></P>
      <P><FONT size=3D2 face=3DArial>sqlca.database =3D =
"PBTestCompat"</FONT></P>
      <P><FONT size=3D2 face=3DArial>CONNECT USING sqlca;</FONT></P>
      <P><FONT size=3D2 face=3DArial>li_return =3D =
dw_1.SetTrans(sqlca)</FONT></P>
      <P><FONT size=3D2 face=3DArial></FONT>&nbsp;</P>
      <P><FONT size=3D2 face=3DArial>3. If I put the database name in =
both places, I=20
      still get the same=20
result.</FONT></P></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></H=
TML>

------=_NextPart_000_0030_01CADEE0.4894EAC0--

0
Tyler
4/18/2010 3:17:01 PM
Reply:

Similar Artilces:

Database Connection???How to connect a Database in an other server?
How to connect a Database(.mdb) in an other server? Can I use the connection string like below? mycon.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=http://www.****.com/***/mydb.mdb" You can not. That simple. Access is file based. No a client/server architecture.Thomas TomiczekPowerNodes ApS(Microsoft MVP C#/.NET)---Building a Website? Try the PowerNodes CMS - http://www.powernodes.com/ Correction: you can. Just make sure you can reach the acces db file - through a file share that is bound as drive. Not that you should. Performance will be horrib...

How can I change my connection to a different database...it is not connecting to the database I created.
My data is connected to the ASPNETDB.MDF database. Is this a must that I have it connected to this database or can I have it connected to a database that I created. You can connect to different database such as sql or other access files. All you have to do is to define which connection string to use within your web.config file. If you want to make sure that your database is prepared to be used, use features such as ASPNET_REGSQL.EXE at VS Command Prompt. Hope this helps. Jae.jae.lee@jaeleeandco.com I'm in the Army...here in Georgia. Is it cold there.. Hi Jae,    &nb...

Database Explorer not connecting in VWD 2005 express client 'connect to database'
I see red X over the database ASPNETDB.MDF. I went through a config. problem with sql server 2008 express client decided to retun to my original SQL server 2005 express client. This is now configured and I connect to my remote SQL server 2005 account. But I use to be able to connect also with my VWD 2005 express client and I could see all my object files, tables logins etc. it was great, now I can't connect I get this error when I choose data source>MS SQL server/.net framework data provider for SQL server>server name>authority>database name...

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.
I'm not sure what this error is referring to. I've built a report and it runs in the IDE in preview mode, however when I try to deploy it, I get this error message.   Thanks. Doug   ...

How do connect your page to your database connection?
How do connect your page to your database connection? I have created a page, default.aspx. I have created a database connection to an Access database. I see the connection in the little database window on the right hand side of WebMatrix--okay, now how to I get my page, default.aspx, to connect to the connection? Web.config file? If so, how do I config the config file using the WYSIWYG interface of WebMatirx? Or if there is another way to set this up? I know how to do this in Dreamweaver MX, but WebMatrix is still baffling to me. How much of it truly is a WYSIWYG and how much...

Wifi connection and database connection
What is the solution to recovering the connection to a remote database (i.e. in a wifi environment due to loss of coverage or in case the machine goes into standby)? Could we check for specific SQLDBCodes? Do we need to destroy the SQLCA or is there a workaround? ...

How to create a single Oracle Database connection method or function to be used on or by all classes and pages that want to connect to the database?
 How to create a single Oracle Database connection method or function  to be used on or by all classes and pages that want to connect to the database? How can I create one method or function in csharp to be used on all pages or classes when conenction to the database? Please give an example.I have database connections which I am using on each and very page or classes, but I can I put in one page then I just start  calling it?Database connection I am using:   OracleConnection dbconnection;    this.dbconnection = new System.Data.OracleClient.OracleConnec...

which database does the database refer in "Not connected to a database" of the second paragraph
I. 01/01 02:30:40. Synchronization Started I. 01/01 02:30:40. Adaptive Server Anywhere MobiLink Synchronization Version 8.0.2.4258 I. 01/01 02:30:40. I. 01/01 02:30:40. Copyright _ 1989-2002 Sybase, Inc. Portions Copyright _ 2002, iAnywhere Solutions, Inc. I. 01/01 02:30:40. All rights reserved. All unpublished rights reserved. I. 01/01 02:30:40. I. 01/01 02:30:40. This software contains confidential and trade secret information of I. 01/01 02:30:40. iAnywhere Solutions, Inc. Use, duplication or disclosure of the software and documentation I. ...

"Alias is not currently opened. Database server rejected connection. Database server connection limited exceeded."
Hello Sybase Users, Could anyone tell me what's the cause of this error message "alias is not currently opened. Database server rejected connection. Database server connection limited exceeded"? Actually, the sybase server is running and the user is remotely accessing the server. It was when the user used the Interactive SQL remotely that this error came out. Then, he also tried to use the Interactive SQL on the server machine but there was no error encountered. It also came out ONCE when 10 users were simultaneously logging on the system application. What's...

"Alias is not currently opened. Database server rejected connection. Database server connection limited exceeded." error message
Hello Sybase User Experts, I like to find out the cause of this error message "Alias is not currently opened. Database server rejected connection. Database server connection limited exceeded." Do you have any idea about this? What is the cause and how to solve this problem?! Your answer or idea to this error message will be a great help to me. Thank you in advance. Regards, Beverly Beverly, First of all, what database server are you using? And how are you connecting to it? -- Regards, Millard[TeamSybase] <Beverly> wrote in message news:3f7932b1.1356....

CREATE DATABASE permission denied in database 'master'. Error while connecting to SQL Express edition
CREATE DATABASE permission denied in database 'master'.An attempt to attach an auto-named database for file C:\Domains\premrana.com\wwwroot\App_Data\personal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. This is the error we get while connecting to the SQLExpress server. Any suggestions, hint, etc. would helpThanksSnehal Rana  The error message is saying that the database is already attached.  Since you are using iis instead of the built in web host you are going to have to go into IIS manager an...

powerbuilder database connections
When I connect to any database using Powerbuilder 4.0 I get the following error messages: unable to start, server not found Could not load interface for specified database unable to load Powersoft ODBC DLL Please help Stephane Stephane, The system can't find PBODB040.DLL. HTH, Carson ---------------------------------------------------------------------------- Carson Hager Dynamic Data Solutions Team Powersoft http://www.dyn-data.com chager@dyn-data.com ******** Are You Ready for the Web ******** ...

connecting to database from powerbuilder
Hello, Is there any way to connect to database from powerbuilder other than transaction objects.. Thanks in advance Suby a powerbuilder application needs transaction objects to interact with any dbms. what functionality are you trying to build? sanjiv. <Suby> wrote in message news:42d4b61b.3c60.1681692777@sybase.com... > Hello, > Is there any way to connect to database from powerbuilder > other than transaction objects.. > Thanks in advance > Suby Hi The transaction object is the object to be used to connect to any database? What do you...

powerbuilder database connections
I receive this error message when I try to connect the dbclient. "unable to start, server not found" When I try to connect to any type of database in Powerbuilder, I receive these errors: unable to load Powersoft ODBC DLL could not load interface for specified database Please help Stephane In article <TcVR68XL9GA.205@forums.powersoft.com>, viaust@rmoc.ca says... >> When I try to connect to any type of database in Powerbuilder, I receive >> these errors: >> unable to load Powersoft ODBC DLL >> could not load interface for specified ...

Web resources about - Why does connection connect to Master instead of my database? - sybase.powerbuilder.database

Connection - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

iMedia Connection: Interactive Marketing News, Features, Podcasts and Video - iMediaConnection.com
High-quality data, if not used properly, can still lead marketers to make bad decisions. Consider these common ways that numbers are used to ...

HTTP persistent connection - Wikipedia, the free encyclopedia
... tacked on to an existing protocol. If the browser supports keep-alive, it adds an additional header to the request: Following this, the connection ...

CareerSonar Turns Facebook Friends Into Job Connections
Looking for a job ? Among your Facebook friends lies the potential for employment. CareerSonar , a new service, brings together a person’s connections ...

Ben Garcia gives Penrith Panthers a new French connection
Should he jag a game in the NRL, Ben Garcia will become just the third genuine French import to do so.

Man Charged With Aggravated Arson In Connection To Columbus Warehouse Fire
Police have charged 30-year-old Robin Toms with aggravated arson.

This Is How Facebook Is Working to Improve Experience On Slower Connections
... the globe, that’s not their situation . In recent years, Facebook has paid close attention to its user experience on 2G and other slow connections. ...

Addappt now lets you block contacts and connections
... gives you even more control than before. New features Block a current contact from connecting if they use Addappt down the road Block a connection ...

Facebook becomes more adept at dealing with crappy connections
... to get a decent phone signal to allow you to post a photo of your meal. Joking aside, in countries where people are struggling with 2G connections ...

MIAMI (CBSMiami) – An arrest has been made in connection with the 2014 murder ...
CBS Local MIAMI (CBSMiami) – An arrest has been made in connection with the 2014 murder ... CBS Local Raksin was shot to death walking to ...

Resources last updated: 12/17/2015 3:52:30 PM