Search results for query: *

Hi everybody! strSQL = "UPDATE Tools SET Description = '" & tool_desc & "', Price = '" & tool_price & "', Bought = '" & tool_bought & "', Company = '" & comp_name & "' WHERE ToolID = '" & tool_id & "';" cnSQL.Execute strSQL I try to execute this and always get the same error "To few...

Hi, I am trying to connect to a SQL Server using VB6. I have put in name of server and the initial catalog (the name of database I wish to use - this is right isnt it???) But I am having trouble logging in. Is there a way I can instruct it to login using my Windows authentication, without...

Hi everyone, I have an Access 2000 form. I add an item to a table then refresh the form hoping the changes would be reflected in the subreport I have set up to show table contents. I dont have any of the wizards running so I have hard coded pretty much all of this. The problem is when I...

Hi, I am running a proc in which an INSERT .. SELECT is fired off. One of the columns I am inserting to is of type TIMESTAMP. The value I am inserting is CAST(CURRENT_TIME(2) AS TIMESTAMP(2)) But I keep getting an error back SPL1027:E(L282), Missing/Invalid SQL statement'E(5407):Invalid...

Hi, I am running a REPLACE PROCEDURE. In the procedure I create a number of VOLATILE TABLES. The syntax looks correct to me but I get an error saying "User is not authorized to use the DDL/DCL/Dynamic SQL statement" Logged in as Admin too. Cant for the life of me figure this out, anyone got...

Hi, I have my rs all set up and full of data but cant get more than one item into the checkbox. While rs.eof = False cmbTools.Value = rs("ToolID") rs.MoveNext Wend I know this doesnt work but Im used to VB6 and cant find the AddItem or a similar function here. Thanks for the help!

Hi, I am working with an Access database, and cant find the datareport designer in VB.Net, probably because there isnt one. Can I open a report from the Access database using VB.Net? Cheers, Gerard.

Hi all, Was hoping someone could point me towards a Teradata tutorial or a site explaining what it is and what it does? Work are changing from SQL to TeraData - hoping to get a heads up. Any help offered is gratefully recieved. Cheers, Gerard.

Hi, I am saving a record and trying to update the data in the datagrid, BUT alas things are not running smooth and I havent learnt all the errors yet. Heres my code Dim da As OleDbDataAdapter Dim dt As DataTable Dim cn As OleDbConnection Dim cmd As OleDbCommand...

Hello, Again the switch from VB6 to VB.Net is giving me problems. I was wondering how I could export a RecordSet and enter it onto an Excel Sheet. A link to a tutorial or any code you have would be appreciated. Thank you very much.

Hi, I am tying to access a datagrid from the module but I am having problems. I have tried just dgTools.DataSource = dt but no go. I have tried Form1.dgTools & Form1.Controls(dgTools) Im too stuck in my VB6 ways. Any help as always is greatly appreciated.

Hi, I have a form with a DataGrid showing the contents of Table1. Below this we have text boxes for entering Data into Table1, when I click the Save button I execute the INSERT statement and then DataGrid1.Refresh() - Doesnt show the new Information Set up the datasource again - Doesnt show...

cmd = New OleDbCommand("INSERT INTO Tools (ToolID, Description) VALUES ('" & varToolID & "', '" & varDesc & "')", cn) cmd.ExecuteNonQuery() cmd is an OleDbCommand I have tried this an it doesnt work. What is the correct method of executing an INSERT statement ( and UPDATE and DELETE...

Hi, When working with VB6 I used the Data Report Designer, but cant find that capability in VB.Net. Am I being blind? Do I need to reference something? Dont tell me there is no report function, please!

HI, I want to select a row in a datagrid and transfer that info to text boxes. In VB6 I would have used DataGrid1_RowColChange() and then txtBox1.Text = DataGrid1.Col(1).Text But these options arent in VB.Net, has anyone any helpful tips or links. Incidentally anyone knowing of a website that...

Hi, cmd = New OleDbCommand("SELECT s.Title + '. ' + s.FirstName + ' ' + s.LastName AS Staff, th.Location1, th.Location2, th.Date FROM ToolHire th INNER JOIN Staff s ON th.StaffID = s.StaffID WHERE th.ToolID = '" & ToolCode & "';", cn) dr = cmd.ExecuteReader DGrid1.DataSource = dr This is what...

Hi (again), Sorry about all the posts but I am eager to get a handle on this ADO.Net stuff. I have executed commands and filled a combo box - was now hoping to take selected value and execute a further sql statement. E.g. ToolCode = Strings.Mid(cmbTools.Text, 1, 5) 'Returns correct Value...

Hi, I have been using VB6 up until recently and have switched to VB.Net. What Im trying to do is populate a combo box from a recordset but I cant get the same to work in VB.Net. E.G. strConn = "Microsoft.Jet.OLEDB.4.0;DSN=CorlinDSN;" 'Wanted to use an ODBC Connection & Access dbConn.Open...

Hi, Ive recently switched from VB6 to VB.Net. In VB6 I set up my dbConn As ADODB.Connection then my connection string Provider=MSDASQL;DSN=SysDSN; But I have tried this in VB.Net and keep getting a problem I have Provider=Microsoft.Jet.OLEDB.4.0;DSN=CorlinDSN; I have a .Net book that is...

Hi, First of all apologies if this is wrong VB forum. Have a program that runs in Excel and I get an error when it tries to run SQLOpen() function Cant find project or library So I checked and found that XLODBC.xla had to be referenced so I went to references but it is checked and listed as...