ODBC/DSN - Creating | NT 4.0 Home Page |
Create an ODBC DSN in Windows NT
Go to the control Panel and open the ODBC32 program by double clicking on the icon
The ODBC administrator window will open.
Click on the SystemDSN tab
press the Add button on the right side of the window
The "Create New Datasource" Window will appear.
Click on the SQL Server entry in the list shown and Press the Finish button.
The ODBC SQL Server Setup window will open.
Place the cursor inside the Data Source Name white text box area and type TS_jobs (you can normally name this anything you want but for this tutorial make it TS_jobs ).
Next Click inside the "Description" text box and type in the name of the server.
Next click on the down arrow found to the right of the "Server" text box
When you click on the down arrow, depending on whether you use NT or windows 95, you will either get [local] or a blank entry.
In Windows NT 4.0 you want to a) select [Local] if you are working on the same computer where SQL server is running, or b) type in the name of the SQL server computer where SQL server is running. In this case SQL server is running on a different computer ( ie cyrixnt) and you would type in the server name for the DSNs made on windows 95 computers.
The Network Address and "Network Library" should be left as they are showing [Default] in the text boxes as shown below
Next press the Options button
The ODBC SQL Server Setup window will now also be shown (the bottom half of the window was previously hidden.)
Place the cursor in the Login Database text box and type "TechSrcDB",
and leave the Language name as is [Default].
Next check the "Generate Stored Procedure for Prepared Statement" box by clicking on it with the mouse.
Finally press the OK button.
You will now be back in the "ODBC Data Source Administrator" window. Close it by clicking at the on top right corner of the window.
You will now be in the control panel, close that as well by clicking on the on top right corner of the window.
Now the ODBC connection to SQL server is finished and ready to be used.
Continue at the "3) Open Front Page 97" section
|You are at the www.techadvice.com site which is not associated with the company or products shown on this page.|