473,750 Members | 2,541 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Strange VB6 Datagrid Problem

5 New Member
Hoping someone has experienced this before and can offer a solution.

I have an app. that was designed in vb6. The app works with data from a SQL server, retrieves the data using the adodc (MSADODC.OCX) control and displaying data using the datagrid control.(MSDATG RD.OCX)

Have had no problems to date with windows xp,successfully installed on more than 30 pc's all running windows xp, with the exception of 3 windows xp client machines where i recently installed it and the datagrid control just doesnt display any text! I know the adodc recordset has information to display based on a recordcount,the grid loads and is registered correctly... no errors but simply has no text in it?

Any ideas would be greatly appreciated! Many Thanks...
Nov 21 '06
14 10727
misolution
1 New Member
Hello sirs,
Myself too is facing the same problem. My application is using the datagrid to show some colums from a table. The problem is that it is working fine when I use the Jet 3.51 in connection string. But When I use Jet 4.0 it is not showing the rows. I have checked the record count of the connected record set. It is showing a count so recordset is not empty. I don't know what is happening. My OS is Windows XP service pack 2. Let me know when you get a remedy to this problem.

Thans and Regards

Suresh

Hoping someone has experienced this before and can offer a solution.

I have an app. that was designed in vb6. The app works with data from a SQL server, retrieves the data using the adodc (MSADODC.OCX) control and displaying data using the datagrid control.(MSDATG RD.OCX)

Have had no problems to date with windows xp,successfully installed on more than 30 pc's all running windows xp, with the exception of 3 windows xp client machines where i recently installed it and the datagrid control just doesnt display any text! I know the adodc recordset has information to display based on a recordcount,the grid loads and is registered correctly... no errors but simply has no text in it?

Any ideas would be greatly appreciated! Many Thanks...
Jun 26 '07 #11
kingo3434
1 New Member
Hi there,
I have had the same trouble with datagrid staying empty, but in my case the datacontrol stores no data.
Then I replaced the datacontrol with a ado.recordset-object and set the datasource of the grid to that object.
After all, data is now visible on the grid.
So, if you can, throw the datacontrol out of your application.

Regards,
Ingo

Hello sirs,
Myself too is facing the same problem. My application is using the datagrid to show some colums from a table. The problem is that it is working fine when I use the Jet 3.51 in connection string. But When I use Jet 4.0 it is not showing the rows. I have checked the record count of the connected record set. It is showing a count so recordset is not empty. I don't know what is happening. My OS is Windows XP service pack 2. Let me know when you get a remedy to this problem.

Thans and Regards

Suresh
Aug 23 '07 #12
kvikhrov
1 New Member
Hello, guys.
I know there has been quite a while since the last answer to this post was given. I just want to leave some comments of mine, trying to help people in similar situations.
My case was even more rare. I was working perfectly working with ADODB.Recordset objects instead of datacontrols (like kingo3434 said). Using "Set mydatagrid.data source = myrecordset" syntax. Thus, the records in the datagrid got refreshed just fine. I always used one general (public) ADODB.connectio n object for my app's queries. One day, trying to create a connection object within my grid data binding procedure, all of a sudden the grid stopped displaying data. I made sure I used the same ConnectionStrin g for the local connection object, as the one from from the general connection object. To make things worse, I "rollbacked " every change, so as to use the public ADODB.connectio n again instead. And to my surprise that did not get the things the back. My recordset always had records to display, though.

Reading Albertw's advices and misolution's issue on Jet version, I tried to use a different ConnectionStrin g...

The string I used to have was: "PROVIDER=Micro soft.Jet.OLEDB. 4.0;User ID=Admin;Data Source=" & DBPath & ";Persist Security Info=False;Jet OLEDB:Database Password=passwo rd;".

My problem was solved using the following string: "Provider=MSDat aShape.1;Data Source=" & BDPath & ";Data Provider=Micros oft.Jet.OLEDB.4 .0;Jet OLEDB:Database Password=passwo rd"

I'm not really sure how adding MSDataShape clause could have worked things out (I usually use this string when I need to execute SHAPE queries), because Jet 4 is still mentioned as Data Provider further in the string. But I'm happy it helped me out!!
Jan 3 '12 #13
Killer42
8,435 Recognized Expert Expert
Haha "quite a while" is an understatement; 4½ years since the previous post.

But thanks for giving us the benefit of your experiences - it's all good to have in the archives for people to search.
Jan 4 '12 #14
charlesdaniel1
1 New Member
Thank you for this posting which really helped me a lot. Very strange yet very practical.


@kvikhrov
Feb 24 '14 #15

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1541
by: Grzegorz Kaczor | last post by:
Hello all, I've got a VERY strange network problem with Win2k Server and .NET. I've got one central server (hub) getting raw binary data (files) from many locations. Both server and clients are written in C# The server is quite simple: two threads, one accepts new connections and decides whether the client is authenticated to send data or not, and the other thread serves already connected clients: performs a Socket.Select and then...
7
1665
by: M O J O | last post by:
Hi, I'm developing a asp.net application and ran into a strange css problem. I want all my links to have a dashed underline and when they are hovered, it must change to a solid line. Sounds simple, but it's not working. I've cooked down my output code to show you what I mean. If you run the code below, there's no line under the link, but if you either remove the
0
1249
by: Grzegorz Kaczor | last post by:
Hello, I've got a VERY strange network problem with Win2k Server and .NET. I've got one central server (hub) getting raw binary data (files) from many locations. Both server and clients are written in C# The server is quite simple: two threads, one accepts new connections and decides whether the client is authenticated to send data or not, and the other thread serves already connected clients: performs a Socket.Select and then gets...
6
1593
by: Stuart Ferguson | last post by:
I currently have a datagrid which is populated from a dataset table however the contents of the table how can i clear the grid and repopulate it ? *** Sent via Developersdex http://www.developersdex.com ***
0
1274
by: Davewadd | last post by:
I'm having an odd problem with a datagrid in a c# program. The program maintains a schedule of jobs that need to be run. As jobs run, the status and next run date/time info are updated in a SQL database. On the initial load, the datagrid fields are defined. The 1st time the dataset is reloaded, an error is returned stating that the 1st field in the list is not found. On all subsequent reloads, everything is fine. Here's the relevant...
0
953
by: Andreas Klemt | last post by:
Hello, how can I easily solve the nested DataGrid problem working correctly with edit / update events? Is there any very simple example? Who has the same problems? Thanks in advance, Andreas
14
1889
by: James Wong | last post by:
Hi! everybody, I'm facing a quite strange download problem. I use the following code to download an XML file to client side: With Response ' clear buffer Call .Clear() ' specify the type of the downloadable file
1
1098
by: big DWK | last post by:
Hi- We're having a strange caching problem with an ASP.Net app written in VB.Net on Windows 2003 with all the updates. We have two websevers that use a common sql backend and a session server to preserve state. Everything is working on one server, on the second one we have one page that is giving us problems. Basically we changed the ip of our mail server and updated the pages that use it accordingly. One page, however isn't reading...
9
1950
by: Me | last post by:
Hi, I ran into a malloc problem but I can't find the solution. I try to read a file into a variable with malloc like this: BYTE *lcdata; lcdata = malloc(fsize*sizeof(BYTE));
1
1578
by: shaneal | last post by:
Hello all, I've been trying to learn some javascript and I ran into a strange scoping problem I was hoping someone here could help with. I have a fair amount of experience with functional programming, but very little with javascript, so please excuse the unidiomatic code. When I do: var functions = new Array();
0
8839
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9398
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9345
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8265
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6811
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4716
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3327
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2809
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2227
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.