Search results

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

The biggest problem was the i changed server from 192.168.10.183 to localhost Ok i finally got it up and running. It was also the wrong port i was entering, and for the username i enter my domain login and password. and it got connected Once again guys thanks for the help with that.... im...

how do you start the database without -H is there a command line method of starting the database. I have it started in the Progress Explorer. What does starting it with -H do?

Maybe you can help me with this http://www.progresstalk.com/showthread.php?p=278792#post278792 Cheerz

Hi All again. Right my next task with progress that im stumbling with is that im trying to create a System DSN to Progress using the Merant ODBC. However when i try to connect its failing. The message is rather 1."No Data" or 2."Invalid Network Daemon" So here are the details: AdminServer...

Guys thanks for the replies finally got the database up and running on the admin server thingy. I reinstalled it all on my own pc and managed to get it connected. Could be something to do with the mapped drives etc.... Anyway thats the 1st big issue out of the way Will need your help with the...