database connection problem

I

indiateam

Guest
Hi,

Trying to add the database but can't do it. Error benig given is that 'OLE DB - SQL Server not found' can u tell me the sql server name to which i can connect and export my database
 
I read a lot of questions here about SQL database connection trouble... the old hosting company I was with had these questions too. You know, not everything has to be a DSN connection. Some would say a DSN-less connection is even faster. Here's an example DSN-less connection string on Jodohost. It uses mssql2.jodohost.com because that's what was documented and it works for me:

"Provider=sqloledb;Data Source=mssql2.jodohost.com;Network Library=DBMSSOCN;Initial Catalog=yourDatabaseName;User ID=yourDatabaseLogin;Password=yourDatabasePassword;"
 
Oh, I'm sorry. We recently added a new windows server. So if you are hosted on win2.jodohost.com, you need to use mssql2.jodohost.com not mssql.jodohost.com
 
When JodoHost offers hosted databases (waaaay more efficient) for free, why dont you use that instead of creating ODBC connections?
 
What do you mean by "hosted databases?" Thier SQL servers are located in their local network so it's pretty much as fast as it can be. Without a direct SQL link driver, you are pretty much restricted to an ODBC connection. Now, the only question is if you want it to be connected through a DSN definition, or configured on-the-fly in your code using a DSN-less connection. As you can see from my code example, I am using Microsoft's OLE SQL driver (sqloledb) so this combination should be just about as fast as anything. Now the only potential bottle-necks are in the code's possible inefficiencies.
-Dave
 
I think what Mike means is that you can create one MS SQL database directly from the control panel and directly administer it through Enterprise Manager. You get a port number, host name and login details for that database. You can even use that database then for your own software by connecting to it using those login details so it is not just limited to your web use.

I dont know how it is more efficient nor do I know how to connect to such a database in my code. All I know is this type of database is used in a multi-client environment where maintenance software or other websites (on other servers) must connect to it too.
 
Yes, you can use Enterprise Manager (and/or iSQL) locally to administer your database, but I'm not sure how you would otherwise do it...?
For those of you interested in this, simply create a database ID and password in HSphere, then use Microsoft Client Network Utility (which was installed with the rest of the client utilities) and add a TCP/IP Alias to mssql.jodohost.com or mssql2.jodohost.com or wherever. Then, in Enterprise Manager, simply reference that Alias name (with correct user ID and password) when registering a new SQL server. You can see any SQL server published on the Internet this way, so long as you have an ID and password.
-Dave
 
How do you specify a port in the DSN from Do you mean create an ODBC link to SQL Server from your ColdFusion 5.0 Administrative site I have no way to change the default port. Help.
 
indiateam said:
Hi,

Trying to add the database but can't do it. Error benig given is that 'OLE DB - SQL Server not found' can u tell me the sql server name to which i can connect and export my database

Tell me exactly
 
Back
Top