|
attaching an Access Database -- Cerebrus --
What problem are you facing in that, Parasyke ? Seems like a simple enough task... ;-) Dragging an OleDbConnection object from the Toolbox (Data tab) should do it for you. |
|
-- Sevinfooter --
Go to Tools --> Connect to Database It pops up the connection dialogue. Click the Provider tab, and select Microsoft Jet4.0 OLE DB Provider and click Next On the next tab, you can choose the location of the Access DB and put in any authentication you have for the DB. Click next and select permissable operations, and you should be about done. Click OK. If you don't see the Server Explorer, click on View, and select ServerExplorer. It should be available now, like the toolbox, and you can make it autohide or sticky. |
|
-- Parasyke --
Hi, I went under Computer Management|Services and found this: Sqlagent$NETSDK with the full path listed as: C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\Binn\sqlagent.EXE -i NETSDK and Startup type manual. |
|
-- Parasyke --
Hi, still baffled by a simple concept: I have an Access database on my desktop and want to see it as a server connection in my VB Studio .net 2003 Standard Edition. I've tried and I can't seem to get anywhere. |
|
-- Parasyke --
I can get as far as seeing the table objects as I now have a connection, but when I see an error when I click those table objects: "Records Cannot Be Read No read Permission on Table" Also my ultimate goal was to get to these through MSDE as I'm assuming this is the only way to run commands in VB.net code like: Pub Sub New(Byval DbName As String) sqlconn = New SqlConnection( _ "data source=(local);" & _ "initial catalog="Northwind" & _ "integrated security=SSPI") This, correct me if wrong, is the .NET standard for connection for doing things like turning the data into XML for moving across the internet. This is just the textbook verbage this newbie sees for all the Northwind examples in the .NET books. Pardon my pleading but few of the .NET textbooks go into detail as to how to do the actual MSDE, etc. routine to get the data to start with. Thanks for any more help! |
|
-- Parasyke --
I'm just basing it on a 2003 book by Dan Maharry called "Beginning VB .NET 1.1 Databases: from Novice to Pofessional" ISBN 1-59059-358-8. Sure I was able to see the tables through OleDbConnection but I could not see data. I'm not sure what happened since my attempt (prior to a PC crash months ago), but Dan's routine worked perfectly months ago and now I can't get back to that point. Please be patient with me, I'm just looking for clues as to where this failed. |
|
-- Cerebrus --
I have an Access database on my desktop and want to see it as a server connection in my VB Studio .net I'm simply trying to view my MS-Access database tables and stored procedures from my Visual Studio .NET 2003 Standard Edition (VB). I don't understand at all. You're trying to access an MS Access database, so why are you installing MSDE and using an SqlConnection object ???????? That is for SQL Server. Use an OleDbConnection. Read my previous post. It contains all the info. required to get you going. There was one error however... Instead of dragging an OleDbConnection, drag an OleDbDataAdapter. It will configure your connection as well. |
|
-- Tito --
Cerebrus is correct. You seem to be mixing up two different connections. If you use a MSDE, you can use SQL connections. But if you want to hit an Access database, OleDBConnection is the way to go. Examples can be deadly if you don't fully understand what the example is doing. Make sure you are not just a code copier...it will be your downfall. |