Sqlconnect(hsql) issue

[aprath01]

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

 

[GuptaSteve]

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.

 

[aprath01]

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

 

[GuptaSteve]

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.