Recent content by Strider

Hello all, im having a problem with user rights issues with progress. I will be accessing progress from an asp.net web service. In the Data Administration There are no user's in the user list and access is set to *. So i created a user and gave them full access. Anytime i execute a SQL...

ya inside my application i have a function to convert all dates from dd/mm/yyyy to yyyy/mm/dd before the is added to the sql statement

ah.... hmmm, i can insert it as '01/17/05'

Hi there, im trying to insert a date into progress and im having no luck. The date column is defined as 99/99/99 So my sql statement is as follows INSERT INTO PUB.mytable VALUES ('17/01/05') but its giving me errors am i missing something here, should the date be surrounded in something...

ya it takes a while to get everything working in progress, well especially if your like learning as you go....

cool ya that works inside my VB.Net code it showed up nothing inside Progress SQL Explorer

any solution found for this?

Hello again, in the progress database i have been given there are lots of column names containing a dash in the ie. prod-desc So my query will look like: SELECT prod-desc FROM Pub.Products And i get an error: Column not found/specified (7520) I have tried putting [] around the column-name as...

Hi all, i was wondering if any has been able to call a Progress Procedure using the Merant ODBC driver. In my VB.Net application i am trying to call previously created procedures. I also would need to be able to pass parameters into the query Has anyone done anything like this from any...

Hi Dan, you say you are developing in C#, do you know how to call produres wrote in progress from your .net application?

Hi there i have created an asp.net webservice to connect to progress over the Merant ODBC drivers. my webservice is throwing an error when i try and access progress over the System DSN i have created for the ODBC link into progress The error i get is: ERROR [IM003] Specified driver could not...

Cool, and one last question for today.... One of the databases i have, a sample that comes with progress, i can query fine. But the one i got of a client when i try to execute a query, whether from my vb.net application or SQL Explorer Tool i get Access denied/Authorisation required error...

Ah ok.... Can can i call Progress stored procedures in the same way? When calling access queries over ODBC the structure of the query is "SELECT * FROM <theStoredQueryName>"

Casper.... excellent, thats just what i was looking for... what exactly does the pub specify

Hello once again. So i finally got my DSN ODBC connection to Progress Working. So i've created a vb.net application in which im connecting to the progress database. Now im trying to query the tables in Progress with SQL In the Progress Data Dictionary i can see the tables in the database and...