Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Connect To ASA 9 using OLE DB with PowerBuilder 9

4 posts in ,  Database General Discussion (old) Last posting was on 2009-04-20 16:43:33.0Z
"Carlos" Posted on 2009-04-20 14:17:17.0Z
From: "Carlos" <cadaov AT hotmail DOT com>
Newsgroups: sybase.public.powerbuilder.database,sybase.public.sqlanywhere
Subject: Connect To ASA 9 using OLE DB with PowerBuilder 9
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8064.206
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8064.206
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49ec83ed@forums-1-dub>
Date: 20 Apr 2009 07:17:17 -0700
X-Trace: forums-1-dub 1240237037 10.22.241.152 (20 Apr 2009 07:17:17 -0700)
X-Original-Trace: 20 Apr 2009 07:17:17 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.database:29987 sybase.public.sqlanywhere:276
Article PK: 312203

I'm trying to connect to a database running ASA 9 in a linux pc from
powerbuilder 9. I can't seem to find the right parameters, when I test the
connection the ODBC dialog pops up, and I want to make the connection
without ODBC.
Here's the connection params... please help me telling what I'm doing wrong.
(the server is starting as fernando, and the database is fernando.db)

// Profile fernando
SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = <***>
SQLCA.LogId = "dba"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"PROVIDER='ASAProv.90',DATASOURCE='null',LOCATION='fernando',PROVIDERSTRING=''dbn=fernando''"


thx in advance


"Chris Keating [Sybase iAnywhere]" <keating_no Posted on 2009-04-20 14:46:58.0Z
From: "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.database,sybase.public.sqlanywhere
Subject: Re: Connect To ASA 9 using OLE DB with PowerBuilder 9
References: <49ec83ed@forums-1-dub>
In-Reply-To: <49ec83ed@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49ec8ae2$1@forums-1-dub>
Date: 20 Apr 2009 07:46:58 -0700
X-Trace: forums-1-dub 1240238818 10.22.241.152 (20 Apr 2009 07:46:58 -0700)
X-Original-Trace: 20 Apr 2009 07:46:58 -0700, vip152.sybase.com
Lines: 45
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.database:29988 sybase.public.sqlanywhere:277
Article PK: 312205

You have not provided enough information to connect.

Possible cause: You do not have an engine that is running and the
autostart fails because you have not specified which database file you
would like to start and connect.


Recommendation:
1) Specify ENG=<engine_name> as a best practice
2) If autostarting the database, add DBF=<path and filename of DB> to
identify the database

If you are attempting to connect to an aleady running database, the DBF
is not needed.



SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = <***>
SQLCA.LogId = "dba"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"PROVIDER='ASAProv.90',PROVIDERSTRING='eng=asademo9;dbn=asademo;dbf=c:\Program
Files\Adaptive Server Anywhere 9\asademo.db'"

Carlos wrote:
> I'm trying to connect to a database running ASA 9 in a linux pc from
> powerbuilder 9. I can't seem to find the right parameters, when I test the
> connection the ODBC dialog pops up, and I want to make the connection
> without ODBC.
> Here's the connection params... please help me telling what I'm doing
> wrong.
> (the server is starting as fernando, and the database is fernando.db)
>
> // Profile fernando
> SQLCA.DBMS = "OLE DB"
> SQLCA.LogPass = <***>
> SQLCA.LogId = "dba"
> SQLCA.AutoCommit = False
> SQLCA.DBParm =
> "PROVIDER='ASAProv.90',DATASOURCE='null',LOCATION='fernando',PROVIDERSTRING=''dbn=fernando''"
>
>
>
> thx in advance


"Carlos" Posted on 2009-04-20 16:27:38.0Z
From: "Carlos" <cadaov AT hotmail DOT com>
Newsgroups: sybase.public.powerbuilder.database,sybase.public.sqlanywhere
References: <49ec83ed@forums-1-dub> <49ec8ae2$1@forums-1-dub>
In-Reply-To: <49ec8ae2$1@forums-1-dub>
Subject: Re: Connect To ASA 9 using OLE DB with PowerBuilder 9
Lines: 16
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8064.206
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8064.206
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49eca27a@forums-1-dub>
Date: 20 Apr 2009 09:27:38 -0700
X-Trace: forums-1-dub 1240244858 10.22.241.152 (20 Apr 2009 09:27:38 -0700)
X-Original-Trace: 20 Apr 2009 09:27:38 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.database:29991 sybase.public.sqlanywhere:278
Article PK: 312204

This is the scenario

pc with windows xp , sql 9 (client)
i can login using interactive sql to the service in the linux pc, but can't
make a connection using ole db, it brings up odbc dialog.

pc with linux , sql 9 (server)
database running , service AA, database AA

both pc are running in the same network and subnet.

please tell me any additional info.
thx


"Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com> escribió en
el mensaje de noticias:49ec8ae2$1@forums-1-dub...

> You have not provided enough information to connect.
>
> Possible cause: You do not have an engine that is running and the
> autostart fails because you have not specified which database file you
> would like to start and connect.
>
>
> Recommendation:
> 1) Specify ENG=<engine_name> as a best practice
> 2) If autostarting the database, add DBF=<path and filename of DB> to
> identify the database
>
> If you are attempting to connect to an aleady running database, the DBF is
> not needed.
>
>
>
> SQLCA.DBMS = "OLE DB"
> SQLCA.LogPass = <***>
> SQLCA.LogId = "dba"
> SQLCA.AutoCommit = False
> SQLCA.DBParm =
> "PROVIDER='ASAProv.90',PROVIDERSTRING='eng=asademo9;dbn=asademo;dbf=c:\Program
> Files\Adaptive Server Anywhere 9\asademo.db'"
>
> Carlos wrote:
>> I'm trying to connect to a database running ASA 9 in a linux pc from
>> powerbuilder 9. I can't seem to find the right parameters, when I test
>> the
>> connection the ODBC dialog pops up, and I want to make the connection
>> without ODBC.
>> Here's the connection params... please help me telling what I'm doing
>> wrong.
>> (the server is starting as fernando, and the database is fernando.db)
>>
>> // Profile fernando
>> SQLCA.DBMS = "OLE DB"
>> SQLCA.LogPass = <***>
>> SQLCA.LogId = "dba"
>> SQLCA.AutoCommit = False
>> SQLCA.DBParm =
>> "PROVIDER='ASAProv.90',DATASOURCE='null',LOCATION='fernando',PROVIDERSTRING=''dbn=fernando''"
>> thx in advance


"Chris Keating [Sybase iAnywhere]" <keating_no Posted on 2009-04-20 16:43:33.0Z
From: "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.database,sybase.public.sqlanywhere
Subject: Re: Connect To ASA 9 using OLE DB with PowerBuilder 9
References: <49ec83ed@forums-1-dub> <49ec8ae2$1@forums-1-dub> <49eca27a@forums-1-dub>
In-Reply-To: <49eca27a@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49eca635@forums-1-dub>
Date: 20 Apr 2009 09:43:33 -0700
X-Trace: forums-1-dub 1240245813 10.22.241.152 (20 Apr 2009 09:43:33 -0700)
X-Original-Trace: 20 Apr 2009 09:43:33 -0700, vip152.sybase.com
Lines: 71
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.database:29992 sybase.public.sqlanywhere:279
Article PK: 312208

You need to
1) Provide the engine name parameter
2) Likely provide the communication links parm

i.e.,
"PROVIDER='ASAProv.90',PROVIDERSTRING='eng=aa;dbn=aa;links=TCPIP'"

Carlos wrote:
> This is the scenario
>
> pc with windows xp , sql 9 (client)
> i can login using interactive sql to the service in the linux pc, but
> can't make a connection using ole db, it brings up odbc dialog.
>
> pc with linux , sql 9 (server)
> database running , service AA, database AA
>
> both pc are running in the same network and subnet.
>
> please tell me any additional info.
> thx
>
>
> "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com> escribió
> en el mensaje de noticias:49ec8ae2$1@forums-1-dub...
>> You have not provided enough information to connect.
>>
>> Possible cause: You do not have an engine that is running and the
>> autostart fails because you have not specified which database file you
>> would like to start and connect.
>>
>>
>> Recommendation:
>> 1) Specify ENG=<engine_name> as a best practice
>> 2) If autostarting the database, add DBF=<path and filename of DB> to
>> identify the database
>>
>> If you are attempting to connect to an aleady running database, the
>> DBF is not needed.
>>
>>
>>
>> SQLCA.DBMS = "OLE DB"
>> SQLCA.LogPass = <***>
>> SQLCA.LogId = "dba"
>> SQLCA.AutoCommit = False
>> SQLCA.DBParm =
>> "PROVIDER='ASAProv.90',PROVIDERSTRING='eng=asademo9;dbn=asademo;dbf=c:\Program
>> Files\Adaptive Server Anywhere 9\asademo.db'"
>>
>> Carlos wrote:
>>> I'm trying to connect to a database running ASA 9 in a linux pc from
>>> powerbuilder 9. I can't seem to find the right parameters, when I
>>> test the
>>> connection the ODBC dialog pops up, and I want to make the connection
>>> without ODBC.
>>> Here's the connection params... please help me telling what I'm doing
>>> wrong.
>>> (the server is starting as fernando, and the database is fernando.db)
>>>
>>> // Profile fernando
>>> SQLCA.DBMS = "OLE DB"
>>> SQLCA.LogPass = <***>
>>> SQLCA.LogId = "dba"
>>> SQLCA.AutoCommit = False
>>> SQLCA.DBParm =
>>> "PROVIDER='ASAProv.90',DATASOURCE='null',LOCATION='fernando',PROVIDERSTRING=''dbn=fernando''"
>>> thx in advance
>