Re: Using OLEDB from ActiveX DLL

You did not say how you got it connected via ODBC (DSN-less connectionString
or creating User/System DSN? But why use ODBC anyway?). It is simply a SQL
Server Login issue. Since you supply User ID and Password in the
connectionString, it means the SQL Server's Login mode should be "mixed".
Are you should the Mixed Login Mode is enabled when you installing the SQL
Server Express (by default, it is not enabled!)? What do you mean "The
password would ne my system password"? Is it your windows log in password?
If so, you got it all wrong. The User ID and Password should a SQL Server
login name and password (if you enabled SQL Server Mixed Login mode). More
study on SQL Server security might get you to right direction.

"Michael Powe" <michael+gnus@xxxxxxxxxxxx> wrote in message
news:uu05ln1el.fsf@xxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • RE: Getting Challenged when using SQL connection on .aspx page
    ... What would happen if i removed integrated security=sspi from the connection ... Just want the login token to be passed, ... Have webpage with following connection in the ... I have account to the database on the SQL server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL.Net connection in VS2005 from local IIS to local SQLExpres
    ... I guess the obvious question would be is there a login defined in SQL Server ... Look at the connection string for the ...
    (microsoft.public.sqlserver.connect)
  • Re: Creating tables
    ... As far as I can tell, it won't do that if you are not using ODBC. ... > type The data type of field in the new table. ... > You just issue the correct table statement on a SQL connection and it ...
    (comp.lang.cobol)
  • Re: how to connect the access to the sql
    ... I go via the ODBC route ... >i know vba code but, ... > but i don't how to write the code to build the link that access to sql ... >> To link in Access to SQL you can use an ODBC connection ...
    (microsoft.public.access.gettingstarted)
  • Re: Restrict access to SQL database through ODBC
    ... If the application reports it's name to SQL (which they ... everything that connected to that database of a different application name ... > requires access through an ODBC DSN to my SQL Server ... > run sp_setapprole on that connection. ...
    (microsoft.public.sqlserver.security)