I,m using SQL Server 2008 R2 express and i,m trying to use Linked server on a CSV file but i get the message 7303, level 16, state 1 Cannot initialize the data source object of OLE DB Provider. The message also says that the path to the file is incorrect.
But i,ve checked that the csv file acually is placed unde C and that i spelled the name correct. Is something wrong with my script or do i have to do anything that makes the server available (but i,m trying to do this on my C drive wher
SQL is installed it,s actually not on a different server)?
The file im trying to connect to is a test file that looks like this.
And the script i,m using looks like this.