Connection of PB 6.0 to SQL Server 7.0 & Version B/W PB 6.0 and PB 7.0Can anyone tell me about connecting PB 6.0 to SQL Server 7.0. Please
remember we are not planning to upgrade both software. When I was trying to
connect PB 6.0 to SQL Server 7.0, error occurred " SQLSTAT 1003".
OS=NT 4.0 Server
PB=6.0 Enterprise Edition
SQL SERVER=7.0 Corporate Edition
I also want to know the versions between PB 6.0 to PB 7.0
If your are using the ODBC, which I assume you are, include Disablebind=1 in
your DBParm. If your deployment environment is also NT, you will have to
turn SQLSPY=1 using PFC services. Autocommit=FALSE and SetTransObject()
ra...
Help me about connecting PB 6.0 to SQL Server 7.0 & Versions B/W PB 6.0 and PB 7.0Can anyone tell me about connecting PB 6.0 to SQL Server 7.0. Please
remember we are not planning to upgrade both software. When I was trying to
connect PB 6.0 to SQL Server 7.0, error occurred " SQLSTAT 1003".
OS=NT 4.0 Server
PB=6.0 Enterprise Edition
SQL SERVER=7.0 Corporate Edition
I also want to know the versions between PB 6.0 to PB 7.0
I don't believe this is going to be possible without at least upgrading to the
latest maintenance release of 6.x.
On Mon, 23 Aug 1999 00:59:56 -0700,
in powersoft.public.powerbuilder.database
Abdul Lateef <abdul_lat...
Error connecting Pb 6.5 and Pb 7.0 to SQL SERVER 7.0 desktop(Window 98)Today(9 Sep 1999), I can't connect to SQL Server 7.0 before this i can
connect it.
It give an Error "Unable to connect : SQL Server is unavailable or does not
exist, Specified SQl Server not found ".
I have check with Query analyzer , the Query analyzer can connect very well.
Any one this have this problem, and how to solve this ???
TIA
--
Regards
Daniel Fransius
not enough information... are you trying to use OLE DB ? ODBC ? Native
driver ? What about security settings on the server ? What user id and
password are you passing ?
There is a lot of things ...
PB 7.0.1
Hi,
I just found a solution for correcting the memory leak in 7.0.1, when
connecting to MS SQL Server 6.5. May be this is already fixed in the latest
releases. I just want to share this in case it's useful to any of you guys.
When you connect to the MS SQL Server 6.5 database, be sure to have
atleast something in your DBParm attribute of the DBProfile (or SQLCA
transaction object at runtime). For example (SQLCA.DBParm =
"AppName='IRIS',Host='ZNF9'"). In development time in the DBProfile dialog
under "Network" tabpage Enter something i...
PB 6.5 connection to SQL 6.5 problem when 2000 is installedWe have several PB 6.5 applications that connect (native) to Microsoft SQL
Server 6.5. They have been running fine for me until I installed the MS SQL
Server 2000 client tools on my computer. I still have the SQL 6.5 tools
loaded. At some point I had also installed the SQL 7.0 client. I did not
have any problems with my apps after that install, only after the 2000
installation. We uninstalled the SQL 2000 client and reinstalled the 6.5
client, but I am still having problems running the applications. I am
getting an error message that states..."DDE Server Window: myapp.exe -...
PB 7.0 or PB 6.5 or PB 6.0 or PB5.04We are using PB 5.04 Enterprise at this moment and are almost happy (uch)
with it.
Because we don't programming applications for the Internet (maybe in the
near future) we haven't upgraded to version 6.0 and 6.5. Now we are confused
what to do, keeping the old and 'stable' version (5.04) or upgrading to a
newer version. Are there features in the newer versions wich make it a
'must' to upgrade. What are this features. Or are there reasons to stay on
5.04 (buggy newer versions?).
What is doing the rest of the Powerbuilder world???
Greetings,
Hans Groeneveld
...
PB 6.5 connect to SQL SERVER 7.0I just want to migrate my Microsoft SQL SERVER 6.5 to SQL SERVER 7.0.
I want to know are there any problem to connect with SQL SERVER 7.0 ????
TIA
Regards
Daniel Fransius
YES. Please look in the 'database' group of early August for a discussion
topic 'PB 6.5 & MSSQL 6.5->7'.
Daniel Fransius <DanielFr@cbn.net.id> wrote in message
news:dIPJ#gh4#GA.207@forums.sybase.com...
> I just want to migrate my Microsoft SQL SERVER 6.5 to SQL SERVER 7.0.
> I want to know are there any problem to connect with SQL SERVER 7.0 ????
>
> TIA
...
PB 6.5 to MS SQL server 7.0 connectivityGreetings
Seem to much discussion on this topic...I desperately need the answer at the
end of the book. We are upgrading to SQL 7 and MUST be live with our PB
6.5 app in 3 weeks.
PowerSoft/Sybase preferred or recommended configuration??
Please respond with any recommendations on:
PB versions / builds
PB drivers
SQL Server client software
Native drivers VS OLEDB VS ODBC etc...
PB support of 7.0 new features: specifically the 8K varchar DataType
thanks
<pc>
...
connection problem from PB 6.5 and MS SQL 7.0I experience this problem when trying to connect to MS SQL 7.0 from PB
development Environment from Database painter.
SQLState S1003
Microsoft ODBC Drive Manager PRogram Type out of Range.
Your help much appreciated.
Upgrade to 6.5.1
Syed <syedibrahim@hotmail.com> wrote in message
news:UNYhqTUR$GA.191@forums.sybase.com...
> I experience this problem when trying to connect to MS SQL 7.0 from PB
> development Environment from Database painter.
>
> SQLState S1003
> Microsoft ODBC Drive Manager PRogram Type out of Range.
>
> Your help much appr...
PB 6.5 and MS SQL Server 7.0 connectivityI have a PB 6.5 application running with SQL-Anywhere. I have recently
tried to re-establish the database on Microsoft SQL-SERVER 7.0. I have
loaded the native client-side software to connect to MS 7.0 and was
successful with the connection.
However, when I tried to establish a connection via the PB 6.5 development
environment (DB painter and etc.), I received a "S1003 - Program type out of
range" message from within the PB 6.5 database painter. I didn't receive
the error message when I connected to the database... but only when I tried
to actually do something thru ...
PB 6.5.1/7.0 Connect 16-bit exe with ASA 6.0I have the Techdoc DocID 444777 on connecting 16-bit exes with 32-bit
SQL Anywhere DBs:
http://techinfo.sybase.com/css/techinfo.nsf/DocID/ID=44477
I have followed it to the letter and cannot get it to work:
Error message on 16-bit exe CONNECT using SQLCA: ODBC is not supported in
your installation.
Has anyone else tried this? 32-bit exe works no problems (well it would
32-bit ODBC).
Platform is Win95. I have both the 32-bit and 16-bit deployment kits
installed on the same machine.
I think the problem is with the so-called ODBC bridge.
Any help appreciated.
Problem ...
Problems to connect a PB 5.04 with MS SQL Server 7.0I possess PB 5.04 and I need to connect with MS SQL Server 7.0 he/she
saw ODBC.
I am using the connection file with the MS SQL server:
SQLSRV32.DLL 3.70.06.23 11/05/1999
ODBC 3.510.3513.0
When I execute the application for PB in Windows 95 it works, but when I
try to execute
by Windows 98 and I give retrieve in any datawindow he/she doesn't
appear the data.
Seemingly the I am supported it connected, mistake didn't come back.
To use sql embeded doesn't also work, coming back garbage.
Thank you,
Francisco Freitas
ODBC 3.x added some new datatypes that older v...
PB 7.0.2 and SQL Server 6.5 slow connectionWe've recently upgraded from PB 6.5 to PB 7.0.2 (Build 8003).
Before the upgrade, a connection in development mode took a few seconds.
Now it takes several minutes.
Does anyone know what might be cause the slowdown?
Thanks,
Ken
Try appling the 8046 EBF
"Ken Freeman" <kfreeman@ems.jsc.nasa.gov> wrote in message
news:p1fXadCIBHA.201@forums.sybase.com...
> We've recently upgraded from PB 6.5 to PB 7.0.2 (Build 8003).
> Before the upgrade, a connection in development mode took a few seconds.
> Now it takes several minutes.
>
> Does a...
problem when connecting MS SQL Server 7.0 with powerbuilder 6.5Dear All,
I have some problem when connecting MS SQL Server 7.0 with powerbuilder 6.5
The error message is:
Database transaction information not availiable.
Call SetTrans or SetTransObject function.
I have a window with 1 button and 1 datawindow
The datawindow inside contain a SQL statement
in the click event of the botton, the script is:
parent.dw_1.SettransObject(SQLCA)
parent.dw_1.retrieve()
Can anyone tell me what is the problem? And how to solve it???
Thank You Very Much!!!
It seems that the database connection is not available or not successfully
connected.
...
Oracle Client 8.1.7Hi all,
I have a question about compatibility between PB native driver and oracle
sql*net for different versions of Power Builder.
We have 3 applications developed in 3 different versions of Power Builder:
5.00.0.0, 6.5.1.620 and 7.0.10047
All of them are using the Oracle Client 8.1.6 and accessing via PB Native
Driver to Oracle. Although this is combination is not supported, the person
in charge of the PB part tested this combination and decided to upgrade
the oracle client from version 7.3.X to 8.1.6. So far it is working
properly for us.
Now, if it is decided to move to ora...
Error Connection To MS SQL Server 7.0 From PB 6.5.1Dear everyone:
I have Microsoft Backoffice SmallBusiness 4.5 Chinese Edition. The software
suite includes MS SQL Server 7.0. But I can not find Client ODBC Driver For
MS SQL Server 7.0 in it. My workstation OS is Windows 98 Chinese Edition.
In PB 6.5.1, when I use MSS MS SQL Server 6.x interface, I can connect to
the database in the backend server. But when I use SQL Server driver in
ODBC, I got error message. The error message is chinese. But I think the
english error message maybe like "Program Type Beyond".
I want to know how to solve it or how to get ODBC driver for M...
Error Connection To MS SQL Server 7.0 From PB 6.5.1Dear everyone:
I have Microsoft Backoffice SmallBusiness 4.5 Chinese Edition. The software
suite includes MS SQL Server 7.0. But I can not find Client ODBC Driver For
MS SQL Server 7.0 in it. My workstation OS is Windows 98 Chinese Edition.
In PB 6.5.1, when I use MSS MS SQL Server 6.x interface, I can connect to
the database in the backend server. But when I use SQL Server driver in
ODBC, I got error message. The error message is chinese. But I think the
english error message maybe like "Program Type Beyond".
I want to know how to solve it or how to get ODBC driver for M...
PB 6.0 to Oracle 8.0.5 Connection ProblemI am using PB 6.0 with the Oracle8 beta driver to develop
an application that is using the Oracle8 BLOB datatype.
I can connect OK via the Database Painter, but when I try
to test the application and attempt to connect, I get the
following message:
"ORA-06401: NETCMN: invalid driver designator
Please see the system administrator"
I can connect to the Oracle8 backend OK with
the 073 version of the driver, but this will not let
me used the SELECTBLOB statement to retrieve the
BLOB columns, I get the following error:
"READBLOB/WRITEBLOB is valid for only VARRAW, RA...
pb 6.5, pb 7.0, pb 8.0 and future releasesI have designed an app using PB 6.5.1 and feel quite confortable to write
another app using this version of Power Buulder. I am aware that there have
been many other releases after this but have heard many developers complain
about not being stable and so forth. I can't say how true this is cause I
never bothered to update to later releases. I recently got a contract for a
new app and quite likely will be using Power Biulder but I am wondering if
am cheating myself by not trying to upgrade myself to a later release of
Power Biulder.
Thanks.
Charlie.
Charlie
You...
PB 5.0 to PB 6.5, 7.x, 8.0??I have a client who needs to move from an initial PB 5.0 release (no patches
applied) to a newer version of PB. This is a small internal application but
they would like to open it up via the internet in the future. They are
currently running on a SQL Anywhere DB but would be looking to change that
also.
I don't have any hands on experience with PB 7.x but from what I heard and
read it hasn't been that great. I've been using PB 6.5 since build 444 and
was thinking of recommending that they make the move to 6.5 first and then
wait for PB 8.0 later this year.
Any thoug...
Connection to MS SQL Server 7.0 with PB application built in 5.5.04FYI....
I am in the process of upgrade an application database from MS SQL
server 6.0 to 7.0 and I would like to know if there is a driver download
that I can get so that I don't have to also upgrade the application as
well.
Is a database driver download available? It there is, where do I get it
from?
Thanks for the help.
(My gut feeling is that the application will also have to be upgrade for the
new native driver... Please say I am wrong)
.......Shane
Hi Shane,
MS 7 does not have a native driver...
Connect PB 6.5 to Informix 9I am trying to connect a PowerBuilder application that is currently in
PB6.5 to an Informix 9 database. I believe I need a DLL named PBIN960.DLL
but I am unable to find it.
Is this correct and if so, does anyone have it?
In my experience, using the Informix 9 client(Informix-Connect v9.1) with
the IN7 native driver included with PB 6.5 will work, but will give strange
results.
The best thing to do is install the Informix 7 client
software(Informix-Connect v7.2) and use the IN7 native driver for PB 6.5.
You could also migrate your app to PB 8.0.1 and use the IN9 native driver i...
Oracle 8.0/Oracle 7.1.4 & PB 5.0 connection problemI am using native database interfaces 7.2 to connect with the Oracle
database 7.1.4 (UNIX) from PB 5.0(windows 95), it works well. But after
I installled Personal Oracle8 on my desktop, everytime it goes to the
local oracle 8 database(oracle8 database autobatically starts ) with the
same profile, not the remote 7.1.4. I tried to use Oracle Home Selector
to switch the oracle home to 7.1.4, nothing happened, Oracle home stayed
at Oracle 8. Is there any way that can let me specify the database?
Thanks
What are you using as your servername string?
Is your tnsnames.ora file still corr...
Connecting to MS SQL Server 2000 w/PB Professional v 8.0/9.0Hi all-
Wondering if PB 8.0/9.0 Professional can connect to MS SQL Server 2000?
Without Native driver, can it connect via ODBC? We generally use Enterprise
with native drivers but wondered if Professional is an option.
Thanks for help on this.
Ed Zak-
Yes, it's a very viable option.
On 22 Dec 2003 14:04:13 -0800, "Ed Zak" <zakef@askesis.com> wrote:
>Hi all-
>
>Wondering if PB 8.0/9.0 Professional can connect to MS SQL Server 2000?
>Without Native driver, can it connect via ODBC? We generally use Enterprise
>with native drivers but wondered if Professional is an option.
>
>Thanks for help on this.
>
>Ed Zak-
>
>
Jim O'Neil
Principal Technical Support Engineer
Sybase, Inc.
Concord, MA
And the side benefit of using ODBC versus the native driver is that you will
be able to access some (if not all) new features that require MS SQL Server
7 or later client software. Remember, the native interface is feature frozen
as the underlying technoloyg dblib was feature frozen by MS.
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
...