OLE DB Server Selections

[adam_alsop2]

Could someone please advise where Crystal gets the drop-down selections for Server when you select an OLE DB data source? I'd like to have my commonly used DBs available for selection, but they do not appear there and I have to copy/paste them each time.

Many thanks!

[Former Member · Accepted solution]

Actually it all depends on the driver you've selected. If you're using the SQL Native Client, it will make a quick scan of your network looking for any servers that are running a copy of SQL Server... and that's what gets displayed in the server list for that particular driver.

If the SQL Server is a named instance, you'll still have to know the instance name (it will only show the server name)

If you use the same DB's over and over again, you can add them to your Favorites folder in the Available Data Sources: section of the Database Expert.

HTH,

Jason

[adam_alsop2 · Accepted solution]

I usually select the native client, but the only server that ever shows is one that I neither use nor have access to (which I thought was odd as well). They are named instances - different ports on the same server (for DEV, UAT, etc).

I'll try the Favorites and see how that works.

Thanks!

[Former Member · Accepted solution]

Using the native client, the server itself should be showing up. It's just not going to show the different named instances on that server. There may be a setting on either the server os or the SQL Server that prevents it from being discovered across the network. ("Allow remote connections" setting could be a culprit...)

Anyway, as long as you know the SeverName\InstanceName you're looking for and it's allowing you to connect, no biggie. The Favorites will be exactly what you're looking for.

Jason