Re: ODBC Setup

Hi ,

One common problem is odbc relies on the windows 'tmp (or
temp)' environment variable which must point to a folder
that does exist, so check that, if that
doesn't fix it get back to me. 

                     
           ChrisP


surgemail-listnetwinsite.com wrote on Tuesday, March 20,
2007 at 8:27 a.m. (-0800):
>
>I have an access database and a System DSN setup to the
database. simple 
>username and password (sa and sa) for testing only right
now, it's not set to 
>exclusive or read only.
>I set Active Module from NWAuth to ODBCAuth and
configured it.
>Database Driver=Southwest
>Database Username=sa
>Database Password=sa
>Table=SOUTHWEST (because the table is in all caps)
>Field Containing Usernames=USERID
>Field Containing Passwords=PASSWORD
>Field Containing Domain=Domain
>Domain Name feidl is blank
>I turned check crypt off
>When I save I get (-DEAD Failed to connect to database,
-1isk or
network 
>error.Driver's SQLSetConnectAttr failed)
>NTFS Security on the file shows Everyone with full
access.
>I'm not sure what I've done wrong, but I am sorry for
what shoud be a very basic setting.
>