dalekad
Posts: 5
|
Posted: 01/22/2004, 5:49 AM |
|
im using the employee example in code charge studio in asp and i want to connect to the database simpliy
e.g. like the following code
Set [CONN NAMEHERE] = Server.CreateObject("ADODB.Connection")
Set [RSET NAMEHERE]= Server.CreateObject("ADODB.RecordSet")
dbDepts.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & _
Server.MapPath("[DB PATH HERE]")
sql = "[SQL HERE]"
[RSET NAMEHERE].Open sql,[CONN NAMEHERE],3
tryed to do the connection in code charge like this but have an errror like
Error information:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Other possible cause of this problem:
The database cannot be opened, most likely due to incorrect connection settings or insufficient security set on your database folder or file.
For more details please refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518
can anyoine please help me to fix this error to get this working would be greatly apperated
|
|
|
peterr
Posts: 5971
|
Posted: 01/22/2004, 11:47 AM |
|
Your own answer has the link/URL to information about this error. Please click on it.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
dalead
|
Posted: 01/22/2004, 12:03 PM |
|
i had looked
unfortunally it dosent help me to fix the error (im useless at coding)
|
|
|
peterr
Posts: 5971
|
Posted: 01/22/2004, 12:38 PM |
|
Oops. I didn't see that you're not even using DSN.
OK. Tell me then if you want to connect to your database somewhere inside a page created with CCS, or are you trying to replace the standard method that CCS uses to connect (in Common.asp)?
How will you use this connection?
Also take a look at some of our examples that show how to connect to a database: http://docs.codecharge.com/studio/html/ProgrammingTechn...eCustomSQL.html
Like:
Set Connection = New clsDBConnection1
Connection.Open
Connection.Execute(SQL)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
dalekad
Posts: 5
|
Posted: 01/22/2004, 12:52 PM |
|
im jusrt trying to get a simple adodb connection to work and trying to alter the connection that has been set up
|
|
|
peterr
Posts: 5971
|
Posted: 01/22/2004, 12:56 PM |
|
I'm still not sure what this means, but if you want to alter the standard CCS connection, you can search Comon.asp for "ConnectionString =" and change it there.
See: http://support.codecharge.com/kb_article.asp?article_id=54
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
dalekad
Posts: 5
|
Posted: 01/22/2004, 1:00 PM |
|
the connection i mentiod in my firsr post on this topic is the one i want to use
|
|
|
peterr
Posts: 5971
|
Posted: 01/22/2004, 1:06 PM |
|
But as you've seen it doesn't work.
I offered you help with creating a working connection, but if you cannot use it then I don't know what else I can propose. There are probably no other options...
You should probably contact for support whoever gave you that code.
BTW, this issue is not realted to CCS, thus you can test your connection outside of CCS (in any .asp program), then once you get it to work with the help of the person who gave it to you, then put it back into CCS.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|