September 25, 2012 at 11:48 am
Hello to all. I have installed SQL Server 2005 Developer Edition and Visual Studio 2005 Standard Edition on my Windows 7 machine using the 64 bit mode. This has created the following problems:
1. I am unable to use the Access databases because there is no Jet 4.0 64 bit driver available for OleDb Connections.
2. I left my Visual Studio 2003 side by side but here I have no trouble connecting to the Access Database but I am unable to connect to the SQL Server Databases because VS 2003 is 32 bit and the SQL Server is 64 bit.
Do I need to re-install SQL Server 2005 Developer Edition using the 32 bit mode so that I will be able to connect to both Access and SQL Server databases with the same program? I need to do this to be able to complete the exercises in "Microsoft ADO.NET 2.0 Step by Step, Author: Rebecca M. Riordan". Otherwise, I plan to re-create my Access Database (I have about 9 of them) in the SQL Server and in the future I will just use SQL Server databases.
I built my Windows machine one component at a time. It has Dual Core 2.5 GHz CPU's, 4 GB Memory, about 700 GB space on three hard drives.
Thank you and have a good day. JRichards54 🙂
September 25, 2012 at 12:04 pm
jrichards54 (9/25/2012)
Hello to all. I have installed SQL Server 2005 Developer Edition and Visual Studio 2005 Standard Edition on my Windows 7 machine using the 64 bit mode. This has created the following problems:1. I am unable to use the Access databases because there is no Jet 4.0 64 bit driver available for OleDb Connections.
2. I left my Visual Studio 2003 side by side but here I have no trouble connecting to the Access Database but I am unable to connect to the SQL Server Databases because VS 2003 is 32 bit and the SQL Server is 64 bit.
Do I need to re-install SQL Server 2005 Developer Edition using the 32 bit mode so that I will be able to connect to both Access and SQL Server databases with the same program? I need to do this to be able to complete the exercises in "Microsoft ADO.NET 2.0 Step by Step, Author: Rebecca M. Riordan". Otherwise, I plan to re-create my Access Database (I have about 9 of them) in the SQL Server and in the future I will just use SQL Server databases.
I built my Windows machine one component at a time. It has Dual Core 2.5 GHz CPU's, 4 GB Memory, about 700 GB space on three hard drives.
Thank you and have a good day. JRichards54 🙂
Can you use ADODB instead of OLEDB?
I don't understand what you mean at all with second issue. Are you saying you can't connect to your database with Visual Studio? Do you have a single program that is connecting to both Access and SQL Server? This shouldn't be an issue at all. There are some details missing but in general it sounds like you have some configuration/connection string issues. You should be able to make all those connections you are discussing.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 25, 2012 at 1:37 pm
"Can you use ADODB instead of OLEDB?
I don't understand what you mean at all with second issue. Are you saying you can't connect to your database with Visual Studio? Do you have a single program that is connecting to both Access and SQL Server? This shouldn't be an issue at all. There are some details missing but in general it sounds like you have some configuration/connection string issues. You should be able to make all those connections you are discussing."
Sir, I am a newbie when it comes to SQL Server. I am familar with Access Databases as I was the Assistant Instructor for two Access Database classes on Smart Planet and I have been using Access databases for several years now. BUT I do not know the term "ADOBD" so I do not know if I can use it or not.
Yes, I have a program which uses radio buttons to select either OleDb or SQL Connections and then displays their connection strings in a textbox. The program also test the Opening and Closing of the connnection to the database. Where should I be able to make all those connections I am discussing"? In which Visual Studio? Not VS 2005 because it does not support the Jet Engine. So it must be that I should be able to make both of these connections in one program in VS 2003. Is that right? If so, I will try to resolve the "configuration/connection string issues". Thank you for the help and have a good day. JRichards54 🙂
September 25, 2012 at 2:23 pm
jrichards54 (9/25/2012)
"Can you use ADODB instead of OLEDB?I don't understand what you mean at all with second issue. Are you saying you can't connect to your database with Visual Studio? Do you have a single program that is connecting to both Access and SQL Server? This shouldn't be an issue at all. There are some details missing but in general it sounds like you have some configuration/connection string issues. You should be able to make all those connections you are discussing."
Sir, I am a newbie when it comes to SQL Server. I am familar with Access Databases as I was the Assistant Instructor for two Access Database classes on Smart Planet and I have been using Access databases for several years now. BUT I do not know the term "ADOBD" so I do not know if I can use it or not.
Yes, I have a program which uses radio buttons to select either OleDb or SQL Connections and then displays their connection strings in a textbox. The program also test the Opening and Closing of the connnection to the database. Where should I be able to make all those connections I am discussing"? In which Visual Studio? Not VS 2005 because it does not support the Jet Engine. So it must be that I should be able to make both of these connections in one program in VS 2003. Is that right? If so, I will try to resolve the "configuration/connection string issues". Thank you for the help and have a good day. JRichards54 🙂
Here is an article from connectionstrings.com that discusses using jet in a 64bit environment. http://www.connectionstrings.com/Articles/Show/using-jet-in-64-bit-environments
I just created a new Access database in Office 2010 32 bit. I added a single table (Table1).
Then in Studio 2010 I created a new Windows Forms project. I added System.Data as a reference.
I created a new form with a dataGridView (dataGridView1) and a button (button1). I added "using System.Data.OleDb". On the button click event I open Access and bind the grid to Table1. Here is the entirety of the code.
private void button1_Click(object sender, EventArgs e)
{
string ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ConnectionTest.mdb;User Id=admin;Password=;";
OleDbConnection conn = new OleDbConnection(ConnString);
conn.Open();
OleDbCommand command = new OleDbCommand("Select * from Table1", conn);
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
DataTable dt = new DataTable();
adapter.Fill(dt);
dataGridView1.DataSource = dt;
}
Hope this helps.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 25, 2012 at 4:03 pm
Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books to help me to understand how to use them both. If my problem requires VS 2010 for a resolution then I am out of luck. I will just have to stay with what I have already invested my money for. HAGD, JRichards54 🙂
September 25, 2012 at 4:08 pm
jrichards54 (9/25/2012)
Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books to help me to understand how to use them both. If my problem requires VS 2010 for a resolution then I am out of luck. I will just have to stay with what I have already invested my money for. HAGD, JRichards54 🙂
That code should work exactly as is in studio 2005. There is nothing in there that is not available in 2005. I even had set the target framework as .NET 2.0
Try to put that together in 2005 and it should work just fine. 🙂
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 26, 2012 at 9:07 am
Sean Lange (9/25/2012)
jrichards54 (9/25/2012)
Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books to help me to understand how to use them both. If my problem requires VS 2010 for a resolution then I am out of luck. I will just have to stay with what I have already invested my money for. HAGD, JRichards54 🙂That code should work exactly as is in studio 2005. There is nothing in there that is not available in 2005. I even had set the target framework as .NET 2.0
Try to put that together in 2005 and it should work just fine. 🙂
Thank you SSCertifiable (Sean Lange) for your excellent advice. You said: "Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions". I have not only read this article I have captured it and saved it to my hard drive under "How To:" and I also printed it out so that I would be able to read it again when the need arises.
Now, I will try to duplicate your code in my VS 2k5 and if I do it successfully, I am sure I will get the results that you say it will. JRichards54 🙂
September 26, 2012 at 9:09 am
Sean Lange (9/25/2012)
jrichards54 (9/25/2012)
Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books to help me to understand how to use them both. If my problem requires VS 2010 for a resolution then I am out of luck. I will just have to stay with what I have already invested my money for. HAGD, JRichards54 🙂That code should work exactly as is in studio 2005. There is nothing in there that is not available in 2005. I even had set the target framework as .NET 2.0
Try to put that together in 2005 and it should work just fine. 🙂
Thank you SSCertifiable (Sean Lange) for your excellent advice. "Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions". I have not only read this article I have captured it and saved it to my hard drive under "How To:" and I also printed it out so that I would be able to read it again when the need arises. JRichards54 🙂
September 26, 2012 at 9:24 am
jrichards54 (9/26/2012)
Sean Lange (9/25/2012)
jrichards54 (9/25/2012)
Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books to help me to understand how to use them both. If my problem requires VS 2010 for a resolution then I am out of luck. I will just have to stay with what I have already invested my money for. HAGD, JRichards54 🙂That code should work exactly as is in studio 2005. There is nothing in there that is not available in 2005. I even had set the target framework as .NET 2.0
Try to put that together in 2005 and it should work just fine. 🙂
Thank you SSCertifiable (Sean Lange) for your excellent advice. "Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions". I have not only read this article I have captured it and saved it to my hard drive under "How To:" and I also printed it out so that I would be able to read it again when the need arises. JRichards54 🙂
You are welcome. Another pretty cool thing about this site is the Briefcase. There is a link to it right after My Account at the top. Anytime you are reading a thread and you want to keep it handy you can click the Add to Briefcase button. It is a great way to find some of this stuff more easily.
Let me know if that code works for you. If not I can probably help tweak it into submission. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 27, 2012 at 10:52 am
"Let me know if that code works for you. If not I can probably help tweak it into submission."
I have created a database in ACCESS and named it "ConnectionTest.mdb" with a single table(Table1). I created a new form with a "DataGridView" and a button (button1). I added "Import System.Data". I then typed the code that you furnished exactly to the best of my ability. I compiled the program and got 12 errors. I have managed to eliminate one of the errors so I am now try to eliminate the other 11 so that the program will compile and run.
I have had many things going on (such as my daughter needing to use my computer to re-submit her resume. I share my computer room with my 9 year old granddaughter and she has to be in bed by 8 PM so I cannot use my PC after about 7 PM. Had both physical therapy and nurse vising me twice a week plus doctors appointments. Just letting you know why I do not respond immediately to your very fine posts. Give me a little (maybe not so little) time to work out the 11 compiler errors (I learn a lot by working out compiler errors) and then I will get back with another report. Thank you for your help. JRichards54 🙂
September 27, 2012 at 12:10 pm
jrichards54 (9/27/2012)
"Let me know if that code works for you. If not I can probably help tweak it into submission."I have created a database in ACCESS and named it "ConnectionTest.mdb" with a single table(Table1). I created a new form with a "DataGridView" and a button (button1). I added "Import System.Data". I then typed the code that you furnished exactly to the best of my ability. I compiled the program and got 12 errors. I have managed to eliminate one of the errors so I am now try to eliminate the other 11 so that the program will compile and run.
I have had many things going on (such as my daughter needing to use my computer to re-submit her resume. I share my computer room with my 9 year old granddaughter and she has to be in bed by 8 PM so I cannot use my PC after about 7 PM. Had both physical therapy and nurse vising me twice a week plus doctors appointments. Just letting you know why I do not respond immediately to your very fine posts. Give me a little (maybe not so little) time to work out the 11 compiler errors (I learn a lot by working out compiler errors) and then I will get back with another report. Thank you for your help. JRichards54 🙂
Take whatever time you want/need. If worse comes to worse I can just upload the .cs file from my project. You can just add that a project in your solution and it should be good to go.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 2, 2012 at 11:46 am
I currently have VS 2003, VS 2005 and SQL Server 2005 installed on my machine. VS 2003 is 32 bit, VS 2005 And SQL Server 2005 are 64 bit. Will I be able to also install the 32 bit version of SQL Server 2005 side by side? If it is OK to do that, I assume the new 32 bit installation will get a different "Instance" name and I will be able to use it by logging on to that Instance. Is that right? Jim Richards54
October 3, 2012 at 12:20 pm
jrichards54 (10/2/2012)
I currently have VS 2003, VS 2005 and SQL Server 2005 installed on my machine. VS 2003 is 32 bit, VS 2005 And SQL Server 2005 are 64 bit. Will I be able to also install the 32 bit version of SQL Server 2005 side by side? If it is OK to do that, I assume the new 32 bit installation will get a different "Instance" name and I will be able to use it by logging on to that Instance. Is that right? Jim Richards54
I honestly don't know. I have never tried to install the 32bit version of sql on a 64bit machine. Why would you want or need to? Assuming you can install it then yes it would have to be a named instance.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply