I'm developing a multi-threaded application that communicates with SQL Server via ADO. The application is written in MFC and is being tested on WindowsXP SP2. The problem I'm having is that the following function call will hang the application intermittently and I'm not sure why: Recordset15::Open (part of the ADO API). More specifically, it seems to happen deep within the raw_Open call. Although there are multiple threads running, I've made it so that only the one thread is actually communicating with the ADO database. And, besides, I was under the assumption that the ADO was a thread-safe API. Also, I'm not sharing connections across different threads.
I need to join two table in a one query. I do this so
Select FC.FC_TYPE,ISNULL(FCV_RateIN,1) FCV_RateIN,ISNULL(FCV_RateOut,1) FCV_RateOut from ForeignCurrency FC LEFT OUTER JOIN Rates R ON FC.FC_ID=R.FCV_ID WHERE FCV_Date='10/13/2005'
This give me result as i want. But when i need 10/14/2005 rates it give me empty result set , but i expect
FCV_TYPE FCV_RateIn FCV_RateOUT
YTL 1 1
USD 1 1
EUR 1 1
I use ODBC programming in order to connect VC++ with database. For that i First create system DSN, Use CDatabase class SQLConnect(...) function in order to connect to the DSN, Then use SQLExecDirect in order to run the querry. But i am facing problem with CSV files.
I Created a system DSN of Microsoft Text Driver and then connected it worked. As you know in CSV files it automatically takes first rows as the field name. Therefore if I run the query "SELECT * FROM TableName.csv", IT works. But if I write a querry "SELECT Col1, Col2,....Coln FROM TableName.csv" It does'nt work cuz it is unable to recognize and individual column. Now I need to run a querry in order to check for an existing data "SELECT * FROM TableName.csv WHERE Col1 = 'MyName'" even this query generates an error.
So can anyone help me how to reslove this selection problem?
Hello there i have a connectionstring like below:
var connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=E:\\mohebi\\b1384.6.26\\adabiat1\\data base\\db_demo.mdb";
and when i wana open it on IIS on my local computer, i have this ADO Security Warning :
This website is using your identity to access a data source.If you trust this website ,
click OK to continue ,otherwise click Cancel.
I found the way to deny this warning and that is adding my website to TRUSTED SITES in IE.
BUT when i use this source on MY SERVER ,MY SERVER is WINDOWS SERVER 2003, it is another warning like below:
safety setting on this computer prohibit accessing a data source on another domain.
I can solve this problem with adding it to TRUSTED SITES , but i have many clients , AND OF COURSE I CANT DO THIS FOR ALL MY CLIENTS!!!
basically two different queries through one query window.
I get the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE `bedbugs`.`airports` (
`city` char(20) default NULL,
`cou' at line 1
Can someone explain what is going on. If I comment out either query - the other one runs fine (basically I can run one at a time).
Is this some sort of limitation of the query browser?
thanks in advance
I want to develop a "multi datasource type" application (an aplication that should be able to querry more than one sql sever type - dbase, mysql, mssql, acces, excel)
Implementing my own communication drivers for dbase, acces, excel, and so on..., would be a waste of time in my opinion.
So my first question comes about an speed issue : whitch is faster, ado.net's odbc or ado.net's oledb? Meaning that the datasources I am facing are not at all small, having at least 30k rows (in the most favorable cases).
And the second question is about programatically driver detection : whether I use oledb or odbc, how can I find out progamatically if on a certain system the drivers neaded for a datasource type are present?
I hope I understand as quick as possible...because is a rough world out there...
Last Visit: 31-Dec-99 18:00 Last Update: 17-Aug-22 6:54