Jeg har et problem med
SUN!
FEJLMELDING:ADODB.Connection.1 (0x80004005)
SQLState: IM002 Native Error Code: 0 [DataDirect][ODBC lib] Data source name not found and no default driver specified
min connection til databasen ud:<%
set rsDesign = server.createObject("ADODB.connection")
rsDesign.open "SELECT * FROM tblSettings", conDatabase
%>Men fandt den her:
Here is an example using Microsoft Access:
A DSN called "access1" is made via setsqlnk and has been tested to work. It is now referred to as SqlnkDSN.
Make a DSN in odbc.ini that uses SqlnkDSN:
[ODBC Data Sources]
access_db=example access database
[access_db]
Driver=/opt/casp/lib/YYslk13.so
Description=Sqlnk Driver for Access
SqlnkDSN=access1
LogonID=username
Password=passwd
Database=c:testdbdb.mdb
UidPwdMapping=0
EnableScrollableCursors=1
The connection string in ASP would look like:
db.Open "DSN=access_db"
Adding more parameters in the ASP connection string will override the odbc.ini settings:
db.Open "DSN=access_db;Database=c:accessaccess.mdb;UID=user2;PWD=passwd2"
?? Men ved ikke hvordan jeg bruger den?
håber ikke det er for meget.
KimH