Search results for query: *

We are holding our data in a centralised SQL Server database, and then using the SQL Server database to "publish" data to other systems (ASP.NET, VB.NET) and databases (dBASE, MS Access, Progress) Any help on this will be greatly appreciated. Regards.

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...

Thanks for your help, I decided to use the CURSOR because speed was not an issue. Regards.

Thanks for all your help. I decided to use the OPENDATASOUCE cammonad to access and update the dBASE files. Regards.

Thanks for all your help. I decided to use the OPENDATASOUCE cammonad to access and update the dBASE files. Regards.

Thanks for all your help. I decided to use the OPENDATASOUCE cammonad to access and update the dBASE files. Regards.

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

I would like to use the linked server, but I'm having problems with it. Any help will be greatly appreciated: I created the linked server using: sp_addlinkedserver @server='PDMdBASE', @srvproduct='dBASE 4', @provider='MSDASQL', @datasrc='PDMdBASE' PDMdBASE is a System DSN (ODBC data...

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...