Using OLEDB from ActiveX DLL
- From: Michael Powe <michael+gnus@xxxxxxxxxxxx>
- Date: 13 Jul 2006 08:18:42 -0400
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?
Thanks.
mp
--
'cat' is not recognized as an internal or external command,
operable program or batch file.
.
- Follow-Ups:
- Re: Using OLEDB from ActiveX DLL
- From: MikeD
- Re: Using OLEDB from ActiveX DLL
- From: Paul Clement
- Re: Using OLEDB from ActiveX DLL
- From: Norman Yuan
- Re: Using OLEDB from ActiveX DLL
- Prev by Date: Re: vb6 bcoming irrelevant?
- Next by Date: Comments/education VB6 limitations?
- Previous by thread: Proper use of DoEvents?
- Next by thread: Re: Using OLEDB from ActiveX DLL
- Index(es):
Relevant Pages
|
