Member Avatar

hello! i have shifted my application from mssql server 2000 to mssql server 2005 , now the prob is the command object is not returning the recordset if command text is stored procedure , here is my code please check it and guide me through errors . [ICODE] dim cmdsp as command dim rs as new ADODB.recordset set cmdsp = new commadn cmdsp.activeconnection = cn cmdsp.commandtext = "MyStoredProcedure" cmdsp.commandtype = adcmdstoredproc set rs= cmdsp.execute 'here i got an error the state of rs is zero , but if i used this code at mssql server 2000 then it will return …

Member Avatar
0
3
Member Avatar

Hi all, Im starting to program in java with sql. The problem im having is that when im trying to complete a combo box with data from a table in sql i get this error: [U]"null error in cargarComboProvincias()"[/U] when i run the program, and i cant find the error in the code. :S id appreciate if any1 helps me with it :D [code=java] import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.swing.JOptionPane; public class Proveedores extends javax.swing.JFrame { Connection cnn; ConexionesBaseDeDatos conexiones = new ConexionesBaseDeDatos(); public Proveedores() { initComponents(); } @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void …

Member Avatar
0
6

The End.