I used 'Microsoft SQL Server Migration Assistant for Access' to move my tables and data. Now I'm trying to change all my connections/data adapters etc from Access to SQL. I think I figured this issue out. It had to do with the way I was formatting the time in the SQL statement.
I have a data grid view in my .net vb application. I moved my database from access to sql server. When I try to load my data grid sql statements I have the following error below. The code is below that. How can I change this to fix the issue?
da.Fill(ds, "tblx") - Line 862
----> 7/28/2012...
It would be OleDb
Here is the error I have now:
System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.
at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
at...
Not sure? I thought it would be an SQL connection. This is an example of what I do on my web site using my sql server:
Dim SQLcmd = New Data.SqlClient.SqlCommand
SQLcmd = New Data.SqlClient.SqlCommand(sql_str, mainconnection)
Do : While SQLdtr.Read()
Loop While...
Well I ran my code and tried to connect to the SQL server and it gave me an error saying I needed the provider in there. I can paste the error later tonight. I'm trying to move a application already written from ACCESS DB to SQL Server.
What is the connection string for SQL server 2008 and Visual Basic 2010 Express.
I have this, but need to somehow put the provider in there?
"Data Source=xxxxx;Initial Catalog=xxxxx;User ID=xxxxx;Password=xxxxx;Integrated Security=false"
I am wanting to copy a project I have already developed with vs 2010 and vb.net code. I want to move it from an ACCESS DB to an SQL DB. How can I copy the folder(project) and make it work, so I can have both files - one connecting with access db and the other with sql server 2008?
I tried to...
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.