Hi everyone,
Has anyone had succes making an OLE DB connection to MS SQL via php?
I have this link,
Dr. Dev
but I am having a "Server not found" issue and they show you how to save the connection string...
You can now copy and paste the connection string wherever it's required, for example:
<%
Set commInsert = Server.CreateObject("ADODB.Connection")
commInsert.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;
PersistSecurity Info=False;Initial Catalog=
YourDB;Data Source=YOUR_LOCAL_SERVER_NAME
strInsertCommand = "INSERT INTO tableName(TextField, NumericField)
VALUES('ABCDE', 12345);"
commInsert.Execute(strInsertCommand) ' Execute the insert command
commInsert.Close()
Set commInsert = Nothing
%>
But I am not familar with what language this script is now.
Anyone have any suggestions?
Thanks,
Don
