PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files #2
PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files. Compiled program running on the Win98 without MS SQL 7.0 client application installed. I can not get the DB connection by using external ip address like "202.199.12.12", but for internal ip address "10.4.32.2" which is one of our intranet ip address, it works well. The error is "unable to find SQL Server or SQL Server unvaliable". Thanks ...

PB6.5 build 444 + MS SQL 7.0 + native drive connection(TCP/IP)
PB6.5 build 444 + MS SQL 7.0 + native drive connection(TCP/IP) Is it possible to run my EXE on a machine without MS SQL client install on it? I install a MS SQL client, as my EXE runs well. Then I uninstall the MS SQL client, it also runs well. But if I run my EXE on a machine which never has MS SQL client on it, it comes ""unable to find SQL Server or SQL Server unvaliable" error. I also got DLL files on it. ntwdblib.dll pbdwe60.dll pbmss60.dll pbvm60.dll TIA Powerbuilder cannot go directly to the database. It must communicate to the database through ...

PB6.5 build 444 + MS SQL 7.0 + native drive connection(TCP/IP)
PB6.5 build 444 + MS SQL 7.0 + native drive connection(TCP/IP) Is it possible to run my EXE on a machine without MS SQL client install on it? I install a MS SQL client, as my EXE runs well. Then I uninstall the MS SQL client, it also runs well. But if I run my EXE on a machine which never has MS SQL client on it, it comes ""unable to find SQL Server or SQL Server unvaliable" error. I also got DLL files on it. ntwdblib.dll pbdwe60.dll pbmss60.dll pbvm60.dll TIA The PB native driver requires the MSS client. The MS ODBC driver, however, does not require the c...

Connect MS-SQL 7.0 in PowerBuilder 7.0
In PowerBuilder 6.5, I can connect MS-SQL 6.5 directly not using ODBC, but in PowerBuilder 7.0, how can I connect MS-SQL 7.0 directly ? Please post to the powersoft.public.powerbuilder newsgroups This is dedicated to PB issues when used within Jaguar Masun wrote: > In PowerBuilder 6.5, I can connect MS-SQL 6.5 directly not using ODBC, but > in PowerBuilder 7.0, how can I connect MS-SQL 7.0 directly ? ...

Powerbuilder 5.0/7.0 and MS SQL 7.0 Performance issues
We recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app in PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0. Now we are migrating the database from MS SQL 6.5 to 7.0 SP2. We successfully converted the databases in a testing environment, but now the app runs terribly slow! I don't think it's a hardware issue -- the test box is a Compaq 8500 quad Xeon 500 w/1GB Ram. We experimented running the app as a PB 5.0 app against MS SQL 7.0 and the problem is the same. When we execute SQL directly against the DB outside of PB, we see no perf...

Connecting to MS SQL 7.0 in PB 5.0
Hi How do I connect to MS SQL server 7.0 giving the IP address of the server, instead of the servername in the profile...... ??? Thanx in advance - Hamsa You need at least PB6.5.1 to connect to SQL7. Some things will sometimes work in PB5, but some (including connecting by IP address IIRC) don't work. S. -- Simon Caldwell Get Real Systems Ltd Holtby Manor, Stamford Bridge Road, York, YO19 5LL Tel 01904 481999 Fax 01904 481666 Visit us at www.getrealsystems.com Specialists in e-Procurement and supply chain technology "Hamsa" <hamsaraj@uiscpl...

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 'Windows ME' 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. Thanks Saqib Sardar What build of...

Connection problem with PowerBuilder 5.0.02 to MS SQL 7
Hello, I am having a problem connecting PowerBuilder 5.0.02 to MS SQL 7. The application connects fine. The problem is when I try to create a new datawindow with a stored procedure on SQL 7. I can view all the names of the stored procedures but I can't see any of the code. I am using the odbc driver 3.07.08.20 . When I try to look at the stored procedures I get the message 'The database does not currently support retrieval of procedure text.' Everything worked fine in SQL 6.5. any help appreciated, Bruce ---== Posted via the PFCGuide Web Newsreader ==--- ht...

problem when connecting MS SQL Server 7.0 with powerbuilder 6.5
Dear 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. ...

Urgent!!Connecting to MS SQL Server7.0 with PB 5.0.04 on NT4.0
Hi! This is urgent!! Does anyone know how to connect MS SQL Server 7.0 from PB 5.0.04. I have connected to MSS 7.0 with ODBC 3.70 (come with MSS7.0) from PB5.0.04, but the embedded SQL statements in my program retrieve all kinds of gabbish to me. I believe there is something wrong with the ODBC drivers setting, how should I config the ODBC drivers ? I have tried to use MS SQL Server 6.5 native drivers to connect to 7.0 , but I 've got the error message, something like 'Datatype not supported' ? Why is that ? Cherry The problem, at least with ODBC 3.x, is that ...

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 ...

Connection to MS SQL Server 7.0 with PB application built in 5.5.04
FYI.... 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...

PB6.5 and MS SQL7.0 connection problems
I have PowerBuilder 6.5 build 444 and a MS SQL 7.0 server (with SP 3). I have loaded the latest MDAC from Microsoft and am running on a Windows 2000 machine. I am receiving 2 error messages when I try to connect to my database. The first message is: "Unknown token received from SQL server". The second message is: "Invalid Descriptor Index". Do you know of a way to help me fix this problem? Thank You ...

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 SQL 2005? The existing application is PB6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to connect MS SQL 2000. It is work fine. John Hi John; 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...