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...
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...
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...
Just trying to get data into a datagrid but it doesn't like my second to last line
Dim oSQLConn As SqlConnection = New SqlConnection
oSQLConn.ConnectionString = "Initial Catalog=rathmisc;User Id=sysadm;Password=sysadm;"
Dim MyDataAdaptor As...
In this connection string :
oSQLConn.ConnectionString="Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
what is the data source supposed to point at?
this connection string was copied from an example. and I dont know what "aron1" is
thanks
jeff
I need a good book on vb.net as it relates to windows applications and sql database. I dont need any web stuff. Any suggestions.
Oh lest I forget .... I dont know squat about vb.net. I get along fine in VBA. But this .net stuff is way different
Thanks
Jeff
need to get time as time not date...
Dim MyConnection As System.Data.Odbc.OdbcConnection
Dim MyDataTable As New DataTable
Dim MyDataAdaptor As System.Data.Odbc.OdbcDataAdapter
Dim strMyConnection, strSavedFolder, strFilename As String
strSavedFolder =...
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.