Search results

Hi. I am considering moving our 2 Openedge 10.0b servers into virtual servers, using Microsoft Virtual Server Enterprise R2. I cannot find any mention of this deployment option on Progress website, or google or anywhere. Anyone know if Progress support this type of deployment? Anyone know...

Hi. My experience suggests 9.1d driver and 10.0b drivers work together ok on the same pc. However, with Crystal, you have to quit Crystal after using one driver (ODBC connection), in order to use the other. With Crystal Enterprise you have a problem whereby it can only maintain a connection...

yippedy doo dah Dim myQuery As String = " SELECT ""debtor"".""deb-accn"", ""debtor"".""Name"" FROM ""PUB"".""debtor"" " This works :eek: Thanks Lee, I knew you were on to something. itman

ok. At least I'm clearer on the problem. The hyphen is being interpreted as a minus sign by the Progress SQL preprocessor. I have heard of the -esqlnopad parameter but I think that was only for Progress 7 and 8, and SQL89. I however am using the ODBC DataReader addon to Visual Studio 2002...

Thanks for the ideal Lee. I just gave that ago, and all combinations I can come up with. None worked. Seems this issue of SQL and hypens has appeared many times on this forum, but as yet, nobody seems to have a workable solution. Fair enough, some problems just have to be worked on...

Thanks for the idea. Unfortunately neither worked. I think " would work, but in VB.NET the SELECT statement is enclosed in "" e.g WORKS OK "SELECT PUB.debtor.deb-accn FROM PUB.debtor" WILL NOT COMPILE "SELECT PUB.debtor."deb-accn" FROM PUB.debtor" I've tried all kinds of combinations...

Hi. Using Visual Studio 2002 and ODBC DataReader, I cannot work out how to get SQL queries to work where there are hypens in the field name. eg. No problem. "SELECT PUB.debtor.Name FROM PUB.debtor" Won't work. "SELECT PUB.debtor.deb-accn FROM PUB.debtor" It's something to do with that...