| Author |
 Topic  |
|
|
snowbird30ds
Starting Member
United Kingdom
33 Posts |
 Posted - 19 November 2020 : 08:02:16
|
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 |
Edited by - snowbird30ds on 19 November 2020 08:21:23 |
|
|
HuwR
Forum Admin
United Kingdom
20579 Posts |
Posted - 19 November 2020 : 08:36:13
|
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 |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
 |
|
|
snowbird30ds
Starting Member
United Kingdom
33 Posts |
Posted - 19 November 2020 : 08:58:44
|
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. |
Edited by - snowbird30ds on 19 November 2020 11:15:22 |
|
|
|
HuwR
Forum Admin
United Kingdom
20579 Posts |
|
|
snowbird30ds
Starting Member
United Kingdom
33 Posts |
Posted - 20 November 2020 : 15:43:51
|
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 |
|
|
|
HuwR
Forum Admin
United Kingdom
20579 Posts |
|
| |
Topic |
|
Connection string problems
