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