|
try this
<br />
dim constring as string = "Data Source=.\SQLEXPRESS;AttachDbFilename=" & application.startuppath & "\LIB.mdf;Integrated Security=True;User Instance=True"<br />
connect with this string
Note : after exiting application you need to click on server explorer and right click lib.mdf database and click on close connection and copy lib.mdf and lib.log files from debug folder to back to lib folder. otherwise you will not get the changes and the file will be overwritten with the old one when you are running your application again
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
Hi
When i try the constring u suggested i am getting another error at the point of cn.open, the error is as :
DriveLetter:\Project Folder\bin\Debug\LIB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
what is this error about i cant understand.
|
|
|
|
|
Either that path doesn't exist or Sql Server already has that database attached. Use the SQL Server Management Studio to see if it's listed under the Databases folder in the Object Explorer.
|
|
|
|
|
Hi thx for reply.
as u suggested i serched it in sql server mgmt studio under databases but it is not listed there.
|
|
|
|
|
just add msgbox(constring) in my previous code after constructing constring. and run the application. varify that the message you are getting is pointing to the exact location of your database
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
I tried this and also got the database path correct but still i m getting the same error msg about auto-named and UNC share.
|
|
|
|
|
what is exactly you are getting about autonamed and unc shares ?
the error you are getting about the database name already exist is because it is already attached to sqlserver. if you have connected your database in server explorer, try to detach it and run this program error, i am not getting this error when i tried here. if this problem still exist after you detach db try after installing visual studio sp1
Vilsad P P
MCTS (Windows Applications) .Net 2.0
|
|
|
|
|
The |DataDirectory| portion of the AttachDbFilename path is only usable if your database file is in either the Data folder of the SQL Server Program Files folder or when using ClickOnce Deployment - I can't remember which.
You have to replace this with the full path to your database .MDF file for the connection string to work. If your database is in your applications .EXE folder, you can do something like this to get it work:
Dim dbPath As String = Path.Combine(Application.StartupPath, "mydatabase.mdf")
Dim connString As String = String.Format("Data Source=.\SQLEXPRESS;AttachDbFilename={0};Integrated Security=True;User Instance=True", dbPath)
|
|
|
|
|
hi
Thxs for u r reply.
Can u plz tell what is the key word "Path.combine"
because when i m writing the string u told about a message is displayed "Path" is not declared .
So let me know ,do i have to import some namespace or what should i do.
Regards
|
|
|
|
|
The Path class is defined in the System.Io namespace.
Stick this at the top of your code:
Imports System.Io
|
|
|
|
|
Hi by including IO class the error was removed but now i m getting this
error at the point of cn.open, the error is as :
DriveLetter:\Project Folder\bin\Debug\LIB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
what is this error about i cant understand.
|
|
|
|
|
Hi,
I have a need to send some data from database to a word template.
Do any body have any idea about it.
Example: If i have a word file as certificate.doc (with images and text)
and at particular occurance of a word as <name> the text has to change with the data in the database table.
Any help... plz
Jats
|
|
|
|
|
You would probably have better luck getting this question answered if you asked in a forum that specialized in Word Interop, like this one[^] on MSDN.
|
|
|
|
|
Hi,
Thanks for the suggestion found a way.
Jats
|
|
|
|
|
Hi to all.
I am Having Some difficult to grabe from serial port (VB Communication) and to save data in an access database.
if someone could help me in this topic,by a simple example or a source code in VB6.
Thanks in advance
|
|
|
|
|
There's tons of examples out on the web. All you have to do is Google for "vb6 serial port", or click[^].
|
|
|
|
|
Hi All,
I want to capture incoming / outgoing raw-packet of NIC card.
And redirect/block packet for porn site etc.
I am VB6 coder and have no idea for C/C++.
Can somebody help me in this regards.
Sunil KC
from NEPAL
|
|
|
|
|
Sunil KC wrote: I want to capture incoming / outgoing raw-packet of NIC card.
And redirect/block packet for porn site etc.
I am VB6 coder and have no idea for C/C++.
Can somebody help me in this regards.
Well, time to start learning C, because to do this you'll need to write an NDIS driver and you can only do that in C or C++. Well, you can also do that in assembly, but I guess you won't want to do that.
|
|
|
|
|
can somebody help me by making a ndis driver with dll
|
|
|
|
|
There's no chance of this happening. You need a ton of driver development and kernel-level dugging skill to do this. From the sound of your question, you don't have to skills to pull this off yet.
|
|
|
|
|
Alternatively, if you are in a corporate network environment, you could write a proxy that all machines must go through in order to access the internet.
|
|
|
|
|
You can already do this with off-the-shelf software, it's called a proxy server.
|
|
|
|
|
Hi, Our project which has been developed on .net2002 is working fine. Now I have introduced some drop down list in search modules of the projects. They also working fine in the local system but in the server, ddlist are not getting filled with the data present in database. And also i want to introduce some more page to it. They are all working fine in local system. but when i copy them to server where the original project has been deployed, it is giving the following error. Now the project is been enhancing using, .NET 2005
Server Error in '/dbs' Application.
--------------------------------------------------------------------------------
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type 'Dash_Board.TimeSheet'.
Source Error:
Line 1: <%@ Page Language="VB" AutoEventWireup="false" Inherits=".TimeSheet" CodeBehind="TimeSheet.aspx.vb" %>
Line 2:
Line 3:
Source File: D:\Deljo\DBS\TimeSheet.aspx Line: 1
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
Chaitra N
|
|
|
|
|
You'll probably get a better response if you asked this question in the ASP.NET Forum.
I'm no ASP.NET expert, but what's with the period in the Inherits=".TimeSheet" code? I don't think that period shouldn't be there.
|
|
|
|
|
Hey guys,
I have a quick question that I am hoping someone can answer for me. What I am trying to do is create VB.Net service that navigates to a page in the background every five minutes. What i am trying now is that i am using the Web Browser Control and in my start code i am using WebBrowser1.Navigate("URL Addres"), but once i go to install and run the service it gives me a Thread Exception error.
Does anyone know the answer, please help because I have tried several things and none of which have worked.
Thanks, Travis
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
