ron

ron

  • NA
  • 2
  • 0

Connection String using ASP.NET C# trying to connect my Access DB to my site on Dreamweaver.

Apr 5 2006 12:08 AM

I am having problems connecting my database to my site in Dreamweaver. 

4 Steps  
1.Create a site-done
2. Choose a document type -Asp.net c#
3. Set up site's testing server -done
4. Create a Connection by clicking on + button above.

I click + in the Databases tab.  I choose OLE DB Connection instead of SQL since it's an Access DB.  I then name it a connection name conn_1  Does this need to be a specific name?  In connection string, I choose "Build" It takes me to the Data Links Properties window with 4 tabs, "Provider", "Connection", "Advanced", and "All".  In the "Provider" tab, I choose Microsoft Jet 4.0 OLE DB Provider.  Right?  I click Next to the "Connection" tab.  It says, "Specify the following to connect to Access data:
 1. Select or enter a database name: - I click the browse icon and find my DB on my local root. 
in the path to my DB, there are 2 folders with spaces and apostrophes in the Folder name, does that matter? 
 2. Enter information to log on to the database: - Blank Password is checked.
I then test the connections and Wa La, connection successfull.
I don't know what the "Advanced" and the "All" tabs do in the Data Link Properties window mean but I just click o.k.
This takes me back to the OLE DB Connection window where the Connection String area is now populated with this

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source="C:\etc\etc\.mdb";
Persist Security Info=False

I then click Test and ERROR.  Format of the initialization string does not conform to the OLE DB specification. 
??????????????

I click o.k. out of the error window, o.k. out of the OLE DB Connection window and now, the Databases tab in Dreamweaver has a yellow square icon with conn_1. (what I called my connection)  But when I expand to see what's in it, "Stored Procedures", "Tables", and "Views" are all None. 

Anyone? Anyone?  I've been stuck on this for days.  I've also tried using other strings like

[Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb] - inputing my path of my database on my C:\ drive as Data Source, Right?

This comes back with the error.. [Microsoft][ODBC Driver Manager] Data source name too long.

I also tried using the string example on godaddy's help but it doesn't work. 

Am I having these problems connecting because I'm choosing ASP.net c#?  I have a book asp, cold fusion, and php for dreamweaver 8, but when I get to the connection string in this exact spot, it only shows what to do if using asp, cold fusion, or php, not .net c#.  I tried online and can't find anything except my own post I posted a week ago.

Anyone out there that might know what they are doing please advise.  I greatly Appreciate it.
Ron