Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: Program type out of range - S1003

    We have a Powerbuilder 4.0 application that used to run on SQL Server 7.0. Recently, we migrated our database to SQL Server 2000. We can do ODBC and can connect to the database from any tools such as Access, Excel and register the new SQL Server 2000 to other SQL Server, but when we try to use the client application, the user can not connect to the database. We receive the error message as the subject line. The user interface opens up but there is no data. The orginal program was written in Powerbuilder 4.0 by our vendor who probably does not have a copy of the source codes in proper state as I understand from talking to them. My question is, is there something that I can do to help my user connect to the database by using the client interface? This is getting a bit frustrating as no one really has an answer for it. I tried to install Powerbuilder 9.0 just to see if that updates any driver file that my machine has and that would be recongnize by the client programs, but it will not.

    What can we do or what suggestions anyone can extend? Thanks for any inputs.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What is the error message ? Look in the sql server log file as well as the event viewer for additional error messages.

  3. #3
    Join Date
    Nov 2003
    Posts
    4
    Originally posted by rnealejr
    What is the error message ? Look in the sql server log file as well as the event viewer for additional error messages.
    Actually, in the SQL Server log there is nothing since no connection was established from the client side.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by wellsound
    Actually, in the SQL Server log there is nothing since no connection was established from the client side.
    Well then it's not a sql server problem or issue....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2003
    Posts
    4
    Yes I knew that, but since this is a Powerbuilder-client app with SQL Server backend, I have known that there are problems with the 16 bit ODBC driver that Powerbuilder used in their earlier version which is what the client app is built on, that is Powerbuilder Version 4.0 and that is exactly why I thought of asking in this forum to see if someone may have a related answer to that. But thanks for your reply.

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Is it using a dsn connection ? If so, what are the properties - and have you tried updating the driver and use that dsn ?

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I think I've seen this error before when a variable or column is unable toa accept a value submitted to it. Is there a procedure that runs when the user logs in, and are there any parameters passed to the procedure?

    blindman

  8. #8
    Join Date
    Nov 2003
    Posts
    4
    Originally posted by rnealejr
    Is it using a dsn connection ? If so, what are the properties - and have you tried updating the driver and use that dsn ?
    This is what we have in the configuration file
    [<name of the sytem]
    DBMS=SYB SQL Server v4.x
    ServerName=, server name>
    Database= <database name>
    DbParm=appname='name of the app>',release='4.2'

    We made a number of changes to this such as change the SYB SQL Server v4.x to DSN and on the DbParm we have used = dsn=<data source name> database = <database> name

    None of these seem to work. The only thing we had was the client user interface opens up but no data comes up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •