After reading the instructions and reading the previous helps in the forum, I am still having problem getting the forum to connect to the sql server. I even tried the filename.udl trick. The udl file connected but when I took that string back to the config.asp file it didn't work. Also so that you know, I am running coldfusion 5 server on this webserver. Would this be a problem for some reason? I know that you can run both asp and cfm on the same webserver even in the same website. So please let me know what I need to do to get this fixed. Thanks.
Do you have your server configured for SQL Server Authentication? Is the login associated with the user you're specifying at the setup page configured to use SQL Server Authentication?
Yes I think so. Maybe I can give the ip and u can TS in the box and look at the setup.
strConnString = "driver={SQL Server};server=WEB_SERVER;uid=cnewman;pwd=****;database=DEA" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
I already a pretty big DB running for the current site that I am setting up this forum for. http://dea.integmedia.com I dont have problem connectin to the DB through coldfusion. I am thinking it is simply the connection string but it could be the setup of SQL sever as well. I am open to anything to get this fixed.
What do you mean TS? Can Enterprise Manager be used? If you feel OK with it, email me the server data. You can use the send to post icon above this message to email me.
Never been able to connect to my SQL server via Enterprise manager. I want to, makes life easier. Just sent u an email with the IP address and account login info.
'## Make sure to uncomment one of the strConnString lines! 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
Your forum is setup. The problem was the SQL Server was running in Windows NT authentication only. I changed it to Windows NT and SQL Server authentication and it worked immediately.
Topic Locked
Posted - 13 July 2002 : 07:23:37
