ODBC setup on NT webserver...help!

[surfmaster2000]

Ok, first off. Im not sure if this is the appropriate area of the forum for this question, but here goes:

I am creating a new feature for my employers website. I would like to allow a potential customer to enter his/her zipcode and be presented our company information that pertains to his/her area. I have a working ODBC connection to an access database and I have created the two web pages needed using the features built into dreamweaver MX. I have everything working wonderfully on my desktop PC running XP Pro, and built in IIS for testing purposes. Now I want to implement this on our company NT webserver. This is where I run into problems...I am unable to add an ODBC connection on the NT server. I go control panel>odbc connections>system DSN. When at system DSN tab I am prompted to select type of database. I choose the "microsoft access driver". It then shows the screen that would allow me to name the connection, give it a description, select the database in my file system, etc. There is an "ok" button at the upper right hand of the screen that must be clicked when I have completed entering my information. The "ok" button remains greyed out no matter what I enter or select. I can enter all of the necessary information, but can never click "ok". I cannot determine why this button stays greyed out. does anyone know or suggest anything? The "ok" button is greyed out on my XP desktop also, but the moment I enter a character into the text boxes it blackens and is then clickable. See pictures to illustrate. The images are from my XP desktop but the screen is identical to the NT screen.

Thanks for any help!!

Jeremy

[IMG]http://[/IMG]

[faulkner132]

Maybe this isn't what you want to do, but have you tried connecting through a server created object?
I am assuming you are using ASP.

Dim MyConn
Dim strConn

Set MyConn = New Server.CreateObject("ADODB.Connection")

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
   "Data Source=C:\...\Database.MDB;" & _
   "Jet OLEDB:Database Password=MyPwd"
MyConn.Open strConn

DSN's are pretty dated and I have not used those in years.

[surfmaster2000]

faulkner132, thanks for the reply. I am using ASP. I am kinda in-experienced in this area but i'm a pretty quick learner. I got the whole thing working on my own. So don't think i'm stupid when I ask, where do i place this code you have provided?

I am using a page called lookup.htm which has a textbox and a submit button.
then I have a results.asp page that returns the filtered results of the textbox.

I will try this, but I think there is somthing wrong with my server or it's configuration that could be causing the problem.

Thanks,
Jeremy

[faulkner132]

The easiest place is at the top of your results.asp page. This will create (and destroy) a connection each time the page is created.

Here is a complete example which may help you a bit more:
http://support.microsoft.com/kb/q165671/