RE: Windows Services and SQL Server
- From: Peter Bromberg [C# MVP] <pbromberg@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 4 May 2007 05:53:00 -0700
There are managed providers for Oracle, MySQL and other RDBMS's. If you use
the Enterprise Library Data Access Block, these only need to be specified in
the configuration file. Your code does not have to change.
Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net
"Diogo Alves" wrote:
yes there is a reason....
Where planning in the future use more than one database type... maybe oracle
and/or mysql
Since there is that option in the future we prefer to use odbc
"Peter Bromberg [C# MVP]" wrote:
If you are using managed code, is there any reason why you can't use the
SqlClient class with a regular SQL Server login? e.g.,
server=myserver;database=dbname;uid=user;pwd=password;
--Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net
"Diogo Alves" wrote:
Greetings everyone,
I am trying to access my SQL Server 2005 database with a windows service,
the problem is that I can't access it!
It says ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'ONEWORLD\N5DALVES$'.
ONEWORLD is my domain, N5DALVES is my computer name.... the $ appears there
like magic...
in the SQL Server I don't have that user... I have ONEWORLD\DALVES...
that's my username in the intranet...
How can I avoid this? I tried to use this connection string:
DSN=MyDataSource;Uid=TimeFiveUser;Pwd=_TimeFiveUser_;
I'm using ODBC Drivers
- Prev by Date: Re: SSLStream
- Next by Date: Re: column.expression
- Previous by thread: save bit as 0 or 1not true or false
- Next by thread: Re: Windows Services and SQL Server
- Index(es):
Relevant Pages
|
