This works fine the the host system(where the SQL express is installed) but if i try to run the applicatoin from a network PC, running on Windows 98, Im getting an error
"Login failed for user '' Factory/Guest"
When i Change the connection string to use User id and password of SQL Logins , (The user is set 'Public' as DB Role membership in SQL Express for the Production database)
Sounds like the database and client machine may not be in the same domain (Workgroup does not count, I think). Also, SQL Server installs with Windows Authentication only by default. If you change the authentication mode on SQL Express to Mixed, you should be able to log in with the SQL Server userID and password.