Re: Problem accessing SQL Express Server with ADO-Lib
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Thu, 10 Aug 2006 09:37:18 -0400
TGL wrote:
Hello!You probably need to enable the network library protocols (tcpip) for
I'm currently working on a Delphi-Application which needs access to
different databases. I found a nice component for using ADO, but i
fail to access the SQL Express server.
The server was installed when i installed Visual C# Express and is
usable in the Visual C# IDE without any problems.
The Delphi-ADO-component uses the official MS-dialog to choose
db-provider and database. The access to a mdb-database works perfect,
so i suppose, that the component works correctly.
If i choose "Microsoft OLE DB Provider for SQL Server" and server
"localhost" and then try to access the database-list, nothings
happend until timeout. The created access string looks correct, but
runs into a timeout every time:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=test;Data Source=localhost
The SQL Express server is on its default settings, what can i do to
get access?
your server. I know how to do it in SSMS but I don't know how to do it
in SQL Express. You should post to a sqlserver newsgroup. Please post
the resolution here if you find it.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Prev by Date: Re: How to select rows from a mapped protected .MDB and insert into local table
- Next by Date: Re: How to select rows from a mapped protected .MDB and insert into local table
- Previous by thread: Re: Prevent Commands in SQL Update
- Next by thread: Re: Problem accessing SQL Express Server with ADO-Lib
- Index(es):
Relevant Pages
|
|
