Powerbuilder 6.5 & SQL-server 6.5 <> 7.0
I'm using PB 6.5 with SQS 6.5
Everything is normal until I port the program build in this environment to
a similar environment with the only difference that the database is SQS 7.0
This database is slightly different - in some tables, the fields are larger
than in the SQS 6.5 database (but the same type - char).
When the program retrieves rows in that environment I get the error message
'Data conversion resulted in overflow ...'
I have several other environments with sqs 6.5 with the same difference
(larger fields) where the program doesn't rep...Connectivity of PowerBuilder 6.5 and SQL Server 7.0
I need help regarding connectivity with PB 6.5 and SQL Ser. 7.0. I am
getting an error message "DBMS MS Sql Server ... not supported in current
installation' or 'Unable to load the requested database interface".
I have required files for both the system and for PB i.e., NTWDBLIB.DLL
PBMSS60.DLL but still i am not able to connect to the database.
Check the sybase site, there is useful infor about the matter.
"mahesh" <firstname.lastname@example.org> wrote in message
new...problem when connecting MS SQL Server 7.0 with powerbuilder 6.5
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:
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
...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
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 ???
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 ...PB6.5 connect MS SQL 2005 using native driver (DBMS=MSS (Msoft) SQL Server 6.0)
Is it possible PB 6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to connect MS
The existing application is PB6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to
connect MS SQL 2000. It is work fine.
AFAIK .. it should work. The only restrictions would be
1) PB 6.5 will not understand SS2005 functionality. You will be restricted
to the SS 6.0 (as you are today with SS2000) feature set.
2) The MSS setting connects using the NTDBLIB.dll from MS. I do not believe
that this is supplied with SS2005. So you will need to install the SS20...PowerBuilder 6.5 and MS SQL 7.0 Connection
I'm facing a problem in connecting powerbuilder 6.5 to MS SQL 7.0 on
when i try to connect to database it creates the connection without giving
any error but when i try to see the tables in database painter or anywhere
else it does'nt show me the tables and gives me error
"SQLSTATE = S1003
[ODBC][SQLSERVER]Program type out of range"
i've formatted my hard disk and again installed 'Windows ME' and other
required softwares but the problem is still there, any suggessition would
be worth for me.
What build of...PB 6.5 connect to SQL SERVER 7.0
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 ????
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
> 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 ????
...Problems connecting the MS SQL 6.5 after migrating from PB6.5 to PB7.0
After migrating my PFC based PB6.5 application to PB7.0 application, I
cannot connect the deployed EXE program to MS SQL 6.5. I can connect to the
database before the migration. If I run the application in PW7.0, I can
connect to the MS SQL 6.5 database without any problem. However it does not
work if I run the deployed program. By changing the INI file, I can connect
to Sybase SQL 11.5 database but not the MS SQL 6.5. Please advise if anyone
has faced the same problem and how to solve this problem.
I forgot to state that I am using native drive to connect the the MS SQL 6.5
...Pb6.5 Connecting to SQL Anywhere 184.108.40.206 Database
Does PB6.5 support SQL Anywhere 220.127.116.11 database interface, I don't see it
when I try to create
a database profile in PB6.5 ??.
I can create an ODBC database profile though, but i don't want to use ODBC.
SQL Anywhere uses the ODBC interface as native so that's the right way to
John Olson [TeamSybase]
SAS wrote in message ...
>Does PB6.5 support SQL Anywhere 18.104.22.168 database interface, I don't see it
>when I try to create
>a database profile in PB6.5 ??.
>I c...PB 6.5 to MS SQL server 7.0 connectivity
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
SQL Server client software
Native drivers VS OLEDB VS ODBC etc...
PB support of 7.0 new features: specifically the 8K varchar DataType
...Connection to MS SQL Server 7.0 with PB application built in 5.5.04
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
Is a database driver download available? It there is, where do I get it
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)
MS 7 does not have a native driver...PB 6.5 and MS SQL Server 7.0 connectivity
I 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.5
We 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
...How do i upgrade PowerBuilder 5.0's native driver for MS SQL Server 6.5?
If you have the 5.0.04 patches, you have the latest stuff that I know of.
Tech Support might have something as a private EBF, but you would have to
contact them directly to determine that. Are you having a particular
problem with the drivers you have now?
On Tue, 9 Feb 1999 11:38:18 +0800,
A-B-C <email@example.com> wrote:
Bruce Armstrong [TeamPS] | Romac/Source International
mailto:Bruce.Armstrong@eudoramail.com | mailto:firstname.lastname@example.org
| http://www.romac-sou...don't connect PB6.5 to ASA 6.0 Eval
This is a multi-part message in MIME format.
don't connect PB6.5 to ASA 6.0 Evaluation copy,
in client server mode
for my probe this is my environment
server winnt 4.0 (compaq proliant 64mb and two processor pii350Mhz)
client win95 (ibm 300gl 32mb p200mhz)
thanks for any help
Buena Suerte, Good Luck
Adalberto Rua Aguirre