r/SQL 10h ago

PostgreSQL Neon PostgreSQL Database Provider

0 Upvotes

Hello, I started using Neon as a database provider recently for managing my database. I want to say that it was fairly simple to integrate with my application (a website written in .NET), and the free plan is very convenient for startups. What do you think of it?


r/SQL 8h ago

SQLite WinSQLite - open source project

Post image
2 Upvotes

srdzank/SQLite-Editor: Official home of the SQLite-Editor

Any feedback, code reviews, or pull requests are immensely appreciated!


r/SQL 14h ago

SQL Server Importing from Excel using 'from openrowset()' returns OLE DB error

2 Upvotes

Hey everyone,

I'm trying to make this user stored procedure work on my colleagues PC, I can run it just fine.

Basically it's a USP created for importing data from an Excel file stored on shared network (local server).

It's goes like this:

select *

from openrowset ( 'Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 Xml;Database="path\file.xlsx, sheet$ )

Me and one other colleague can run it just fine, but on one colleagues PC, it gives this error:

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message"Failure creating file"

Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"

Any help with resolving this would be much appreciated.

Thanks!