Open RowSet syntax please? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Open RowSet syntax please?

Author

Topic

mure_us
Starting Member

2 Posts

Posted - 2007-01-11 : 22:50:41

Hi..I am trying to read text file using OpenRowSet function for this my DBA was created linked Server with Name "DBLServerText", my text file path c:/txtcount.txt. Please guide me syntax any one have idea.

I don't have access on XP_CMDSHELL & BULK Insert commands.

DTS package is also not allowing.

as per my knowledge, I have only one option that is OpenRowset.

Please help me the syntax using with Linked Server. with Linked it is showing the error. " You don't have OLEDB access use with Linked server"

Pls guide me

Thanks in Advance..
Mure

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-01-11 : 23:16:50

do you know if OPENROWSET is enabled on your server? often it's disabled as well.

www.elsasoft.org

mure_us
Starting Member

2 Posts

Posted - 2007-01-12 : 12:59:48

Hi,

I am very new for SQL development.
Please guide me how to check OpenRowset is enabled or disabled?

Thanks a lot

Mure

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-01-12 : 13:36:29

actually, i think i confused myself. it's not OPENROWSET that's often disabled (I don't think it can be), it's that remote servers in 2005 often don't allow you to connect to them via an ad-hoc query in OPENROWSET. More details here: http://msdn2.microsoft.com/en-us/library/ms188313.aspx

but this doesn't apply to you, since you aren't connecting to a remote server, but to file. This article may help you, it shows how to use OPENROWSET to open a file: http://www.databasejournal.com/features/mssql/article.php/3584751

www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources