Received: from news.tht.net (news.hub.org [216.126.91.242]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA12954 for ; Fri, 14 Jan 2000 17:23:05 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.9.3/8.9.3) id RAA51148 for pgsql-general@postgresql.org; Fri, 14 Jan 2000 17:20:25 -0500 (EST) (envelope-from news) X-Authentication-Warning: news.tht.net: news set sender to using -f Message-ID: <387FA13A.1C926363@earthlink.net> From: rut X-Mailer: Mozilla 4.7 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.questions Subject: sql question Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 29 X-Complaints-To: abuse@earthlink.net X-Trace: newsread1.prod.itd.earthlink.net 947888210 206.133.64.168 (Fri, 14 Jan 2000 14:16:50 PST) Organization: EarthLink Network, Inc. X-ELN-Date: Fri Jan 14 14:16:50 2000 Date: Fri, 14 Jan 2000 22:16:50 GMT To: pgsql-questions@postgresql.org Using vb6 and ado 2.1 if I open a connection string like so: Public Sub setup() Dim cnn1 As ADODB.Connection Dim rstEmployees As ADODB.Recordset Dim strCnn As String Dim varDate As Variant ' Open connection. strCnn = "Provider=sqloledb;" & _ "Data Source=srv;Database=db; " Set cnn1 = New ADODB.Connection cnn1.Open strCnn End Sub Will this code still try to send the username (machine name) to the sql server for authentication even though it is not explicitly sent here? Also, If the Provider is not specified, does the system revert to an odbc driver vs the ole driver? Please email if possible: rutledgj@earthlink.net