.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

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

Posted By:      Posted Date: August 23, 2010    Points: 0   Category :ASP.Net

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

View Complete Post

More Related Resource Links

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       

"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!

Odbc Driver error

i try to install Goldmine ver 9x client today on new Win 7 Pro 32 bit PC. Goldmine Server is - MS SQL 2008 When I select SQL as my connection type i get the errror  "the setup routines for SQL server ODBC driver could not be accessed. Please reinstall the driver"   I have tried to re register the dll  by running " regsvr32 odbcconf.dll " I have also checked the registry and the values for SQL connection are corrent

[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

How to fix "ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone awa


Hi Experts ,

I have hosted my web application into server . I got below error on and off but when i refresh the page , the error disappear . Im unable to figure out what is the problem because the error is normal happen after using the application about 10 to 20 mins . But when i run in localhost , there is no problem at all .  

I read lot of articles and testing on it but still failed .  Pls help . Im using asp.net C# and mysql .

Million Thanks ..




ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and lo

ODBC Driver Error

Hello.  We just purchased new computers with Windows 7, and have run into many issues with the program called Sportspak, which is housed on our SQL server, running Windows SQL 2003.  We were able to run the program in Administrator Mode, but cannot access some of the features on the program.  The program worked fine in Windows XP.

The error is:

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

This error occurs when we try to access database portions of the program.  Any help or direction would be greatly appreciated.  Thank you


Microsoft Visual C++ Runtime Library Error when installing .NET Framework 4.0


For some reason I'm unable to install .NET Framework 4.0. I downloaded the stand-alone install file from Microsoft Download Centre after the web installer didn't work but it still doesn't work. Next I tried removing all the previous installatiosn of .NET Framework using the Cleanup Tool found on here - http://blogs.msdn.com/b/astebner/archive/2008/08/28/8904493.aspx - and clearing the TEMPS folder but it didn't change anything.

Every time I try to install .NET Framework 4.0 I get this message:

"Microsoft Visual C++ Runtime Library

Runtime Error!

This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information."

After updating, the error occur at ODBC driver


Hi everyone,

I am maintaining a website of a department in my school.
The web about database (using SQL and .asp files to connect the database *.mdb) works  normally before.

Without any modification about the files but updated the Windows Server 2003 , the web suddenly get wrong.

Every time I open the web that connect to the database, it always show up the following message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver].... 'Temporary (volatile) Jet DSN for process 0x980 Thread 0x166c DBC 0x7c161cc Jet'?

For solving the problem, I found out the error may about the ODBC driver, 
It said some path are cleared by the updating. 
However the setup is already done when I took the job, therefore I don't know how to find the path back about setting ODBC driver.
Could anyone help me

[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.


VSShellInstalledRule Error "Previous Releases of Microsoft Visual Studio 2008" Failed



I have had Visual Studio 2005 & 2008 on this machine in the past. Until yesterday I had visual studio 2010 Professional on this machine. Today, I do not have any version of visual studio on my machine AT ALL and I still get VSShellInstalledRule Error "Previous Releases of Microsoft Visual Studio 2008" Failures when I try to install SQL Server. I was totally astounded when this error appeared a week ago as I tried to install my Developer Edition of SQL Server 2008, quite simply because I had Visual Studio 2010 on this machine (until yesterday), not Visual Studio 2008. I could not upgrade to "SP1" as I have the more recent version, the BOL, forums and MSDN pages don't even consider that this might occur in VS 2010 or even once all versions are removed. At least I haven't seen any yet that do and believe me I have spent far too long looking!!!!!

So, currently, I don't have any Visual Studio on this machine, I can find no traces of visual studio of any version in the control panel applet "Programs & Settings". I could find that, despite uninstalling from the control panel applet "Programs & Settings" there were in excess of 50Mb of files left on the machine in the C:\Program Files\Microsoft Visual Studio 9.0\ directory.  Hello!!! &

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

Error while setting up application on Win7 using Visual Studio.NET 2003


Hi All,

Getting the below error while setting up application on Win 7 using visual studio.NET 2003.


cannot find the components for communiacting with the front page server extensions...


I understand by the error, i need to install Front page server extension, but not able to figure how to install using IIS 7.5.

I had XP machine with IIS 5.1, able to find the option.


Need your help in resolving this.




Toolbox: Microsoft Chart Controls, Visual Studio Automatic Code Snippets, And More


In this installment we look at the Microsoft Chart Controls; Snippet Designer, a free, add-in for Visual Studio 2008 for creating and editing Code Snippets; refactoring SQL applications; and this month's favorite blog.

Scott Mitchell

MSDN Magazine April 2009

Office 2003: Secure and Deploy Business Solutions with Microsoft Visual Studio Tools for Office


Microsoft Visual Studio Tools for the Microsoft Office System is a new technology that brings the advanced features of Visual Studio .NET and the .NET Framework to applications built for Microsoft Office Word 2003 and Microsoft Office Excel 2003. Deploying solutions built with this technology requires that you understand how runtime security is enforced in managed applications and how to configure users' systems to run your solutions without introducing security holes.To promote that understanding, this article will demonstrate how to establish trust, explain policy considerations and permissions, and explain what trusted code is all about. Secure assembly deployment is also covered in detail.

Brian A. Randell and Ken Getz

MSDN Magazine March 2004

Office 2003: Bring the Power of Visual Studio .NET to Business Solutions Built with Microsoft Office


Microsoft Visual Studio Tools for the Microsoft Office System is a new technology that brings the advanced features of Visual Studio .NET and the .NET Framework to apps built on Microsoft Word 2003 and Excel 2003. Now you can use Visual Basic .NET and C# to write document-centric, managed code solutions that run in-process with Word 2003 or Excel 2003, taking advantage of the rich object models they expose. Along the way you get the benefits of the managed environment in which a fully compiled .NET-based application executes, including code access security.

Ken Getz and Brian A. Randell

MSDN Magazine September 2003

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