|
|
You're in the
sql server programming
group:OPENROWSET using http
sql server programming:
Hello,
Thank you to oj who helped me get this far... I have one final question remaining with the OPENROWSET function... SELECT * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Text;Database=http://192.168.0.50/Texts/;HDR=YES;FMT=Delimited','SELECT * FROM TextFile1.csv') AS TableA When I attempt to run this I get the following error: Server: Msg 7399, Level 16, State 1, Line 6 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Internal internet failure.] The URL is correct as I can successfully get the directory listing. Any help with this would be great, however just to answer your questions... No, I can't simply use a directory listing such as C:\Texts\ or \\MyPC\Texts as these are unavailable in my situation. Thanks -Steve
Hi
I guess using a UNC address is also not possible? Having never used or seen openrowset being used in this way I can only guess that it is either permissions for the service account acessing http or permissions on the temporary directory such as http://support.microsoft.com/default.aspx?scid=kb;en-us;296711 You may want to request the file and handling into two stages. John [quoted text, click to view] "Anubis" wrote:
> Hello, > > Thank you to oj who helped me get this far... > > I have one final question remaining with the OPENROWSET function... > > SELECT * > FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', > 'Text;Database=http://192.168.0.50/Texts/;HDR=YES;FMT=Delimited','SELECT * > FROM TextFile1.csv') AS TableA > > When I attempt to run this I get the following error: > > Server: Msg 7399, Level 16, State 1, Line 6 > OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. > [OLE/DB provider returned message: Internal internet failure.] > > > The URL is correct as I can successfully get the directory listing. > > Any help with this would be great, however just to answer your questions... > > No, I can't simply use a directory listing such as C:\Texts\ or \\MyPC\Texts > as these are unavailable in my situation. > > Thanks > > -Steve > >
Hello John,
You guessed right.. UNC not possible... How could I split the process into two stages? Thanks -Steve [quoted text, click to view] "John Bell" <JohnBell@discussions.microsoft.com> wrote in message news:260DC50E-7DC3-473C-B7C2-0B0F318788D6@microsoft.com... > Hi > > I guess using a UNC address is also not possible? > > Having never used or seen openrowset being used in this way I can only guess > that it is either permissions for the service account acessing http or > permissions on the temporary directory such as > http://support.microsoft.com/default.aspx?scid=kb;en-us;296711 > > You may want to request the file and handling into two stages. > > John > > "Anubis" wrote: > > > Hello, > > > > Thank you to oj who helped me get this far... > > > > I have one final question remaining with the OPENROWSET function... > > > > SELECT * > > FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', > > 'Text;Database=http://192.168.0.50/Texts/;HDR=YES;FMT=Delimited','SELECT * > > FROM TextFile1.csv') AS TableA > > > > When I attempt to run this I get the following error: > > > > Server: Msg 7399, Level 16, State 1, Line 6 > > OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. > > [OLE/DB provider returned message: Internal internet failure.] > > > > > > The URL is correct as I can successfully get the directory listing. > > > > Any help with this would be great, however just to answer your questions... > > > > No, I can't simply use a directory listing such as C:\Texts\ or \\MyPC\Texts > > as these are unavailable in my situation. > > > > Thanks > > > > -Steve > > > > > >
OLEDB provider cannot reference an url as a datasource. Thus, you cannot
reference an url. The datasource has to be somewhere that sqlserver (executed under sqlserver service or proxy acct depending user's security level) can get to. 1. Read up on xp_cmdshell and pay attention to the proxy acct stuff; this should give you some understanding as to how sqlserver accesses network resources. 2. Read up on sp_oa*; you can access external data on the web by invoking 'msxml2' provider. [quoted text, click to view] "Anubis" <anubis@bluestreem.com.au> wrote in message news:OD7GqPDgEHA.2908@TK2MSFTNGP10.phx.gbl... > Hello, > > Thank you to oj who helped me get this far... > > I have one final question remaining with the OPENROWSET function... > > SELECT * > FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', > 'Text;Database=http://192.168.0.50/Texts/;HDR=YES;FMT=Delimited','SELECT * > FROM TextFile1.csv') AS TableA > > When I attempt to run this I get the following error: > > Server: Msg 7399, Level 16, State 1, Line 6 > OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. > [OLE/DB provider returned message: Internal internet failure.] > > > The URL is correct as I can successfully get the directory listing. > > Any help with this would be great, however just to answer your questions... > > No, I can't simply use a directory listing such as C:\Texts\ or \\MyPC\Texts > as these are unavailable in my situation. > > Thanks > > -Steve > >
Hello Oj,
I have got the OPENROWSET to work however the URL couldn't have any sub DIR's Database=http://server/folder <== Generated an error Datebase=http://server/ <== Retruned the results as did Database=ftp://server/ This functionality seems to be built into this function however it appears as though is isn't documented. Thanks to all for your help! -Steve [quoted text, click to view] "oj" <nospam_ojngo@home.com> wrote in message news:OtEmHuDgEHA.3428@TK2MSFTNGP11.phx.gbl... > OLEDB provider cannot reference an url as a datasource. Thus, you cannot > reference an url. The datasource has to be somewhere that sqlserver > (executed under sqlserver service or proxy acct depending user's security > level) can get to. > > 1. Read up on xp_cmdshell and pay attention to the proxy acct stuff; this > should give you some understanding as to how sqlserver accesses network > resources. > 2. Read up on sp_oa*; you can access external data on the web by invoking > 'msxml2' provider. > > > "Anubis" <anubis@bluestreem.com.au> wrote in message > news:OD7GqPDgEHA.2908@TK2MSFTNGP10.phx.gbl... > > Hello, > > > > Thank you to oj who helped me get this far... > > > > I have one final question remaining with the OPENROWSET function... > > > > SELECT * > > FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', > > 'Text;Database=http://192.168.0.50/Texts/;HDR=YES;FMT=Delimited','SELECT * > > FROM TextFile1.csv') AS TableA > > > > When I attempt to run this I get the following error: > > > > Server: Msg 7399, Level 16, State 1, Line 6 > > OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. > > [OLE/DB provider returned message: Internal internet failure.] > > > > > > The URL is correct as I can successfully get the directory listing. > > > > Any help with this would be great, however just to answer your > questions... > > > > No, I can't simply use a directory listing such as C:\Texts\ or > \\MyPC\Texts > > as these are unavailable in my situation. > > > > Thanks > > > > -Steve > > > > > >
Thanks for the update. I did not know such was even possible.
[quoted text, click to view] "Anubis" <anubis@bluestreem.com.au> wrote in message news:%23$jGWDMgEHA.2908@TK2MSFTNGP10.phx.gbl... > Hello Oj, > > I have got the OPENROWSET to work however the URL couldn't have any sub > DIR's > > Database=http://server/folder <== Generated an error > Datebase=http://server/ <== Retruned the results as did > Database=ftp://server/ > > This functionality seems to be built into this function however it appears > as though is isn't documented. > > Thanks to all for your help! > -Steve > > > > "oj" <nospam_ojngo@home.com> wrote in message > news:OtEmHuDgEHA.3428@TK2MSFTNGP11.phx.gbl... > > OLEDB provider cannot reference an url as a datasource. Thus, you cannot > > reference an url. The datasource has to be somewhere that sqlserver > > (executed under sqlserver service or proxy acct depending user's security > > level) can get to. > > > > 1. Read up on xp_cmdshell and pay attention to the proxy acct stuff; this > > should give you some understanding as to how sqlserver accesses network > > resources. > > 2. Read up on sp_oa*; you can access external data on the web by invoking > > 'msxml2' provider. > > > > > > "Anubis" <anubis@bluestreem.com.au> wrote in message > > news:OD7GqPDgEHA.2908@TK2MSFTNGP10.phx.gbl... > > > Hello, > > > > > > Thank you to oj who helped me get this far... > > > > > > I have one final question remaining with the OPENROWSET function... > > > > > > SELECT * > > > FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', > > > 'Text;Database=http://192.168.0.50/Texts/;HDR=YES;FMT=Delimited','SELECT > * > > > FROM TextFile1.csv') AS TableA > > > > > > When I attempt to run this I get the following error: > > > > > > Server: Msg 7399, Level 16, State 1, Line 6 > > > OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. > > > [OLE/DB provider returned message: Internal internet failure.] > > > > > > > > > The URL is correct as I can successfully get the directory listing. > > > > > > Any help with this would be great, however just to answer your > > questions... > > > > > > No, I can't simply use a directory listing such as C:\Texts\ or > > \\MyPC\Texts > > > as these are unavailable in my situation. > > > > > > Thanks > > > > > > -Steve > > > > > > > > > > > >
After a little more testing I have been able to suite it to my
application... It seems as though using FTP is the easiest way (and is quite quick too). With FTP I can use a sub dir such as ftp://server/folder and I can even use authentication such as ftp://admin:pass@server/folder Using http still generates an error of "Cannot find '' " but as long as FTP works I've got no problems. Thanks Oj for all your help you've certainly saved me some hair! -Steve [quoted text, click to view] "oj" <nospam_ojngo@home.com> wrote in message news:eRWUqPMgEHA.2812@tk2msftngp13.phx.gbl... > Thanks for the update. I did not know such was even possible. > > "Anubis" <anubis@bluestreem.com.au> wrote in message > news:%23$jGWDMgEHA.2908@TK2MSFTNGP10.phx.gbl... > > Hello Oj, > > > > I have got the OPENROWSET to work however the URL couldn't have any sub > > DIR's > > > > Database=http://server/folder <== Generated an error > > Datebase=http://server/ <== Retruned the results as did > > Database=ftp://server/ > > > > This functionality seems to be built into this function however it appears > > as though is isn't documented. > > > > Thanks to all for your help! > > -Steve > > > > > > > > "oj" <nospam_ojngo@home.com> wrote in message > > news:OtEmHuDgEHA.3428@TK2MSFTNGP11.phx.gbl... > > > OLEDB provider cannot reference an url as a datasource. Thus, you cannot > > > reference an url. The datasource has to be somewhere that sqlserver > > > (executed under sqlserver service or proxy acct depending user's > security > > > level) can get to. > > > > > > 1. Read up on xp_cmdshell and pay attention to the proxy acct stuff; > this > > > should give you some understanding as to how sqlserver accesses network > > > resources. > > > 2. Read up on sp_oa*; you can access external data on the web by > invoking > > > 'msxml2' provider. > > > > > > > > > "Anubis" <anubis@bluestreem.com.au> wrote in message > > > news:OD7GqPDgEHA.2908@TK2MSFTNGP10.phx.gbl... > > > > Hello, > > > > > > > > Thank you to oj who helped me get this far... > > > > > > > > I have one final question remaining with the OPENROWSET function... > > > > > > > > SELECT * > > > > FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', > > > > > 'Text;Database=http://192.168.0.50/Texts/;HDR=YES;FMT=Delimited','SELECT > > * > > > > FROM TextFile1.csv') AS TableA > > > > > > > > When I attempt to run this I get the following error: > > > > > > > > Server: Msg 7399, Level 16, State 1, Line 6 > > > > OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. > > > > [OLE/DB provider returned message: Internal internet failure.] > > > > > > > > > > > > The URL is correct as I can successfully get the directory listing. > > > > > > > > Any help with this would be great, however just to answer your > > > questions... > > > > > > > > No, I can't simply use a directory listing such as C:\Texts\ or > > > \\MyPC\Texts > > > > as these are unavailable in my situation. > > > > > > > > Thanks > > > > > > > > -Steve > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |