Web with OBDC on Windows Server 2012 crash

Targets Web
1

XOJO 2018 r4

Hi
I need help
this is my code on windows server 2012 my web app when get to this point it crash if any idea way

try

Session.QbConn=New ODBCDatabase
Session.QbConn.Timeout=80
// Cooling Systems
Session.QbConn.DataSource = “CData-HW”
Session.QbConn.UserName=“imp”
Session.QbConn.Password=“Cool@3838”

If Session.QbConn.Connect Then
MsgBox"Connect"
Else
MsgBox("Error: " + Session.QbConn.ErrorMessage + " " + “(>>>QuickBooks is not Open <<<)”)
Session.QbConn.Close
Quit
End If
Catch e As NilObjectException
MsgBox e.Message
end try

2

Does your data source (DSN) exist for the username running the web program? If you created a user DSN then probably not, try a system DSN.

Is your sample code in the Session.Open event? If not try placing it there.

What does the browser show when this happens?

3

yes DSN is create but no on System and the browser is on my app is running local on the server

4

A DSN can be created for a single user, or the system (for all users.) If its not a system DSN then it will work for you only. But the app is probably running under a different user so the DSN does not exist for it. I think you need to create a system DSN.

I looked at some of my code … I’m not sure you’re using .DataSource properly. Try it this way (not using DSN):

db = New ODBCDatabase db.DataSource = "Driver={SQL Server};Server=MyServer;Database=MyDB;" db.UserName = "xx" db.Password = "yy" db.Connect

If your database is MS SQL Server, you may need Server=MyServer\InstanceName in the data source.

5

thanks is working with system DSN