Sensory Computer Systems Forums Index Sensory Computer Systems Forums
Welcome to the Sensory Computer Systems Online Forums!
 
 FAQFAQ   SearchSearch   RegisterRegister 
 ProfileProfile   Log inLog in   
   Sensory Computer Systems Home   

New PC, Database Connectivity

 
Post new topic   Reply to topic    Sensory Computer Systems Forums Index -> Installation / Setup / Hardware
View previous topic :: View next topic  
Author Message
ForumAdmin
Site Admin


Joined: May 20 2005
Posts: 112
Location: New Jersey

PostPosted: Wed Apr 29, 2009 8:41 am    Post subject: New PC, Database Connectivity Reply with quote



New PC, Database Connectivity

Installation: If you haven't done so already, please install SIMS 2000 on your new colleague's PC, or new Panelist PC. Do you have a recent CD handy? We could also send you the latest CD, or our web download/update is also available. During the Setup on the 1st screen please tell SIMS 2000 the name of your Database server, if you do not know the name of the server please contact your IT staff and/or the support group at Sensory Compter Systems may also know the name. This information can also be specificed later. If you are near a PC with SIMS 2000 already running fine it's pretty easy to check proper database names and/or other site specifics.


ODBC Settings

It should be a fairly easy task to properly POINT your new PC's desktop SIMS 2000 application to your SQL database server.

In your SIMS 2000 application, look at SIMS 2000 Main Menu top menu | Utilities | Database Connection. More than likely you’re using general MS ODBC settings, so next press button [ODBC Administrator], see System tab, the SIMS 2000 entry, change the server name as needed, then go back into SIMS 2000 press [Test Connection].

Note: If SIMS 2000 [Test Connection] fails to make the connection the first time, your DBA person may need to look at the new server's settings, including if a login was created for SIMS 2000, SIMSDBO.

Note: 32-bit ODBC on 64-bit PC -- %windir%\sysWOW64\ODBCAD32.exe, the 32-bit version



Sensory Computer Systems

Back to top
View user's profile
ForumAdmin
Site Admin


Joined: May 20 2005
Posts: 112
Location: New Jersey

PostPosted: Tue Feb 26, 2019 10:44 am    Post subject: FAQ, ODBC Connection Not Working? Reply with quote



FAQ, ODBC Connection Not Working?




Use the Fully Qualified Domain Name (FQDN) for the server name.

-- Example, Your SQL server name may be: SQLPRODUCTION

-- Try using your corporate FQDN , such as: SQLPRODUCTION.corp.us.net


Test the connection directly in ODBC 32-bit Administrator.

-- See Print screen shown below.

-- Check the option for [X] Connect to SQL Server to obtain default settings.

-- Login ID: SIMSDBO
-- Password: SIMSDBO

-- Click [Next] button.
-- Success is if you can get to the next screen error free!






Sensory Computer Systems




Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    Sensory Computer Systems Forums Index -> Installation / Setup / Hardware All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group