MeratusHost.com

To Connect to CRYSTAL REPORT PROBLEM :(?

I am trying to connect to Web Hosting SQL SERVER via CRYSTAL REPORT. I am chosing Microsoft Ole Db provider for Sql Server. And i am writing my Server information same as IP number.(For example 123.456.789.012) and i am writing my user name , password and also database_name. But i have a error (SQL State:08001,ConnectionOpen(Invalid Instance) ). But i can connect easly from my Microsoft Sql Server Management Studio. Why Crystal Report can not connect?

Public Comments

1. Are you attempting to do this as a .Net or Java SDK application or thru a Crystal Reports desktop tool? Which version of Crystal Reports? What is your complete environment? Years ago I ran into a similar problem. I had problems when the IP address was being treated as a number instead of an IP address. Have you tried adding an entry to your hosts file and then connecting to your SQL Server database using your new alias? e.g. add an entry to hosts file similar to this... 123.456.789.012 mydbhostname and then connect to mydbhostname instead of 123.456.789.012. The info at this URL has an easy solution assuming you are developing a SDK solution... http://66.129.67.4/p/1275147/2433596.aspx#2433596 ... change from ConnectionInfo.ServerName = "server" to ConnectionInfo.ServerName = "ip address" And here's another place where someone solved a similar problem although Crystal Reports wasn't involved. Details can be found at: http://support.unify.com/supportforum/viewtopic.php?f=27&t=1614 Hope this info gets you quickly to the solution. Jeff