Connect Delphi to SQL database

sql-server delphi sql-server-2008r2-express
Ouerghi Yassine picture Ouerghi Yassine · Nov 20, 2012 · Viewed 20.6k times · Source

I'm using Microsoft SQL Server R2 Express to create databases.

When I try to connect to a database using delphi, I have to use this Connection string : 

ADOConnection1.ConnectionString := 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=db_formation;Data Source=EVILKID-pc\evilkid;';

where "EVILKID-PC\evilkid" is the name of my pc, enter image description here

As you can seem this will only work on my PC. What should I do to make it connect to localhost? I have tried changing the "Data Source" to "localhost" but it would not connect and I would get:

[DBNETLIN][ConnectionOpen(Connect()).]SQL Server does not exist or access denied

Any idea where the problem is?

Answer

Michael Fredrickson picture Michael Fredrickson · Nov 20, 2012

Even though your instance is on localhost, it's still a named instance that you'll need to specify in your connection string:

ADOConnection1.ConnectionString := '... Data Source=localhost\evilkid;';

Related questions

ms sql xml data type convert to text

in MS Sql there are data types that are not supported by delphi 7, the xml datatype is one example. I wish to convert the XML datatype to Text datatype, so that i could handle it in delphi. Is there a …

Read More
Delphi: how to pass a list as a parameter to a SQL query?

I have a list of integers or of strings and need to pass it as a parameter for a Delphi DataSet. How to do it? Here is an example. MyQuery is something like: select * from myTable where intKey in :listParam …

Read More
A better way of passing parameters to a TADOStoredProc (Delphi)

I am needing to convert a large amount of SQL queries into stored procedures. I have some code that updates about 20 or 30 values at one time in one Delphi procedure. I can handle creating a stored procedures to do such …

Read More