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






0
SHANE
9/28/1999 3:18:05 PM
sybase.powerbuilder.connection 3893 articles. 0 followers. Follow

2 Replies
724 Views

Similar Articles

[PageSpeed] 21

Hi Shane,

MS 7 does not have a native driver. Starting with 7.0 MS is now pushing
ODBC/OLEDB which means there will be no native driver developed for MS 7
(forcing you to use ODBC/OLEDB). You CAN use the 6.5 driver against 7, but
this will prevent you from taking advantage of any new 7 features.


--
John De Lello
DelWare Consulting Group
Programming solutions for today's complex problems
http://www.DelWare.com
Sign up for the PB-PFC e-mail list. Technical discussions on PBPFC related
topics only:
iMailSrv@DelWare.com with the message text of:
SUBSCRIBE PBPFC first last
(replace first and last with your name)

Other lists available are:
MSSQL - Microsoft SQL Server
QuoteODay - Receive a quote each day from words of wisdom.

SHANE FUNGAFAT <SFUNGAFAT@MMS.ORG> wrote in message
news:jprh7TcC$GA.51@forums.sybase.com...
> 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
>
>
>
>
>
>


0
John
9/28/1999 4:18:06 PM
SQL7 will not work with PB5.0.04.  There is no driver upgrade available.
You will have to upgrade your application to 6.5.1 or 7.0

Simon

SHANE FUNGAFAT wrote in message ...
>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
>
>
>
>
>
>


0
Simon
9/29/1999 8:44:11 AM
Reply:

Similar Artilces:

Problems to connect a PB 5.04 with MS SQL Server 7.0
I 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...

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 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 to MS SQL server 7.0 connectivity
Greetings 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> ...

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

Error Connection To MS SQL Server 7.0 From PB 6.5.1
Dear 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.1
Dear 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...

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

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

PB 5.0.04 on NT 4.0 running MS SQL Server 7.0?
Anyone running PB 5.0.04 on MS SQL 7.0? We're running against MS SQL 6.5 and are considering upgrading to take advantage of some of the new features. Are there new SQL drivers available or required? TIA, pat yuen pyuen@carmafinancial.com 5.0.04 doesn't work with SQL7, you'll need to upgrade to PB 6.5.1 or 7.0 Simon Pat Yuen wrote in message ... >Anyone running PB 5.0.04 on MS SQL 7.0? We're running against MS SQL 6.5 >and are considering upgrading to take advantage of some of the new features. >Are there new SQL drivers available or required?...

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

Connecting to MS SQL 6.5 through PB 5.0.02
I have set up a MS SQL ODBC connection in ODBC Administrator that has the server name and database name set, the rest is all default. In PB I make a new database profile called 'MS SQL' and set DBMS to 'ODBC'. In the 'Select Data Source' window that comes up I select the ODBC connection I just made on the 'Machine Data Source' tabpage. When I press OK to connect, PB crashes. I am running Win NT Server 4.0 and it has the MS SQL database, client software and PB installed on it. What am I doing wrong? I've tried all sorts of things like setting ...

Connection of PB 6.0 to SQL Server 7.0 & Version B/W PB 6.0 and PB 7.0
Can 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...

Web resources about - Connection to MS SQL Server 7.0 with PB application built in 5.5.04 - sybase.powerbuilder.connection

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Pre-Christmas job application rush hits Australian public service
Speed required for pre-Christmas job window opening for public servants. Check out who is hiring.

Second visa application 'likely' to be approved
The family of a terminally ill Pakistani student can 'hopefully come to Australia sooner rather than later' says Immigration Minister Peter Dutton. ...

Cloud application adoption increases 71 percent in 2015
The adoption of cloud applications is soaring, up by 71 percent in the last year according to the results of a new survey. The latest Cloud ...

Tashfeen Malik's visa application under scrutiny - Business Insider Deutschland
The US government has released the visa application for Tashfeen Malik, who along with her husband killed 14 people in an attack in San Bernardino, ...

MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey, Purchase Applications up 34% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey Mortgage applications decreased 1.1 percent from one week earlier, ...

Lawmaker: Immigration Officials Didn’t Fully Vet Tashfeen Malik’s Visa Application
"It’s unacceptable that U.S. Citizenship and Immigration Services did not fully vet Malik’s application and instead sloppily approved her visa," ...

German-Based Spirea Promotes Decentralized PV Applications In Uruguay
... Its technical operations specialist, Laurie Lawrence, pointed out that Uruguay [&hellip German-Based Spirea Promotes Decentralized PV Applications ...

Visa application of San Bernardino shooter released
CNN Visa application of San Bernardino shooter released CNN (CNN) The visa application of one of the San Bernardino shooters was released ...

ZTE to develop smartphone application processors in house
ZTE has stepped up its efforts to internally develop smartphone chipset solutions, aiming to re-capture the title as one of the top-three smartphone ...

Resources last updated: 12/28/2015 7:53:04 PM