Recent content by jeffmoore

Thanks ... the problem here is that i'm pulling data in from a text file ... adding some data to to it and pushing it out to a sql server.

The problem here is that the convert function below gives me an error in the ODBC data string. The SQL string works fine!!! Here is the error message I get at execution on console: error: ERROR [42000] [Microsoft][ODBC Text Driver] Undefined function 'convert' in expression...

okay but how do i put them into the dataset individualy??

Here is what I have: Dim connect As New SqlConnection("initial catalog=rathmisc;data source=server;user id=sysadm;password=sysadm") Dim MyDataAdaptor As New System.Data.sqlclient.SqlDataAdapter("select * from tbl_data_laser_1", connect) Try connect.Open()...

woo hooo ..... this works!!!! Dim connect As New SqlConnection("initial catalog=rathmisc;data source=server;user id=sysadm;password=sysadm") Dim MyDataAdaptor As New System.Data.sqlclient.SqlDataAdapter("select * from tbl_data_laser_1", connect) Try...

okay the #$@$%^ connection string wrong ... I didn't have the data source= myserver in there.... thanks all .... boy this ain't easy....

that was all greek to me ..... i'm a struggling newbie ;)

okay I'm getting further.... now I get this!!!! error: Complex DataBinding accepts as a data source either an IList or an IListSource

moved it up one line .... same error

I put the stmt oSQLConn.Open() right before the MyAdaptor.fill(ds) line ..... Same error.....

Still stuck here .... the code runs till the last line then hang for about 10-15 seconds then returns the error shown below the code sample. This is basically straight out of and example.... Dim oSQLConn As SqlConnection = New SqlConnection oSQLConn.ConnectionString = "Initial...

got ya

thanks ... I'll be at the library tonight!!!

that works thanks

just tried that ... same error : An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll