One of my testers is testing my program that imports an XML file and puts all the data into correct fields in an Access database. He said on his Vista laptop he got an error saying: "Microsoft.jet.OLEDB.4.0 provider is not registered on local machine"
I know you don't have to have Access installed to run my program and I'm pretty sure all the OLEDB objects are in the .NET framework so why is it saying that?
I cannot find the place to change my cpu to x86. When I follow the instruction in the MSDN library help, there is no option to change from 64 bit to x86.
The program will allow me to attach the database and preview the file, but after compiling the file and starting the application I ge an empty database.
i used this code (below) but it have error on this line "dAdapter2.Fill(dSet2, "BPC_EMPLOYEE")"
Dim ConnectionString As String = "Server=bpc-k2;Database=FIXED ASSET DISPOSAL;Integrated Security=SSPI"
Dim mySQLConn As New SqlConnection(ConnectionString)
mySQLConn.Open()
[code]....
every time i try to establish a data connection between vb 2010 and sql 2005 i get the following error message QuoteA network-related or instance specific error occurred while establishing a connection to SQL server.the server was not found or was not accessible .verify that the instance name is correct and that SQL server is configured to allow remote connection .(Provider:SQL network interface,error:26
View 6 Repliesconnect vb.net 2008 to sql 2005 database.
View 1 RepliesI'm trying to connect to a sql server 2005 database. I'm using the following connection string.
Dim cnn As OleDbConnection = _
New OleDbConnection("Provider=sqloledb;Integrated Security=SSPI;Initial Catalog=Iconics")
Using this connection gives me the following error :
Error : Microsoft OLE DB PROVIDER FOR SQL SERVER : [DBNETLIB][Connection open(connect()).]SQL Server does not exist or access denied.
Does anybody know what is wrong with this connection string.
I can connect to both databases with SQL Server Enterprise Manager, so I know the servers are up and available. One of them is SQL1, the other is SQLTEST.In my program when I use the following connection string, it work connects just fine:
conn = New DBConnect("Data Source=SQL1;Initial Catalog=SignInspection;Integrated Security=SSPI")
However, if I change SQL1 to SQLTEST the connection times out I don't get any errors other than the timeout error.I can run the profiler on SQLTest and see that it is most definitely NOT even attempting to connect.
EDIT:Well, it's a moot point now because I got authentication working properly on our SQL1 server.
First off, the web server is running IIS and .NET. Users are logged in to the intranet using Active Directory, and the .NET page needs to retrieve their log-in credentials (username most notably). The database is SQL Server 2005, running on a different machine. But the .NET app needs to impersonate as another user to connect to the database.
To successfully do both of these things go to Windows > Run, enter inetmgr and hit run. Navigate to the site and right click > properties, then click on the tab titled Directory Security, click Edit.., make sure only Integrated Windows Authentication and Digest authentication are enabled. Enter your proper AD realm and click OK. Apply the settings/hit OK.In web.config you need the following lines
<authentication mode="Windows" />
<identity impersonate="true" username="myDomainMyUserName" password="123mypasswordgoeshere">
replacing, of course, myDomainMyUserName and 123mypasswordgoeshere with the username and password that has login rights on both your domain and your sql server. The connection string can probably be modified, but this is mine and it works:
Server=SQL1;Database=SignInspection;Trusted_connection=True;
I would like to connect my database to a treeview. Here is my code so far. It is connecting BUT i have problem. SEE the image below
[Code]...
The image below is showing my problem. The Groups are all shown. I would like to see 2A , 3A, 4A ...(so only ONE 2A) .and so on... and then click on the node to open with all the students in that group...
i got a probleam with database connection. check my coding. For info i am using server sql 2005 and microsoft visual studio 2005. I also highlight the which cause me a probleam..
[Code]...
I want to connect an access dabase from a central server using vb.net 2005.
View 1 Replieshow to write a web to connect SQL 2005 database by having the SQL sa password in the config in encrypted formatted.
View 1 RepliesI do need to connect oracle database via odbc in my vs 2005 project. I have no idea how to connect, kindly give me connection string codes and prerequisites.
View 7 Repliescurrently i am create windows application form for staff registration for my assignment, this form is contain textbox which are connected to database.Every time i run this form ,i can see data in the textbox ,which is from column in my table database.My question is how i can make the textbox is blank every time i run my staff registration form.I dont want that data which i save in database is been seen because this form is use to add new data in database.i am using visual studio 2005 and sql 2005.Here i attach some picture when i run my form application, there is data in every textbox.
View 2 RepliesI have been learning about working with databases and VB. I have coded the connection string for a MS Access database to my VB project but i cannot establish a connection with my sql mdf database.
The code i used to connect to MS Access is:
<Dim dt As New DataTable()/>
<Dim match As String = ""/>
< Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
[Code]....
What is the connection code in order to manipulate data from the mdf file. Is it similar to the above code.
i am new with SQL server 2005 and visual studio 2008.how do i connect the forms and the tables in the database
View 4 RepliesHow can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 Repliesi compile my form with the below code when i run it on vista work fine without any problem but when i try to run in on XP cant run... that happened with any XP machine.[code]when i run my exe to other Vista machines work fine... but on xp NO.
View 1 RepliesI am migrating to win vista from xp, I have an half completed program in XP , so i wanted to know whether i would be able to continue its development in vista or not. and an another question, whether my program which will be developed on vista can run on xp and vice versa?
View 1 RepliesI have a program that modifies the boot.ini on windows XP.However the problem is windows Vista went to the BCDEDIT utility the boot.ini was eliminated. The BCDEDIT tool is a command line tool.IS there a way to program vb.net to use bcdedit and pass several different commands to it so that I can make the same changes in Vista I want to change to these values from there defaults
Timeout =1
and
noexecute = AlwaysOff
How can I do this ?
I am trying to deploy an SQL Server 2005 WPF application on Vista. Database connection is failing. Can someone tell me on what to do. The app deploys well on other operating systems.
View 6 RepliesI have an app written on an xp pc which I want users to run on Vista
The app needs to delete a file on a portable drive in a particular folder
This folder was created on the xp machine and copied to the portable drive
The app will not delete a file in this folder on Vista but it will on xp
When I check folder security on vista (which does not exist on xp) I find that the folder does not have full control assigned
my app will write a file to that folder & delete it but will not delete a file put there from the xp pc
If I change the security in vista to full control it works
what I want to do is see if the folder has full control when the user selects it and advise them they need to alter security as I can not do it in the program
basically I want to advise them the moment they select the folder, not when it fails to delete the file after entering misc details in the app which are reuired before the file is deleted.
i want to give windows vista look to my windows forms. I am using vb.net 2005.
View 2 RepliesI have a program runs with access database. It runs ok on WINXP. However, when I run it on Vista, it shows this exception: system.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
I searched, it seems the exception has some relations with 64bit OS, but my vista is 32bit home version.
right now, im using Windows Vista.. in Windows XP, deleting a file is working with this code System.IO.File.Delete("C: estdelete.jpg") But in Windows Vista, i encounter this message: Access to the path 'C: estdelete.jpg' is denied. why its happening? what is the solution for this?
View 14 Repliesi have a problem a in vb.net in Windows Vista Basic environment, while using the chr(0) it gives an empty string, while in windows XP chr(0) gives the following character am wonderign why in windows vista it can't result to the same thing actually it amounts to NOTHING as the result.
View 5 RepliesI am writting an application that stores data in an Access database. I can't put the files in the Program Files directory since standard users can't write to that folder. I can't use a 'user' folder since multiple users will need to access the same file. In addition to accessing the file, users on occassion will copy new versions of the file into the folder, overwritting the old file.Where should I put this file? I am thinking the ProgramData folder, but when I create that folder during the install, it is also read-only for a standard user.I'm lost as to where I should put a file that can be accessed by multiple users, that is read/write, and I can install the folder into the location. I don't think I have a programmatic way of installing a file into the Public users folder.
View 1 RepliesI posted this as a bug on MS Connect and am wondering if anybody else can verify the problem: I been beating my head against the wall for about 3 days and I don't think it is my problem.
Desktop computer - Vista 64 bit
Portable Computer - Vista 32 bit
vb.net 2010 express on both of them
I can not establish a connection to an Access db (either .mdb OR .accdb) on the 64 bit computer. When I try I keep getting a message that says "Format at the initialization string does not conform to specification starting at index 0." (this was typed not copied). (There are screen shots over on Connect).
I can establish a connection to a "Microsoft SQL Server Compact Edition" (.sdf) database on the 64 bit computer.I can estabish a connection to all 3 types on the 32 bit computer (.sdf, .mdb, .accdb).The 'funny' thing is that if I establish the connection on the 32 bit and copy the program directory over to the 64 bit, the prorgam loads and seems to run fine. But the %$# _(%* Wizard will not run on the 64 bit machine. Runs fine on the 32 bit but not on the 64 bit. Of course I make sure that the db's are in the location where the program expects them to be when I run the program on the 64 bit machine.
One final thing, when I am in the progam created on the 32 bit and running on the 64 bit and I try Data->Add New Data Source->Database->Dataset only two of the three connections show up while all 3 show up on the 32 bit machine. Also the connection string is incorrect for the non-sdf connection. It should include
I'm working on a tool that allows the user to connect to his SQL database and edit some of the database values.First here's a screenshot of the GUI (you can see my problem as well):
[Code]...
I am been working on an a small app that has a Forms.Webbrowser control that navigates to a Adobe Flash program. I have developed the app on Vista 32bit platform and have had no problems. I have sent the app to a couple of people to test out and one is using Vista 64bit and is running into a problem. I know the webbrowser control just uses the underlying base framework of IE. The problem on the 64 bit machine is when the site is navigated to it says that it needs to have Flash installed. When the user goes to Adobe's site it says they need to use a 32bit browser.
As stated on Adobe site here:[URL] the Flash player need to be in a 32 bit browser. What options do I have to be able fix this problem? Is there another control that I can use that would be the same in a 32bit platform and 64bit platform? Besides navigating to the Flash program, the browser also goes to standard web pages.
how to connect vb 2005 with access data base file using with ADODB is below code is correct
[Code]...
