I have tested the ODBC DSN and it works but the following code statement fails with error: ODBC - call failed:
Dim Conn As Connection
Set Conn = wsODBC.OpenConnection("Conn1", , , "ODBC;DSN=IBSMSbloem;")
What can be the problem?
Thanks
PK Odendaal
I have created and tested a database with DSN - see attachment.
When I try to open the connection in VB6 I get an error - see attachment (on next message).
What can be the problem?
Thanks
PK Odendaal...
Reposting from VB6
I wish to change my VB6 program/s to read, write edit and delete data from a MySql database in stead of from MS Access.
1. Can this be done and are the changes significant?
2. Do I need to use PHP or can I edit directly like I do now with DAO or even ADO.
3. What is the best...
I wish to change my VB6 program/s to read, write edit and delete data from a MySql database in stead of from MS Access.
Can this be done and are the changes significant?
Do I need to use PHP or can I edit directly like I do now with DAO or even ADO.
Thanks
PK
PK Odendaal
I need to know which tables are in an Access database. The closest I can get is :
Dim schemaTable As DataTable = Cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
I do not know however how to extract the table names from this. I also need...
I need to know which tables are in an Access database. The closest I can get is :
Dim schemaTable As DataTable = Cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
I do not know however how to extract the table names from this. I also need...
I have a webform that a client uses to submit a property listing to our property web page. In the process he uploads his photo of the property - all this I have done correctly including to test whether its a .jpg or .gif file.
I have a problem however in that I can only allow a photo of size...
I have a problem with aligning the hyperlink images on my web page. I am using styles.css and the image margins are set to 0 for top and left in the style sheet.
When I use my local host to run the application everything is fine, but when I publish it there is an offset of about 4 pixels from...
I am trying to show an image in my datagrid, but the error -Tag is not well formed - occurs. Can somebody please help.
<asp:TemplateColumn>
<ItemTemplate>
<asp:Image Runat="server" ImageUrl="images/" & "<%# GetImage(DataBinder.Eval(Container,"DataItem.photoname").ToString()) %>"...
I inadvertently erased my website's source control file. Can someone tell me how to set it up again.
Sorry the search is off
PK Odendaal
www.odendaal.com
I wish to raise and event when a certain cell (datagridtextcolumn)in a datagrid is being changed and the length of the text reaches four characters. I have tried keypress and keyup events but they would not fire. The keypreview property of the form is set to true.
Thanks
PK Odendaal...
I have a datagrid set up from an inner join of three tables (orders,ordereditems and costcentres). When I wish to update the dataadapter with the modified dataset I use the dataadapter.updatecommand. I cannot get it right because it seems that I cannot update three tables simultaneously with an...
I wish to clear the datagrid before binding it again as presently it only adds the new datarows to the existing ones. I have seen questions here about it but none answered correctly as databindings.clear does not work and the .clear method is not available.
Thanks
PK Odendaal
www.odendaal.com
In asp.net the datagrid has a selecteditem property, but I cannot find it in the windows forms control of the datagrid. How would I determine which row was clicked and how would I retrieve the value of the first column of that row. Sorry I am new to VB.NET - made the long threatened change from...
When I run my program my datagrid shows only an arrow and a + sign. When I click on the + the datatablename comes up and when I click that the columns are visible. Is it possible to see the columns from the start.
I tried datagrid.expanded but it only shows the table name then and not the...
I am doing a program and use a windows form. I have changed this form almost completely and saved it, but when I run it it still shows me the old form. I have checked the directory which is OK. It is typical of caching of webpages, but I did not expect it with windows forms. Can somebody help ...
I have a databound datagrid and wish to show only the leftmost 10 characters of a certain string field in a certain column. How would I do that ?
Thanks
PK Odendaal
www.odendaal.com
While a browser is open with one of my web pages I wish to allow the client to click on a link to open a photo in a new instance of Internet Explorer - how would I do that
Thanks
PK Odendaal
www.odendaal.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.