The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I'm in the process of moving server to hostgator and struggling to get a connection, I have an existing access db, which connection string should I use? Attached is a pic of the odbc options I can setup.
Eventually I hope to go over to mysql so any help with that connection would be appreciated too, I've tried all options so far with no joy.
Thanks in advance.
Here are the server specs.
Windows Server 2016
Windows IIS 10
Plesk Panel 17.5 for Windows
MSSQL Server 2016 Web Edition
MySQL Server 5.6
MySQL Connector 5.3
Access Databases 2007, 2010
ASP Classic, ASP.NET 2.0, 3.5, 4.0, 4.5, 4.6 & 4.7
PHP 5.2.17 through PHP 5.6.39, PHP 7.0.33
Python, SSI (Optional)
cURL, GD Library, MVC 2.0/3.0/4.0/5.0, AJAX
AwStats, SmarterStats
MSFTP 10.0
URL Rewrite 2.0
SmarterMail Mail Server 15
Eventually I hope to go over to mysql so any help with that connection would be appreciated too, I've tried all options so far with no joy.
Thanks in advance.
Here are the server specs.
Windows Server 2016Windows IIS 10
Plesk Panel 17.5 for Windows
MSSQL Server 2016 Web Edition
MySQL Server 5.6
MySQL Connector 5.3
Access Databases 2007, 2010
ASP Classic, ASP.NET 2.0, 3.5, 4.0, 4.5, 4.6 & 4.7
PHP 5.2.17 through PHP 5.6.39, PHP 7.0.33
Python, SSI (Optional)
cURL, GD Library, MVC 2.0/3.0/4.0/5.0, AJAX
AwStats, SmarterStats
MSFTP 10.0
URL Rewrite 2.0
SmarterMail Mail Server 15
Posted
You should choose microsoft access driver, you would then use the 'connection name in the' config.asp file.
you will need to use this setting in config.asp and replace the name with the one you have created, make sure you comment out your existing connection and uncomment this one.
'strConnString = "snitz_db" '## DSN
you will need to use this setting in config.asp and replace the name with the one you have created, make sure you comment out your existing connection and uncomment this one.
'strConnString = "snitz_db" '## DSN
Posted
Thanks Huw
I tried that but keep getting:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
A hunt around seems to suggest a 32/64 bit issue on the server, I have raised a ticket with them.
I tried that but keep getting:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
A hunt around seems to suggest a 32/64 bit issue on the server, I have raised a ticket with them.
Posted
yes sounds like it, classic asp is 32 bit and they probably have 6bit drivers installed
Posted
Found a setting in my user control panel to allow 32bit applications and it works!
Next...
I'm wanting to go over to mysql at some point and keep getting the following error when I change the config file for sql:
[MySQL][ODBC 5.3(w) Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
The 'forum' dsn setting connects ok when I test it in my control panel, what does this mean? How do you include a password in the string? This what I am sing to get this. strConnString = "forum" '## DSN
[MySQL][ODBC 5.3(w) Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
The 'forum' dsn setting connects ok when I test it in my control panel, what does this mean? How do you include a password in the string? This what I am sing to get this. strConnString = "forum" '## DSN
Posted
You'll need to check with your host about that