CItrix and SQL

[mollyking]

We have an application (EBMS) using sql 2000 for its database. The application requires sql authenication, not Windows. We access the application via Citrix Metaframe 1.8 for Windows 2000. Everyhting works fine if we log into Citrix explicitly. But if we log into Citrix anonymously, the application cannot find the database. In Citrix Server Admin, I see the anonymous users connect. Any ideas on what's happening?

BTW - The Citrix server and the db server are behind the same firewall. Everything worked fine when the database was Sybase and not SQL.

 

[Spun]

Try Two things: make sure that the application is using a system DSN with SQL authenication and then try placing you sql box is SQL only authenication mode.

 

[mollyking]

The problem turned out to be in the ini file used by the program to get to the sql server. If a user logged in explicitly, the program could find the sql server using the netbios name in the ini file, but not if they logged in anonymously. Everyone has been able to connect since changing the sql server's netbios name in the ini file to its inside address.

 

[steve2030]

I am having a similar issue. We have a VB app that requires two DSN's to SQL to be added to the odbc settings of the computer. The app works fine locally, but when it is published and an attempt is made to accesss it via the nfuse classic web interface, the app starts, the login prompt appears, then it says it cannot connect to one of the DSN connections....

Any ideas.

 

[itsp1965]

Does your VB app use INI files? A lot of our VB apps that connect to SQL or Oracle are still written in this way. The INI file is stored on <drive:>\Winnt directory on the Citrix box then when a user logs on to the app for the first time the INI file is copied to the user's local Windows directory. If there are any changes to the app in terms of DSN entries, file paths etc, the INI file needs to be deleted from the user's local Windows directory and then will be re-created once they log on again.