VB .NET Database question (Program says it can't find database file)?
355324
Hey Kevin - \n\nYour db path looks like it points to a mapped drive. And, that mapped drive may be a USB &#92; Flash drive. My suspicion is that there-in lies your problem.\n\nIf it is a mapped drive & you are able to stick it on the local drive do that just as a test to make sure your code works. You will need to change the connection string.\n\nIf the code does work & you can access the database from a local drive then you've got security or drive caching issues.\n\nMake sure that your code & the user account it is running under has permissions to the drive & folder. If it is a windows app then it is running under your own account.\n\nIf it is a flash drive make sure it doesn't have any security features&#92;software on it. Disable them when you run your code. \n\nIf it is a mapped drive keep in mind that it has to be set to reconnect when you log into the machine. And that it shouldn't be using a special account to log into that drive. \n\nRememeber - mapped drives are a per user concept. When the user logs out, the mapped drive reference goes away. If you have multiple users using this path they all have to use the same drive letter name. Mapped drives can fail in web apps and windows service apps even if it appears the mapped drive exists. As soon as you log out that mapping is gone. \n\nI really hope this helps. I don't have an IDE on the computer I'm on so I didn't really get to look at your code. If you really get stuck please feel free to contact me. \n\ngood luck
119728
What error message are you getting? Please specify and add to message. =) \nreply:\ntry looking first in C:&#92;Program Files&#92; for the Visual_Net (or simmular) dir, and from there search for the control file
386908
What file type does Superworks save the database as?\n\nEg. Access in .mdb\n\nTry just opening the database file in Access.
158375
Dim fso\n' the following line says Scripting dot FileSystemObject\nSet fso=CreateObject("Scripting.FileSystemObject")\nIf fso.DriveExists("S:") Then\n    MsgBox "Does exist!"\nElse\n    MsgBox "Doesn't exist!"\nEnd If
226102
It's not entirely clear what you're trying to do here ... but it sounds as though you want to use the MS Access Workgroup Security which modifies the system.mdw file associated with any Access database you may open / use.  I'd avoid using that strategy with a VB application.  If this is a network environment, create a table in the target database which can be used to store the network user id for anyone you want to allow access to the application and data.  Then use the Windows API to read the user id when the application is launched - then validate the user id against your user id table and permit or deny based upon the result.\n\nHere's some code snippets that may help (Good luck!):\n\nPublic strUser As String\n\nPublic Declare Function WNetGetUser Lib "mpr.dll" Alias "WNetGetUserA" _\n    (ByVal lpName As String, ByVal lpUserName As String, lpnLength As Long) _\n    As Long\n\nConst NoError = 0\n\n******************************\n\nSub GetUserInfo()\n\nConst lpnLength As Integer = 255\nDim lpName, lpUserName As String\nDim status As Integer\n\nlpUserName = Space$(lpnLength + 1)\n\nstatus = WNetGetUser(lpName, lpUserName, lpnLength)\n\nIf status = NoError Then\n    strUser = Left$(lpUserName, InStr(lpUserName, Chr(0)) - 1)\nElse\n    strUser = "Unknown"\nEnd If\n\nEnd Sub
1027306
If you can connect to the database in Dreamweaver, try connecting to it with Access and see if you can modify a table or execute a query.  It's either a permissions issue with your database file, a permissions issue with the webserver that the file is on, or something quirky.  I'd suggest turning off Friendly error messages in IE 6 so it can (hopefully) give you some good feedback.  \n\nI'm a bit confused when you say "seems that all database stuff... are not working properly when viewing". So none of your select statements are returning values either? Seems like a config issue.
497310
After draggin the file into Excel, your database will take only one column.\nSelect that column and go to Data > Text to columns to start the wizard you need to convert it.\n\nXLMan
347994
dim cn as adodb.connection\ncn.open "..."\n\ncn.execute "update tablename set update='" & now & "' where id='xxx' "\n\ncn.close
15588
This may sound like a foolish question, but: are you sure you're entering a program executable file?  Just be sure you're using the right filename.\n\nAlso, depending on the program, you may need to type the entire file path to it.
1117893
The MSSQL server is a database, and if you didn't install it yourself it might have been installed as a requirement for some other software you installed. Has anything changed on the system - new installation or removal of software? Its probably not a problem, and it might cause more issues trying to remove it.
146901
right. \n\nas i am doing a degree and have come across this question myself in my VB unit.\n\ni was told by my lecturer;\n\nif you are still using VB6 - i am afraid you are going to have to start moving to VB.net..\n\nVB.net can do some of what VB6 can, but there are some things it cannot do.\n\nVB6 is becoming less used and VB.net more common.\n\nNow would be the time to move to VB.net. You will find some things similar and being able to do some things like you will be used to, but many things will be new.\n\nsorry i cannot help anymore - i cannot find my lecture notes on this.
534142
Microsoft's knowledge base has an excellent article on this exact topic.  The gist is that you open an OleDbConnection on an Excel file (if I remember correctly it will create the file if you attempt to open a connection on a file that does not exist) and then issue it database commands.
609067
Renaming it to .exe won't work, the file is a Microsoft Access Database file, if you rename it to .exe then the computer has no idea what to do with it, since it is not actually an executable program.\n\nAccess databases are meant to be used from within Access. You can develop a frontend application in ColdFusion, Visual Basic and plenty of other programming languages and then use your access database as a backend to store the actual data in.\nOther then that your going to need to use Access in order to use your program as it is right now.
992894
Access is fully programmable, and easy to set up for small databases.  You could probably do this yourself.  I'm not sure you will find an actual "Lost and Found" database, but morelikely find an inventory control or the like.
1153431
There's data adapters built-in to .NET for SQL Server.  Assuming you know how to use data adapters, you can find it as "SQL Data Adapter" in the toolbox in Visual Studio under the "Data" heading.  From here you can set your SQL commands manually or have the wizard do it for you (I strongly recommend doing it manually if you know how).\n\nI'm assuming that the tables are still on an SQL Server?  If not, I imagine you could use an ODBC adapter (you could do this if the files are on the SQL Server as well, but the first method would be easier).
3079
Are the pages in the database also asp.net pages?  if they are stright client side script then all you need is a response.write..\n\nif not.. I don't think you can do this.   the only thing I can think of would be to use an EVAL function on the page.. but that might choak on the HTML..  \n\nbut.. if I might ask.. why do you want to do this?  perhaps you need to rethink your solution to make a better engine for your pages.. that why your DB is only storeing DATA.. like it's supposed to.
838522
goto this site for VB.Net and C# :\nhttp://www.samspublishing.com/articles/article.asp?p=31560&seqNum=1&rl=1\n\ntry to find for ASP in internet, i'm too sleepy right now.\n\nbtw, why didn't you open the sample source code from VB and ASP, there's must be a sample source code with 2 or more form.