Search:

Excellent, thanks mendhak.

I did get a reply just now from sharpdev and it looks as though there is a problem with Borlands side of things, although they gave me different details for solving it....

Hi,

I use Borland tools and have an exported an application as a Visual Studio app.

I don't have Visual Studio so I can't test the conversion.

The VS version won't import into SharpDev (a...

I have a C# stock control example you can have www.adoanywhere.com , please feel free to use the source and give to others. It was developed from a WIN32 application purely as a learning exercise but...

Can anyone point me to an article that shows how to port an application from using ADODC to Not-Using-ADODC please?? Many Thanks.

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Type)=1));

when I do that in ADO I get the error:

Record(s) cannot be read; no read permission on...

ADOX is your friend.

http://81.130.213.94/myforum/forum_posts.asp?TID=58&PN=2

some details here about UDL files
http://81.130.213.94/myforum/forum_posts.asp?TID=108&PN=1&TPN=1

OK, here you go

http://81.130.213.94/myforum/forum_posts.asp?TID=107&PN=1&TPN=1

I don't have examples but have asearch for recordset Update Criteria property and set it to UpdateKeys.

Use Chunk methods

http://81.130.213.94/myforum/forum_posts.asp?TID=100&PN=1

You may need to compact your database if you do a lot of inserts and deletes - to stay within 2Gig

Make sure your try both the Oracle and Microsft OLEDB Providers. you can use Adoanywhere (free) to see how well each works on your database.

If you need professional consultation let me know.

(I'm not suggetsing the help here isn't professional it's just that answering your quetion and steering you through all this could take a lot of...

Drag and drop your excel file (I don't know about .frm) onto adoanywhere, then use the gui to set a filter. Use grid to scroll records. If it all works then you can do the same in VB.

Here is VB...

This is the connection string from adoanwhere: looks like Initial Catalog is the property you want to set, in my case it's northwind.

Provider=SQLOLEDB.1;Password=webuser;Persist Security...

Most often this is because your connection string wasn't exactly right.

Drag and drop your excel file onto adoanywhere browser (which is FREE) and it will create a connection string for you.

It...

I'm not sure about the ME part, but one reason for going for SQLserver is the robustness. If you get MSDE this is a cut down version of SQL Server that should be good enough for you.

Most probably the description property is not available in the recordset-field properties.

I've just looked at Access and SQlServer in adoanywhere property viewers and I can't see description...

PS if you post the database I to would like to try...

If it could be done, you'd probably have to use an AdoCommand object and return your values as a recordset.

Sometimes it's just trial and error with procs/params.


adoanywhere is free and has...

Thers a free OpenSchema gui in adoanywhere that exposes all enums.

here is a link to .net in case you need it in future http://support.microsoft.com/default.aspx?scid=kb;EN-US;309488
...

(Check that the fields isn' defined as Not Null) but assunming you've done that..

hard to say, but it could be you're using server side cursors. Try client side and see what happens.

Get a...

Many of the ADODB (ADO) properties are displayed in adoanywhere free tool. Helps you learn faster.

For Classic ADO you need MyODBC or MyOLEDB..some details and examples to connect to my public MySQL test server in this thread:
http://81.130.213.94/myforum/forum_topics.asp?FID=23&PN=1

(I'm not...

Mendhak,

I recently installed the Microsoft .net example tutorials. I tried to make the tutorial public but I had similar problems to you.

In the end I created the virtual directory in IIS for...

Fixed thanks.

Hi,

I'm trying to install the dotnet samples and get this message in the log file:

Could not detect NetSDK instance of SQL Server (etc)

..This causes the database not be installed.

Any...

Gurus,

I'm trying to get an application finished that works like Query Analizer in
terms of returning query plans and statistics.

Problem the co-author is having:

>In using ADO to connect...

and get your free copy of adoanywhere ADO tool.


AdoAnywhere exposes the ADO objects (Connections, Commands, Recordsets and Errors) via a GUI. Allowing developers to see what effect various ADO...

As well as the good advice so far, check out sql EXISTS command, very similar to si_the_geek example using IN.

BTW different methods sometimes work faster than others, even though logically they...

I'm not 100% sure....but can you query the connection with OpenSchema to see what the table is.

FAQ http://81.130.213.94/myforum/forum_posts.asp?TID=59&PN=1


You could try the openschema gui...

Yep, that's what I would have ended up doin, but without Views/Procs it meant joining the query results in VB (or whatever)

Nah, Leave the field as it is.

The problem is the aggregate fields (fields grouped) joining the underlying table.

I've tried various joins and none worked. Same dodgy results you get.

I...

Is this via ADO, if so you could try asynchronous execution of the recordset.

Some details here but not complete:

http://81.130.213.94/myforum/forum_posts.asp?TID=60&PN=1

MySQL & MyOLEDB Do dynamic cursors work - fields don't refresh automatically.

What do I need to do to get fields to refersh without using Requery or refresh methods of the recordset.

Has...

Is date of type "Date" / "Datetime" or is it a string column - in which case dates will come out in funny order.

I cant recall what field types are allowed in MySQL

If you post in the adoanywhere forum (for vb_ado) you may get an answer, I specialise in ADO, vb is not for me.

http://www.adoanywhere.com/forum

Mike

You can use ado to read Excel files, you may have problems writing.

Drag and drop your excel spreadsheet onto adoanywhere browser and see if you can modify the data. If you can't then VB and ADO...

Here is an example on my test server sample database you can try:

Select country , max( lastname )
from sample2
group by country

It seems you want to do something similar.

My test server...

ahh..just saw your posted error message. Ignore my BatchOptimistic theory.

Mike.