Re: Using OLEDB from ActiveX DLL
- From: Paul Clement <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx>
- Date: Thu, 13 Jul 2006 11:23:05 -0500
On 13 Jul 2006 08:18:42 -0400, Michael Powe <michael+gnus@xxxxxxxxxxxx> wrote:
¤ Hello,
¤
¤ I have written an ActiveX DLL that does lookups in a SQL Server
¤ Express 2005 via ODBC. This works fine but is horribly slow. I would
¤ like to test the possible speed improvement with an OLEDB connection,
¤ but can't make it work. All I get for an error is "Login failed for
¤ user 'powem' [CLIENT: <named pipe>]" in the Event log. That user is
¤ my local Windows login. I've also tried with a database user that I
¤ created, I get the same result & message. These users work with
¤ ODBC.
¤
¤ I'm testing on a WinXP Pro machine, using VB 6 to write the DLL.
¤
¤ The connection string for OLEDB:
¤
¤ "Provider=sqloledb;Data Source=pdxpowem01\SQLEXPRESS;
¤ Initial Catalog=mycatalog;User Id=powem;Password=mypassword"
¤
¤ Of course, in the code that is all one line. The password would be my
¤ system password.
¤
¤ What am I missing about making the OLEDB connection, that is causing
¤ the login to fail?
Replied in microsoft.public.vb.database.
Paul
~~~~
Microsoft MVP (Visual Basic)
.
- References:
- Using OLEDB from ActiveX DLL
- From: Michael Powe
- Using OLEDB from ActiveX DLL
- Prev by Date: Re: VB and dll's
- Next by Date: Calendar Form
- Previous by thread: Re: Using OLEDB from ActiveX DLL
- Next by thread: Re: Using OLEDB from ActiveX DLL
- Index(es):
Relevant Pages
|
