Re: OPENDATASOURCE problem
From: Steve Kass (skass_at_drew.edu)
Date: 07/21/04
- Next message: x-rays: "Re: Return Value of a SP"
- Previous message: pmcguire: "Re: Determining if a bit is set"
- In reply to: Mihaela M.: "OPENDATASOURCE problem"
- Next in thread: Mihaela M.: "Re: OPENDATASOURCE problem"
- Reply: Mihaela M.: "Re: OPENDATASOURCE problem"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 10:50:19 -0400
Mihaela,
See http://support.microsoft.com/default.aspx?scid=kb;en-us;327489
Steve Kass
Drew University
Mihaela M. wrote:
>Hello.
>
>I have the following sql sequence in my ASP file:
>
>conn.Execute "INSERT INTO
>OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Driver={Microsoft Text Driver
>(*.txt; *.csv)};Dbq=c:\myfolder\;Extensions=asc,csv,tab,txt')...myfile.csv
>SELECT Autoid FROM tbl_CLASSES"
>
>where "conn" is a connection to a SQL Server database.
>tbl_CLASSES is an SQL Server table.
>I want to select all records from tbl_CLASSES table and to insert them in
>"myfile.csv" file
>
>But it returns me an error:
>Microsoft OLE DB Provider for SQL Server error '80040e14'
>
>Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied.
>You must access this provider through a linked server.
>
>It should work without linked server, because OPENDATASOURCE "Provides ad
>hoc connection information as part of a four-part object name without using
>a linked server name."
>(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts
>_oa-oz_78z8.asp)
>
>Could anyone help me? I have no idea where I do wrong.
>
>Thanks!
>
>
>
>
- Next message: x-rays: "Re: Return Value of a SP"
- Previous message: pmcguire: "Re: Determining if a bit is set"
- In reply to: Mihaela M.: "OPENDATASOURCE problem"
- Next in thread: Mihaela M.: "Re: OPENDATASOURCE problem"
- Reply: Mihaela M.: "Re: OPENDATASOURCE problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
