.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Is a 64-Bit Microsoft text driver available

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server

I am trying to obtain a 64-bit  "Microsoft Text Driver (*.txt; *.csv)" driver  so that I can access csv files. Does one exist?

I am using sqlserver 2005 x64 and have installed the 64-bit version  MSDASQL
My goal is use openrowset as follows

from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; 
'select * from testdata.csv'

View Complete Post

More Related Resource Links

ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).


I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
Stack Trace: 

[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

Localization for command text Microsoft Ribbon for WPF

Hello, Is there any way I can localize the command text that comes with the ribbon, like the commands in the Ribbon context menu?   Add to Quick Access Toolbar Add gallery to Quick Access Toolbar Remove from Quick Access Toolbar Show Quick Access Toolbar above the Ribbon Show Quick Access Toolbar below the Ribbon Minimize the Ribbon Maximize the Ribbon   I got this list from the Source -- \Resources\ExceptionStringTable.txt

Microsoft SQL Server 2005 JDBC Driver

I'm getting the following exception when attempting to connect to SQL Server 2005 using Microsoft's new JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host  has failed. java.net.ConnectException: Connection refused: connect The help docs suggest checking connectivity using telnet. So attempting to connect via telnet to generates: Could not open connection to the host, on port 23: Connect failed. So I try to start telnet: net start telnet I get the following error message: The service cannot be started either because it is disabled or because it has no enables devices associated with it. Can anyone help? Thanks

Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not e

Hi All, When we try to connect to a sql server 2000 using SQL server authentication, we are facing the below mentioned error msg. "Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied" But, once we connect to server using Windows NT login from the client machine, i.e., execute the below command in the run prompt and provide the credentials for windows login, we are able to connect to the server using sql server authentication(user name: sa) \\server_ipaddress\c$ When we went though some of the msdn links, found that windows firewall was the major cause. But, in the server 1. Windows Firewall is turned off 2. TCP/IP and NamedPipes are enabled 3. Default Port Number is 1433 Any user, who wants to connect to the SQL Server using SSMS, first have to perform a Windows NT login and then connect using SQL authentication.  Due to the above error, the DTS packages which are executing in a different server are getting failed. NOTE: Even after connecting to the server using Remote Desktop connection in a local machine, SQL authentication fails. Its manadatory to run the command \\server_ipaddress\c$ in each of the local machine. Any suggestion to resolve the above error is very much appreciated.   Thanks in advance, Raksha Hegde       

Microsoft JDBC driver 3.0

Our application used Inet opta driver. Would like to try out the Microsoft driver. If you have used this driver, please provide more info on Microsoft jdbc driver 3.0.

"Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no def

When i attempt to fill my Crystal Report -named limitler.rpt and it is under the sub-folder Oraburslar of my project -, i get the following error; "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Error in File C:\DOCUME~1\KEMAL~1.ESM\LOCALS~1\Temp\limitler {148B6FE6-D5BE-4BC3-A13A-47CCCB79D78B}.rpt: Unable to connect: incorrect log on parameters." How can i handle this pro? Thanks in advance... Here is how i connect to database to fill the Crystal Report:string database = ConfigurationManager.AppSettings["Database"].ToString(); string password = ConfigurationManager.AppSettings["Password"].ToString();string username = ConfigurationManager.AppSettings["Username"].ToString(); string server = ConfigurationManager.AppSettings["Server"].ToString();ReportDocument report = new ReportDocument();report.Load(Server.MapPath("~/Oraburslar/limitler.rpt")); report.SetDatabaseLogon(username, password); CrystalReportViewer1.ReportSource = report; CrystalReportViewer1.BackColor = System.Drawing.Color.White;

64 bit ODBC driver for Microsoft Access

Hello,I am trying to connect to one of my Access databases (.mdb file on my local) from ODBC connection. The problem is, I am using 64-bit Xp Pro and it does not see any Access driver on 64-bit architecture. Does anybody have 64-bit compatible ODBC driver for Microsoft Access ? Any other help also will be appreciated....

ODBC--call failed.[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismat

I need to establish a connection between an Access 2003 database (32 bit) and an 11g 64 bit Oracle database on a server. I am running Windows 7 on a 64 bit laptop. I did a clean install of Oracle 11g for 64 bit. I have no problem accessing the Oracle database via the Oracle SQL Developer. I just have a problem from within Access. I hope someone can help me. I've been fighting this for several months. Thanks in advance!

Convert Text to Numeric in reports generated by Microsoft SQL Server 2000

Our programming team is producing Excel reports using Microsoft SQL Server 2000 and cannot seem to find a way to produce numeric data as numeric.  It is being produced in the spread sheet as text (with the green triangle in the corner of the cell).  If the user viewing the report has an older version of Excel they cannot even convert it to numeric manually. 

Is there a way to produce numeric data as numeric in the Excel report?

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


trying to install sql server2005 on a windows 2003 server box.

getting msg below at the sql server .  i looked at other posts on trying to uninstall  SQL Native Access Client and norton antivirus.  i could never find the snac on the add - remove programs and this server does not have a virus protection program yet.

here's the history of the installs on the server:

wanted to test a 2005 upgrade so:

  1) installed sql server 2000 then sp4 then restored some databases to it - all OK

  2) tried to upgrade to sql 2005 but ran into problems and left it at that.

had a disk drive crash on the d drive so lost the installs but not the operating system

when the drive was replaced, left alone for a while

then wanted to test a straight 2005 install

  1) removed the broken 2005 attempt

  2) removed the 2000

  3) installed 2005 and got the error on the subject line:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in S

OPENROWSET 'Provider String' Documentation? Firstrow for Text Driver, Column names in 3rd row


I'm using sql server 2008 r2 express and want to write a script to load data from some csv files.


The following gets me close:




        'Driver={Microsoft Text Driver (*.txt; *.csv)}; DEFAULTDIR=C:\Data\QOL;Extensions=CSV;',

        'SELECT * FROM RegistrationData.csv')


The problem is that the that the first two lines are not data (Report Name and time generated) and the third line is the column names. If I manually open the file and delete the first two rows everything comes out perfectly. But there are a number of these files and it has to be done regularly so I want to automate the process.  BULK options allow a FIRSTROW option but that doesn't seem to work w/o the BULK option. Is there a way to effectively skip the first 2 lines w/o the BULK option (and its requisite format file)?

ODBC text driver doesn't read columns containing double quotes



I'm having some trouble with importing some information from a delimited text file into an SQL database. I made a DSN for the file using the  Microsoft ODBC driver. It reads most of the data fine. I can get most of it into the database, or using Excel I can display it in a table.

This is a regular text file, the delimiter is a "|" character. Some of the data has double quotes embedded in it. Every time it hits one of these double quotes, the rest of the information on that line are ignored.Then it will move on to the next line in the file.

Is there a way to set up the driver to read these quotes somehow, or to just ignore them?

Microsoft SqlSrv driver for php causes PHP to crash


First, sorry for my english, i'm a french guy !!

I work on a web site which runs fine for several month. Zend and a SqlServer database with the SqlSrv driver from microsoft.

I now work on a new controller and i'm trying to save row on table i've been only reading until now. FYI, the table is pretty large.

So i create my row, populate it from my form and :


I try catch this line but the catch block isn't executed at all.
I see an error 500 in the access.log but no other error in php_error.log or apache error.log. Only these lines in the zendEnabler.log :
[18/10/2010 13:43:40] Error: Read data error - unable to get read result. Code 109.
[18/10/2010 13:43:40] Error: Request for C:/Program Files (x86)/Zend/Apache2/htdocs/****/public/index.php: Unable to get the response from PHP process
[18/10/2010 13:43:40] Error: PHP process 19920 from the "application/x-httpd-php" pool has exited with status 255.

The line in the sqlServer table is create with all the information i set in the row. 

My brother ask me to save a txt file which contai

Websphere with Microsoft SQL JDBC Driver 2.0 eats up CPU when StaleConnection is encountered


Here's what happened

1. SQL Server started as a service

2. Websphere (with JDBC Data Source utilizing MSSQL JDBC Driver) is started via startserver.bat

3. I ran my application a few times (which accesses the database)

4. I restart the MSSQL Service

5. I click on a button that attempts to query the database

6. CPU utilization of websphere shoots up and doesn't return to 0 (unless you restart websphere)


To investigate I isolated the DataSource and Connection object generation in a Serverside script and that seems to work fine but when you put them inside Stateless, Container Managed Session Beans then it sort of goes into limbo.  Weird thing is that the same code, when using DataDirect, works well.

However, since it seems like DataDirect is not packaged with websphere anymore, Im left with no option but to use MSSQL JDBC Driver.  Any thoughts on how I can reclaim those CPU resources?  Unfortunately, a try catch doesnt help since program hangs when it executes Connection.execute() - meaning it doesn't reach the catch part

[Microsoft][ODBC Driver Manager] Data Source name not found and no device driver specified

I get the above error message when running my VB6 sp4 application on a new Win7 workstation (32 bit machine). The app runs fine on a WIn xp sp3 workstation. The app does require a DSN setup in the ODBC section and I setup the SQL connection the same as I do on an XP machine. I also test the connection on the WIN & machine and it "test successfully". After the error above the app returns a runtime error -2147467259 (80004005). I am attaching my connection string:
Connection string being used by ADO Data Control (part of VB6):
Any help would be appreciated.


Microsoft Paradox Driver ODBC


Is it possible to install  and where do I obtain the Microsoft ODBC Paradoc Driver for Windows 7? I can't seem to locate it in the ODBC Datasources Administrator like I could in WinXP and Vista on the drivers Tab.

Thanks Jon

Thank You Jon Stroh

Microsoft AJAX CDN

Content delivery networks (CDNs) are composed of "edge cache" servers that are strategically placed around the world at key Internet network points. These "edge cache" servers can be used to cache and deliver all types of content - including images, videos, CSS and JavaScript files.

Using a CDN can significantly improve a website's end-user performance, since it enables browsers to more quickly retrieve and download content. For example, instead of having a browser request for an image traverse all the way across the Internet to your web server to download, a CDN can instead serve the request directly from a nearby "edge cache" server that might only be a single network hop away from your customer (making it return much faster - which makes your pages load quicker).
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend