Paradox Front End, SQL Server Back End

[SuperG]

I am having trouble keeping the SQL Server database open.

I open the session and database in my startup script, which opens my main navigation form.

When I move to a data entry form with SQL Server data in the data model the database information box pops up waiting for input before continuing to open the form.

Is there any way to keep the database connection open until I exit the application.

Startup script

ses.open()

dynAlias["Database"] = "ISAS"
dynAlias["User Name"] = GetNetUserName()
dynAlias["Password"] =""

if not dbSQL.open(":INACDATA:", ses, dynAlias) then
MsgStop("Login Error", "User not registered for ISAS Database&quot
endIf

Thank you.

Glenn

 

[footpad]

Glenn,

Have you tried to use a global Session variable in your application? The Database type has an alternate open() declaration that lets you specify a specific session and the Session type may surface additional properties you can change.

Also, see if any of the MSSQL driver settings in BDE Admin affects this. I don't see any that might be possible, but your connection may be closing prematurely.

It's a guess, but one I hope helps at least a little...

-- Lance