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 the database painter.

The funny thing is that when I modify my application .ini file to use:

     DBMS=MSS  instead of ODBC
     database=test1
     dbparm="'DSN=test1'"

My application appears to connect to the MS 7.0 database.  I was reading
that if you use 'DBMS=trace MSS' in the .ini file you can debug the
connection.  It seems to work with the applications transaction object, but
not during the development environment.

Does anyone know how to connect to MS 7.0 from PB 6.5?

I would appreciate any feedback.

I've never used Microsoft SQL-SERVER so I'm a little lost.

Thanks,
JT

You need to get the maintenance release for PB 6.5.  The newer version of
ODBC adds some datatypes that older versions of PB don't know how to handle.

On Fri, 12 May 2000 16:39:03 -0700,
 in powersoft.public.powerbuilder.connectivity
JTaylor  wrote: 
>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 the database painter.
>
>The funny thing is that when I modify my application .ini file to use:
>
>     DBMS=MSS  instead of ODBC
>     database=test1
>     dbparm="'DSN=test1'"
>
>My application appears to connect to the MS 7.0 database.  I was reading
>that if you use 'DBMS=trace MSS' in the .ini file you can debug the
>connection.  It seems to work with the applications transaction object, but
>not during the development environment.
>
>Does anyone know how to connect to MS 7.0 from PB 6.5?
>
>I would appreciate any feedback.
>
>I've never used Microsoft SQL-SERVER so I'm a little lost.
>
>Thanks,
>JT
>
>

---
Bruce Armstrong [TeamSybase]
mailto:Bruce.A[email protected]

Preach the gospel at all times. If necessary, use words. [Francis of Assisi]
http://www.kidbrothers.org                | http://www.fccwc.org
http://www.harvest.org/knowgod/index.htm  | http://www.needhim.org

-----------== Posted via the PFCGuide Web Newsreader ==----------
http://www.pfcguide.com/_newsgroups/group_list.asp