INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Sqlconnect(hsql) issue

Sqlconnect(hsql) issue

(OP)
Hello ...

I'm in process of migrating a centura application from oracle 8i to 10g. I have modified the sql.ini and to have the new dbname. when i try to launch the application, the application just goes off.

I ran it in debug mode and found that the apllication goes off while executing sqlconnect(hsql).

Please help me.

Regards,
Arjun

RE: Sqlconnect(hsql) issue

First you must try and see if you can connect to your new database via SQLTalk.  This will test your SQL.ini is configured properly and can see the dB.

Come back once this is done so we can determine what path to take next.

RE: Sqlconnect(hsql) issue

(OP)
I was able to connect to the new database successfully via sqltalk.

RE: Sqlconnect(hsql) issue


Now check the values in system variables SqlDatabase, SqlUser, and SqlPassword imediatley prior to
SqlConnect(hSql), using the debugger.

If they are the same as you use to connect via SQLTalk, you need to make sure your TD app is using the same SQL.ini as SQLTalk - search your drives for duplicate SQL.ini files - I have often found more than one lurking around and sure enough TD is using the wrong one.

If definately only one, try a tiny sample app :

Variables

Sql Handle: hSql
...
Application Actions
On SAM_AppStartup
                            Set  SqlDatabase = 'TEST'
                                Set SqlUser = 'QAGROUP'
                            Set  SqlPassword = 'FINDBUGS'
                            
        If SqlConnect ( hSql )
           Call SalMessageBox('Connect Ok','Connect',MB_Ok
        Else
           Call SalMessageBox('Connect Bad','Connect',MB_Ok
         
                        
On SAM_AppExit
                                Call SqlDisconnect ( hSql )


Come back with what happens.
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close