AccessQ + LocalDBQ

[Costas]

Really tired with the Access dbases. Still on 2016 seeing people using 'applications' (aka mdb/accdb) for their works. This tiny application comes to give a feeling of mdb query analyzer in 26kb.

Platform : C# 2010
Operating System : Windows

2000 /

XP /

2003 /

Vista /

win7 (32bit)
Requirements : v4 .NET framework
Filesize : 82kb

Download


Multi joins and string concatenation in Access file, working like :

SELECT    customers.fname & " " & customers.lname AS [Customer],
          peripheral.peripheral_type              AS [Peripheral Type],
          qty                                     AS [Quantity],
          date_sent                               AS [Date Sent],
          price                                   AS [Price],
          comments
FROM      ((orders
LEFT JOIN peripheral ON peripheral.peripheral_id = orders.peripheral_id)
LEFT JOIN customers ON customers.customer_id = orders.customer_id)
LEFT JOIN prices ON prices.peripheral_id = peripheral.peripheral_id WHERE orders.peripheral_id > 0

Having

SELECT recID
FROM Customers
WHERE (((Customers.[CustCODE]) In (SELECT [CustCODE] FROM [Customers] As Tmp GROUP BY [CustCODE] HAVING Count(*)>1 )))
ORDER BY Customers.[CustCODE];

---

similar - AlexNolan.MDB Viewer
similar - ETLools.Database Browser use (Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\x.mdb

 

[Costas]

LocalDB is a feature of SQL Server targeted to developers, but lately many applications use it as production database. This tiny application comes to give a feeling of LocalDB query analyzer in 27kb for .mdf files.

Platform : C# 2012
Operating System : Windows

2000 /

XP /

2003 /

Vista /

win7 (32bit)
Requirements : v4 .NET framework
Filesize : 16kb

Download

Required to be installed - SqlLocalDB.msi (choose the architect reflecting your system OS, the large is x64)

reference :
Microsoft - SQL Server Express LocalDB

#localdbq

---

as reminder : user can use the SSMS to connect to LocalDB, in such case, have to provide as connection string the

(localdb)\MSSQLLocalDB

the LocalDB files (aka .mdf & .ldf) in this situation exist to

%localappdata%\Microsoft\Microsoft SQL Server Local DB\Instances\vxx.x

---

Connecting to LocalDB by ASP Classic

using

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=#dbase_name#;Integrated Security=SSPI;"

you end up with :

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

versus SQLOLEDB we have to use the SQL Server Native Client (SQLNCLI or SQLNCLI11) provider.

objConn.ConnectionString = "Provider=SQLNCLI11.1;Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=#dbase_name#;Integrated Security=SSPI;"
'objConn.ConnectionString = "Provider=SQLNCLI11.1;Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=#dbase_name#;User ID=takis;Password=pipis2crew!@#$%;"

for a MVC Site see this.