| Author |
 Topic  |
|
|
RhinoOffRoad
New Member
USA
71 Posts |
 Posted - 22 July 2006 : 14:43:01
|
while attempting to upgrade my board from an access db to a mysql db, i see that microsoft offers ms sql "express" free. is this an option for my board?
thanks, |
Nathan In Montana
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 22 July 2006 : 15:18:17
|
what is required to support it? im not using a host, im running my own dedicated windows 2003 server.
thanks, |
Nathan In Montana
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 July 2006 : 15:43:18
|
| You'd need to download and install it. Unfortunately I have no knowlegde on SQL Server Express Edition, in terms of the tools that come with it, so I won't be able to provide further support. Also, on the Microsoft SQL Server site you should have complete info on the Express Edition. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 22 July 2006 : 16:26:21
|
i downloaded and installed the sql express as well as the .net framework 2.0. everything installed fine with no errors, but when i attempt to run the setup i get the following error:
here is how ive configured my config.asp:
strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'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
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
strConnString = "driver={SQL Server};server=collierwelding;uid=user;pwd=pass;database=glock" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=user;password=password;DATABASE=forumdb;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
sorry for all the questions, but as has been stated the strength of snitz is the available support, and im totally new to this db stuff (sheesh....using access was so easy, to bad its to slow) so ill need more im sure.
thanks, |
Nathan In Montana
|
|
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 22 July 2006 : 16:27:47
|
btw, if its an issue of creating the sql db, i see no option for that in ms sql express.
thanks, |
Nathan In Montana
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 22 July 2006 : 18:10:50
|
quote:
Originally posted by ruirib
Did you create the database and then added a login and added that login as a user for that database?
no, i dont know how to do any of that. any help in learning how would sure be appreciated. |
Nathan In Montana
|
|
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 22 July 2006 : 18:46:14
|
| currently downloading Microsoft SQL Server Management Studio Express, will update later. |
Nathan In Montana
|
|
|
| |
Topic |
|
Topic Locked
