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 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>
...
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 Connection To MS SQL Server 6.5We have three servers running MS SQL Server 6.5. PB 5.0 applications (both
PB client apps and PB apps running on the servers at night as part of batch
jobs) have been running on them for a long time. Native drivers are used.
I'm starting to replace these apps with PB 6.5 versions of them.
With respect to two of the servers, I can connect to the databases from all
the new apps - both client PC apps and batch apps. On the third server, I
can connect to the databases using the client PC apps only. When the apps
in the night job run, the CONNECT statement gets the following error
...
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.
...
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.5 Apps Connection to MS SQL Server 6.5We have three servers running MS SQL Server 6.5. PB 5.0 applications (both
PB client apps and PB apps running on the servers at night as part of batch
jobs) have been running on them for a long time. Native drivers are used.
I'm starting to replace these apps with PB 6.5 versions of them.
With respect to two of the servers, I can connect to the databases from all
the new apps - both client PC apps and batch apps. On the third server, I
can connect to the databases using the client PC apps only. When the apps
in the night job run, the CONNECT statement gets the following error
...
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...
Porting Ms Sql Server 6.5 database to Ms Sql Server 7.0Hi,
We have developed a product using PowerBuilder7.0, Ms Sql Server 6.5 and
connecting them using powerbuilder native driver. Now we are thinking of
porting Ms Sql Server 6.5 database to Ms Sql Server 7.0.As we feel, we could
achive new features of Sql server 7.0.e.g row level locking.
Actually i want to know, what things i have to do.e.g what sort of
connection i have to use? what new features i will able to use?.will Stored
procedures work properly.
Is there anyting i have to chang in my application(at front end)e.g
datawindows or any embeded sql, external functions.
Should i po...
Porting Ms Sql Server 6.5 Database to Ms Sql Server 7.0Hi,
We have developed a product using PowerBuilder7.0, Ms Sql Server 6.5 and
connecting them using powerbuilder native driver. Now we are thinking of
porting Ms Sql Server 6.5 database to Ms Sql Server 7.0.As we feel, we could
achive new features of Sql server 7.0.e.g row level locking.
Actually i want to know, what things i have to do.e.g what sort of
connection i have to use? what new features i will able to use?.will Stored
procedures work properly.
Is there anyting i have to chang in my application(at front end)e.g
datawindows or any embeded sql, external functions.
Should i po...
Outer Joins, ANSI syntax and MS SQL Server 6.0, 6.5, 7.0 BetaHi
We would like to make our powerbuilder program avaible on multible DB
platforms, but one big problem is OUTER JOINS !
We started on Oracle, no problems.
// Oracle 7.3.4
SELECT *
FROM TABLE1,
TABLE2,
TABLE3
WHERE ( TABLE1.NUMMER_N06 = TABLE3.NUMMER_N06 (+)) and
( TABLE3.NUMMER_I = TABLE2.NUMMER_I (+)) ;
Then , for the smaller companies, we tried SQL AnyWhere 5.0, no problems.
// Sybase SQL Anywhere 5.5
SELECT *
FROM {oj {oj TABLE1 LEFT OUTER JOIN TABLE3 ON TABLE1.NUMMER_N06 =
TABLE3.NUMMER_N06}
LEFT OUTER JOIN...
PB 6.5, MS SQL Server 7.0 and MS Access 97Since we installed MS SQL Server 7.0 (which updated our Data Access
Drivers), we are no longer able to reference Access 97 from PowerBuilder. I
get an error:
[Microsoft][ODBC Driver Manager] Program type out of range
Any idea what might be going on?
Thanks,
Cliff
Different ODBC drivers are not compatible. There is an updated ODBC patch
for PB 6.5 on the SDN, that might solve your problem. Else you'll probably
have to reinstall Access 97 (and risk braking SQL Server 7).
--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Cliff Koehler wrote in message <3Cb...