mcosta Posted March 9, 2009 at 03:07 PM Report Share #249398 Posted March 9, 2009 at 03:07 PM ola a todos, pessoal eu tou a fazer uma ligação a base de dados sql em vb.... a minha base de dados chama-se login.sdf. Faço o seguinte código: Dim cnn as New System.Data.SQLserverCe.SqlCeconnection cnn.connectionString = "Data Source = C:\caminho\login.sdf" cnn.open() Não da nenhum erro mas depois quando tento executar dá sempre este erro: The path is not valid. Check the directory for de database.[path=c:\caminho\login.sdf] Alguém me pode ajudar a resolver esse erro??agradecia imenso.... Link to comment Share on other sites More sharing options...
José Lopes Posted March 9, 2009 at 03:33 PM Report Share #249407 Posted March 9, 2009 at 03:33 PM assim de repente a connectionstring estará bem definida? http://www.connectionstrings.com/ Podes confirmar aqui Quando te pedirem peixe.... ensina-os a Pescar!!Hum..lálálálá!! Link to comment Share on other sites More sharing options...
mcosta Posted March 9, 2009 at 04:11 PM Author Report Share #249415 Posted March 9, 2009 at 04:11 PM olá e obrigado por tudo... eu fui ver o site que tu disseste e vi isto: Standard Data Source=MyData.sdf;Persist Security Info=False; How to specify the location of the SDF file Often times the .SDF database is not running in the current directory so it becomes necessary to programatically set the path to the SDF file. This is an example (.net C#) on how to do this when the SDF file is located in the same directory as the executing application.Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\MyData.sdf;Persist Security Info=False; eu uso uma base de dados .sdf e talvez devesse fazer a 2 hipotese ja que na standart dá erro!!! mas a segunda é para c#???certo!! é que se puser assim em vb da erro.. Link to comment Share on other sites More sharing options...
José Lopes Posted March 9, 2009 at 04:17 PM Report Share #249416 Posted March 9, 2009 at 04:17 PM o codigo que esta aí...pelo menos essa parte está mais ou menos transversal Quando te pedirem peixe.... ensina-os a Pescar!!Hum..lálálálá!! Link to comment Share on other sites More sharing options...
mcosta Posted March 9, 2009 at 04:29 PM Author Report Share #249420 Posted March 9, 2009 at 04:29 PM Sim!!! mas por exemplo eu pus assim: cn = New SqlCeConnection(Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection .Assembly.GetExecutingAssembly().GetName().CodeBas e)) + "\\login.sdf;Persist Security Info=False;) o nome da base de dados é login. mas dá erros na palavra Data Source; Error 2 Comma, ')', or a valid expression continuation expected. Error 1 'System.Data' is a namespace and cannot be used as an expression. Link to comment Share on other sites More sharing options...
mcosta Posted March 9, 2009 at 04:52 PM Author Report Share #249427 Posted March 9, 2009 at 04:52 PM acho que já defini bem a connectionString: Dim con As New SqlCeConnection Dim sqlcmd As New SqlCeCommand con = New SqlCeConnection("Data Source= " + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "C:\Documents and Settings\Marco\Os meus documentos\Marco Epralima\SM Aplication teste\SmartDeviceProject1\SmartDeviceProject1") con.open() No entanto quando executo continua a dar o mesmo erro!!! no con.open diz: the path is not valid Link to comment Share on other sites More sharing options...
jpaulino Posted March 15, 2009 at 08:13 PM Report Share #250891 Posted March 15, 2009 at 08:13 PM Vê estes exemplos: http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/3cf44321-ff1e-4903-ac2f-570f8759055a/ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now