Thanx Don, It will definitely help me.. :-)

I have never failed,I just found 1000 ways that never works. Regards, Victory.

thnx dan, i already tried that way.but of no use. I want to print in the Bill/Invoice format. Can you help me about this?

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hi, I am brand new to printing to a thermal printer using c# asp.net, and i need your help guys to give me where can i find tutorial how can i connect and print to thermal printer using c#. i am using VS 2008 PRO .NET 3.5 please help me to get started with thermal printing using c# I am stuck here.

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hi all, Is there any way to customize Delphi's inbuilt controls like Button or EditBox?? please suggest if anyone knows.

Regards, Victory. I have never failed,I just found 1000 ways that never works.

Configuration:
Application server : windows 2008 server R2 - 64 bit
Oracle client 10g : 64 bit
Visual Studio 2010 : 64 bit
Client side : 32 bit-XP

Successfully running the code on application server for oracle connectivity. But after IIS configuration of application server while accessing application from client side not connecting with oracle database.

It does not display the reports generated from Oracle on 32-bit XP
But it shows on 64-bit Win Server 2008.

Anybody help me??

I have never failed,I just found 1000 ways that never works. Regards, Victory.

hi Experts, I m developing an Application which handles a Database with Unicode values.

I have Done all the Settings to run the Unicode Program
    1. Added "_UNICODE" in Preprocessor Directives and removes "_MBCS"
    2. Entrypoint in Link tab as "wWinMainCRTStartup"

I have write following code to search Records of given Unicode value. It runs fine but could not give any Records/Result back. It just out of While loop. Please Help me out..My code is as follows. :-

	CDatabase cn;
	CString FieldValue1,FieldValue2,FieldValue3;
	CDBVariant varvalue;

	CString csPwd,csUser,csServer,csDBName;
	csPwd = "SQLServer2005";
	csUser = "sa";
	csDBName = "DeccanCollege";
	csServer = "DECCANSERVER";

	cn.OpenEx(_T("DRIVER={SQL Server};Pwd="+csPwd+";Uid="+csUser +";Database="+csDBName+";Server="+csServer),CDatabase::noOdbcDialog);

	TCHAR *m_Voc = (TCHAR*) malloc(50); //allocate memory
        m_VocEdit.GetWindowText(m_Voc,50);     // get Edit box Unicode Value

//Suggest How to Pass "m_Voc" value as Unicode
	CString sqlStr = _T("Select * from Vocablemaster where slvid in(Select slvid from slipvocmaster where binno between 165 and 169) and (VocDescSan like N'%"+CString(m_Voc)+"%')");
	CRecordset rec(&cn);
	rec.Open(CRecordset::forwardOnly,sqlStr,CRecordset::none);

   while(!rec.IsEOF()) 
	{
		rec.GetFieldValue((short)0,FieldValue1);
		rec.GetFieldValue((short)1,FieldValue2);
		rec.GetFieldValue((short)2,FieldValue3); 
		rec.MoveNext();
	}

I have tried it by another way also by ADODB.. Its code is as follows :-

  HRESULT hr;
  CoInitialize(NULL);
  try
  {
	  ADODB::_ConnectionPtr connection;
	  hr = connection.CreateInstance(__uuidof(ADODB::Connection));
	  if (FAILED(hr))
	  {
		  throw _com_error(hr);
	  }
	  ADODB::_RecordsetPtr recordset;
	  hr = recordset.CreateInstance(__uuidof(ADODB::Recordset));
	  if (FAILED(hr))
	  {
		  throw _com_error(hr);
	  }
	  connection->CursorLocation = ADODB::adUseClient;
	  connection->Open(L"Provider=sqloledb;Data Source=DECCANSERVER;"
		L"Initial Catalog=DeccanCollege;User Id=sa;Password=SQLServer2005;", L"",
		L"", ADODB::adConnectUnspecified);

	  TCHAR *m_Voc = (TCHAR*) malloc(50); //allocate memory
        m_VocEdit.GetWindowText(m_Voc,50);     // get Edit box Unicode Value

        _variant_t varVoc = m_Voc;
//Suggest How to Pass "m_Voc" value as Unicode
	  recordset->Open(L"SELECT * from VocableMaster where VocNo lik

Hi All, I have created one DLL having some functions as follows.. I want to call them from VB.net and C#.net.

1. Function CONVERTPWDATA ( PASS1,PASS2 : INTEGER; IpStr : PWord; OpStr : PChar;
   LangName : LongInt; AFontType, BFontType : LongInt ) : PChar; StdCall;export;
2. Function CONVERTDATAEX ( PASS1,PASS2 : INTEGER; IpStr : PChar; OpStr : PWord;
   LangName : LongInt; AFontType, BFontType : LongInt ) : PChar; StdCall;export;

Can anyone help me for Compatible Data types in .net for Delphi Data Types. My Second Question IS

How to pass Unicode Data from .net and How to receive it back from Delphi DLL.

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hi All, I have created one DLL having some functions as follows.. I want to call them from VB.net and C#.net.

1. Function CONVERTPWDATA ( PASS1,PASS2 : INTEGER; IpStr : PWord; OpStr : PChar;
   LangName : LongInt; AFontType, BFontType : LongInt ) : PChar; StdCall;export;

2. Function CONVERTDATAEX ( PASS1,PASS2 : INTEGER; IpStr : PChar; OpStr : PWord;
   LangName : LongInt; AFontType, BFontType : LongInt ) : PChar; StdCall;export;

Can anyone help me for Compatible Data types in .net for Delphi Data Types.. My Second Question IS

How to pass Unicode Data from .net and How to receive it back from Delphi DLL.

Thanks in Advance..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hi All, I have created one DLL having some functions as follows.. I want to call them from VB.net and C#.net.

1. Function CONVERTPWDATA ( PASS1,PASS2 : INTEGER; IpStr : PWord; OpStr : PChar;
   LangName : LongInt; AFontType, BFontType : LongInt ) : PChar; StdCall;export;

2. Function CONVERTDATAEX ( PASS1,PASS2 : INTEGER; IpStr : PChar; OpStr : PWord;
   LangName : LongInt; AFontType, BFontType : LongInt ) : PChar; StdCall;export;

Can anyone help me for Compatible Data types in .net for Delphi Data Types. My Second Question IS **How to pass Unicode Data from .net and How to receive it back from Delphi DLL.** Thanks in Advance..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

I want to search the record by a word which is Unicode. So I can give it in SQL Mgnt Studio like this..

select VocNo from VocableMaster where VocDescSan like N'अपाप'

It can give me result.where 'N' denotes it is Unicode string. But I cant send it via Delphi. I tried following ways :-

1> select VocNo from VocableMaster where VocDescSan like N'''+reVocSan.Text+'''

then it gives me no result becoz reVocSan.Text will be '????'(due to unicode)

2>select VocNo from VocableMaster where VocDescSan like N:VocDescSan)) and ');
            Parameters.ParamByName('VocDescSan').DataType := ftWideString;
            Parameters.ParamByName('VocDescSan').Value := reVocSan.Text;

then it will give error about VocDescSan parameter not found. bcoz it combines both N and para.

3>select VocNo from VocableMaster where VocDescSan like N :VocDescSan)) and ');
            Parameters.ParamByName('VocDescSan').DataType := ftWideString;
            Parameters.ParamByName('VocDescSan').Value := reVocSan.Text;

then it will give error about Column Name not found for 'N' (if space between N and para)

4>select VocNo from VocableMaster where VocDescSan like N+:VocDescSan)) and ');
            Parameters.ParamByName('VocDescSan').DataType := ftWideString;
            Parameters.ParamByName('VocDescSan').Value := reVocSan.Text;

then it will give error about Column Name not found for 'N'

5>select VocNo from VocableMaster where VocDescSan like :VocDescSan)) and ');
            Parameters.ParamByName('VocDescSan').DataType := ftWideString;
            Parameters.ParamByName('VocDescSan').Value := reVocSan.Text;

then it will not give any error. but couldnt give any Result. I will check it in SQL mgnt Studio.

select VocNo from VocableMaster where VocDescSan like 'अपाप'

Can anyone have solution for this..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hi Experts, I m using SQL Server 2005. I have some queries..PLEASE HELP I m using following Connection String

strConnect = _T("Provider=sqloledb;Data Source=MyServerName;"
"Initial Catalog=MyDatabaseName;"
"User Id=MyUsername;Password=MyPassword;");

My Queries are : 1> What is the Actual use of "Provider"?? 2> What is the difference between "Provider" and "Driver"?? 3> I can connect to Database with using Provider or Driver. By using only "Data Source/ Server" and other parameters then Why to use Provider or Driver? 4> IF I Different Provider like 'SQL Native Client' then Can this increase my SQL Server Connection performance?? Please HELP.. ITs Urgent for Me..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

hi dan_fish, I have checked it on SQL profiler..

But I dont understand it. I found some procedures get executed at background and some of my queries take time (apporx 123455), whats does it mean??
Is it take more time than expected?
then what should I do??

Please help me. I will check in my Source code.. and all the queries having Select * will replaced with only needed Column name. Will it do anything to performance???

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Thankx Stryder_1... I already checked it..and.. By the way.. as soon as the command gets executed and result get back. If I close the connection every time then for new command I think it will take some time to reopen the connection. If the command object is a local then after the Procedure is exited the command object will be free..then connection will also get Reset??? please correct me....

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hi Experts... I am developing a Database application using Delphi 6 using SQL Server 2005 as backend. Its a working Live project now at my customer end. But Now the SQL Server getting slow as the Database and its Log file size increases. It becomes very critical situation that the customer some times feels like Server gets Hang and they Restart them. After Restart it will again works fine. I dont realize the actual problem..Can you Help me out..Its very Urgent. My server configuaration is : Xeon Quad Processor 8 Gb RAM 1 TB HDD and total 30 CLients are accesing the data as well as Updating the Database. PLEASE PLEASE PLEASE HELP ME.....

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hi Experts, I have created an Database application using CDatabase and CRecordset. Following is some part of code where the Exception occurs....

CRecordset UserRs(&UserCn);
.
.
Sql="Select * from UserInfo";
//Exception occured here
UserRs.Open(CRecordset::snapshot,Sql,CRecordset::none);

The Exception is : "Attempt to open a table failed-there were no columns to retrieve were specified.." I m confused..Becoz the same code run on my machine doesnt work on others machine. and the query also correct. plz Help me.. Waitng for ur Reply..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hey guys... I find another way for the Exception Details.. The Exception is...

"Attempt to open a table failed - there were no columns to retrive were specified"

Can anyone Help Now.... plz..... I m waitng for ur valuable reply..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Thanx Stuart Dootson , Thanx a lot.. I already tried this for my PC.. But on my machine it works fine(Where I can Debug). But on others machine , How I can Debug without the code.?? On that machine I use only the generted EXE of my application. Is their any other way? and I doubt about my Open() statement.. can u check it once and reply if any modification.. the code is at first message.. plzzzzzz ....... waitng for ur Reply..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Thanx Stuart, Actually the exception is not caught by above both catch() blocks. So I think there is no need to use Delete here. But as u said, I had use this..But problem not solved.. Plz...anyonce can tell me how to Show the Exact Exception details caught in catch(...) block. so i can find the solution as early as possible.

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Thnk u for ur reply. But as I said, it is caught by catch(...) block and handled by me. So I dont know the Exact Exception that occrd here.. Can u tell me, How I can Display or know which Exception is caught by catch(...) block. I m confused about the situation where, It works fine on my machine but not on some others machines.. Plz Reply...

I have never failed,I just found 1000 ways that never works. Regards, Victory.

Hi Experts, I m doing a databse application using CDatabase and CRecordset classes. The Database is created dynamically using Catalog.

_CatalogPtr m_pCatalog = NULL;
CoInitialize(NULL);
m_pCatalog.CreateInstance(__uuidof (Catalog));

m_pCatalog->Create((const char *)(CString("Provider =Microsoft.Jet.OLEDB.4.0;Data Source=" + csAccessDbname)));

I have two Queries. 1>. I have handle the exception using CDBExceptionand a general exception handler Catch(...).But for the following statement,

UserRs.Open(CRecordset::snapshot,Sql,CRecordset::none);

an exception occurs but could not caught by CDBException but caught in Catch(...) block. But the prbm is I couldnt understand the reason. I want to Show the Exception in Catch(...) Block. 2>. My code is as follows :

try
{
UserCn.OpenEx(_T("Driver={Microsoft Access Driver (*.mdb)};" "Dbq=" + csAccessDbname + ";"),CDatabase::noOdbcDialog);
}
//Exception occurd here
UserRs.Open(CRecordset::snapshot,Sql,CRecordset::none);
}
catch(CDBException cdb)
{
MessageBox(NULL,cdb.m_strError ,"fnInitFromFile_CDBException",0);
}
catch(CException ce)
{
AfxMessageBox(ce.ReportError());
AfxMessageBox("CException..inside fnInitFromFile");
}
catch(...)
{ //Exception caught here
MessageBox(NULL,"CRecordSetfailed.. ","fnInitFromFile_Exception",0);
}

This code works fine for my machine but on others machine. It create database and Exception is occured at UserRs.Open() statement. PLz Help me.. I m trying my all ways to solve this problem.. Thnx is advance.. waitnng for ur valuable response..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

modified on Monday, July 6, 2009 2:28 AM