Mysql og mssql
Jeg har hentet et forum på nettet som er skrevet til access el. ms sql.Nu kører jeg mysql, men det burde vel heller ikke være det store problem. Der er en indstilningsfil med som her er vedlagt.
Jeg har ændret den sidste linie og får så fejlen
Microsoft VBScript runtime error '800a01a8'
Object required: ''
Den kører fint nok med access
<%
'All global constants begin with capital GC.
CONST GC_DBTYPE = "SQL" 'This is set to the type of database you are using. ACCESS for Microsoft Access or SQL for Microsoft SQL Server.
Dim G_DBCONNECT 'This variable holds the connection string.
Dim sPath
'---------------------MS ACCESS CONNECTIONS---------------------
'sPath = Server.MapPath(".") & "\"
'sPath = Replace(sPath,"\cb-admin\","\")
'G_DBCONNECT = "DSN=commentboard"
'G_DBCONNECT = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="& sPath & "cbdata.mdb;DefaultDir="& sPath &";DriverId=25;FILE=MS Access;MaxBufferSize=512;PageTimeout=5"
'G_DBCONNECT = "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=" & sPath & "cbdata.mdb"
'G_DBCONNECT = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & sPath & "cbdata.mdb"
'-------------------MS SQL SERVER CONNECTIONS-------------------
'Replace the following parts of the connection string below:
'SQLSERVER - name of your SQL Server
'DATABASE - name of the database in SQL Server. We suggest using CommentBoard
'USERNAME - username for the database.
'PASSWORD - password for the above user.
'G_DBCONNECT = "Provider=SQLOLEDB; Data Source=SQLSERVER; Initial Catalog=DATABASE; User ID=USERNAME; Password=PASSWORD;" 'This holds our database connection string.
G_DBCONNECT.Open "Driver={mySQL};SERVER=mysql01.cliche.dk;UID=xxx;PWD=xxx;DATABASE=xxxx;Port=3306;Option=131072;"
