Forums
This topic is locked
dreamweaver data connection
Posted 06 May 2007 23:12:10
1
has voted
06 May 2007 23:12:10 rudy grimsky posted:
Hi.I have a problem....
I'm using dreamweaver 8 to create asp code and database connection but the server has some conflict when dreamweaver try to generate asp code or ODBC...
Help me please!!!
Replies
Replied 06 May 2007 23:49:03
06 May 2007 23:49:03 Javier Castro replied:
Check this link to create a dsn-less connection rather than ODBC connection. It is much better :
www.ultradevguru.com/tutorial/dsnless.htm
www.ultradevguru.com/tutorial/dsnless.htm
Replied 08 May 2007 09:13:03
08 May 2007 09:13:03 satheesh Dominic replied:
can you explain what is the error message that is shown in the browser.... the text you omitted after "when dreamweaver try to generate asp code or ODBC..."
If you can get the error message we might be able to find some solution to that
If you can get the error message we might be able to find some solution to that
Replied 08 May 2007 19:10:59
08 May 2007 19:10:59 rudy grimsky replied:
I don't have an error message.
When I try to connect the database, dreamweaver works opening the small windows writing ODBC but nothing appen...so in the server nothing happen!
Could be the server that is not good for dreamweaver?
In the meanwhile I'm trying to find another sever good for dreamweaver...
When I try to connect the database, dreamweaver works opening the small windows writing ODBC but nothing appen...so in the server nothing happen!
Could be the server that is not good for dreamweaver?
In the meanwhile I'm trying to find another sever good for dreamweaver...
Replied 11 May 2007 11:16:47
11 May 2007 11:16:47 satheesh Dominic replied:
IIS is very good enough to use with dreamweaver. Once you are able to config "manage sites" properly,you can make use of IIS & its script support.
To create DSN you have to go to system's control panel and then you have to go to "Administrative Tools" then "Data Sources (ODBC)" then go to the "System DSN" TAB. Then click ADD button and then choose the driver (Driver Do Microsoft Access) then click finish. Now give a name for your DSN and then browse and select the "*.mdb" file you want to use as the database to which the particular DSN name has to connect.
(You can also Define the DSN by clicking Define button on the DSN wizard window that appears when you click to add "Data Source Name(DSN)".
If your new DSN does not appear in the list items. Please do open the "Data Source Name(DSN)" wizard once again from the database tab from the Application panel. you can find your new dsn appearing in the list. (Forget not to define your DSN in the SYSTEM DSN tab)
After this go to "Application" Panel and choose the Database tab. Click PLUS icon and choose "Data Source Name (DSN)".Select the "using Local DSN" Radio button. choose from the list of System DSNs available on your system ( in this list you can find your newly defined DSN too) then give a name for that connection. Now click "Test" (if there is password pls fill that and the username).
If the DSN is connected Successfully, we get the message saying "Connection was made Successfully". Now you can make use of this DSN and create applications.
If the Test is not Success, that means there are some errors on the DSN defined. Please check for any possible errors that can happen while defining the SYSTEM DSN.
If you know all these very well....Pls leave this reply for others
To create DSN you have to go to system's control panel and then you have to go to "Administrative Tools" then "Data Sources (ODBC)" then go to the "System DSN" TAB. Then click ADD button and then choose the driver (Driver Do Microsoft Access) then click finish. Now give a name for your DSN and then browse and select the "*.mdb" file you want to use as the database to which the particular DSN name has to connect.
(You can also Define the DSN by clicking Define button on the DSN wizard window that appears when you click to add "Data Source Name(DSN)".
If your new DSN does not appear in the list items. Please do open the "Data Source Name(DSN)" wizard once again from the database tab from the Application panel. you can find your new dsn appearing in the list. (Forget not to define your DSN in the SYSTEM DSN tab)
After this go to "Application" Panel and choose the Database tab. Click PLUS icon and choose "Data Source Name (DSN)".Select the "using Local DSN" Radio button. choose from the list of System DSNs available on your system ( in this list you can find your newly defined DSN too) then give a name for that connection. Now click "Test" (if there is password pls fill that and the username).
If the DSN is connected Successfully, we get the message saying "Connection was made Successfully". Now you can make use of this DSN and create applications.
If the Test is not Success, that means there are some errors on the DSN defined. Please check for any possible errors that can happen while defining the SYSTEM DSN.
If you know all these very well....Pls leave this reply for others