Will it cause the Issue.? Keep your finger on the pulse of the ecosystem by subscribing. I ended up going with “bulk insert” to do the job, and it works brilliantly. Thanks for this – I’m sure you’ll help others users in the future. In order to participate you must be a registered DNNizen.

Uploader: Nikogis
Date Added: 18 March 2009
File Size: 64.50 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 26786
Price: Free* [*Free Regsitration Required]

How can I find a method that should work on any machine? Thursday, July 23, 7: Bulk insert is probably more reliable, as there are no dependencies it relies on functionality contained inside Microsoft SQL Server R2.

Remove From My Forums. Thank you for your interest in this question. If I can understand why there might be two or them then I might be able to work out the problem.

I’m going to award the answer to you, as all Msdaasql wanted to know is whether it works on Win7 x64 out of the box. I ended up going with “bulk insert” to do the job, and it works brilliantly.

When i have installed the provider available on this link http: It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog mxdasql and notable tweets.


This way is the most flexible one because it allows to specify many additional parameters in the ksdasql string and override standard Exportizer connection behavior. Has anyone successfully run this command on Win 7 x64?


What should I be looking for in the registry? Opening by specifying file name interface: Do i need to create any new connectionStrings in web. Page 1 of 1. I just now tried a file with only ‘ten,four’ in it and it worked. This includes promotion of commercial tezt non-commercial products or services which are not directly related to DNN.

SELECT * FROM OPENROWSET (‘MSDASQL’) – SQL Server Q&A from the SQL Server Central community

Thank you for taking the time to post. But it is recommended basically for advanced users.

Here are basic connection strings more examples and details can be found in the Internet:. Friday, July 24, 6: Select ‘Connection string’ option and write a connection string. Note that the syntax in specifying the drive must be exactly the same. If someone posts about a vendor issue, allow the vendor or other customers to respond. It works on an out-of-the-box Win7 x64 machine, but I still can’t fix this error on my machine.


I have the feeling it is something to do with registry settings or DLLs. I’ve also tried it on Windows Vista x32, same error. Will it cause the Issue.? I’ve just wrestled with this issue for several hours on a Txet x64 machine, and it is so difficult to find a good answer online that I thought I’d contribute jsdasql to this thread belatedly.

If you have problems with opening text or Texxt file in Exportizer or its field structure is not as you expected, it probably means that the file does not have a texf describing its field structure or the schema was incorrectly defined. Stack Overflow works best with JavaScript enabled.

Contango 40k 48 Therefore, they are essentially identical and can be used interchangably. You must access this provider through a linked server. Select ‘File’ option and then browse for the needed file.