Re: OS Authentication and ODBC

From: <tjmxyz_at_my-deja.com>
Date: 2000/05/04
Message-ID: <8erkqo$i5t$1@nnrp1.deja.com>#1/1

I am posting from experience in using VFP which would be much the same:

1. In the ODBC driver setup: Create a DSN with username= / and password empty and database=ORCL (or whatever yours is called)
2. When you connect use : SQLSETPROP("DISPLOGIN",1) SQLCONNECT("DSNNAME")

Main points are to create the DSN with user= / and a blank password.

The when you connect use SQLCON() or SQLSTRINGCONNEC() You may need to set the connection properites using SQLSETPROP. Look for the property DISPLOGIN and set it to never.

The functions in access should be almost identical...

HTH Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 04 2000 - 00:00:00 CDT