Search results for query: *

Greetings, Does anyone know what this means and how to deal with it? I get the error when trying to write to a dBASE file using the OPENDATASOURCE command. This used to work and I haven't changed anything! See below for query. Thanks for any help. Here's the error ... Server: Msg 7331...

Greetings, Is it possible to use OPENDATASOURCE with variables? Something along the lines of ... declare @strProvider varchar(100), @strParams varchar(100) select * from opendatasource( @strProvider, @strParams )..<file name> Any ideas? Thanks for your help

Greetings, I have a directory on the network called 0:\ESPEC\PDM, which contains dBASE files (*.dbf). I have created a linked server in SQL Server using the following command: exec sp_addlinkedserver @server='Test2', @srvproduct='db5', @provider='MSDASQL', @datasrc='PDMdBASE' I...

Greetings, Does anyone know how to connect SQL Server to a DBase (.dbf) file and update it using rows from a SQL Server table. Thanks for your help.

Greetings, Can anyone help?? ANY help would be GREATLY appreciated. I have a function that uses stuff() to place characters at specific positions within a column. It works when run independently but not as part of an UPDATE 1. I have a table called db.NewArticleCode with the following row...