Data Source Wizard for SQL [modified]
-
I know how to connect to a database on a networked machine using C# code directly, thats pretty simple. But I'm trying to use things like data grid forms that have to just select the data source. Using the Data Source Wizard I can't figure out how to tell it to connect to machine X, database X, pass X, username X just like I would using code. It keeps insisting I connect it directly to a database file, which isn't shared. Am I missing some REALLY obvious answer? -- modified at 17:15 Thursday 1st June, 2006 C# Express 2005 Doesn't have this feature?
-
I know how to connect to a database on a networked machine using C# code directly, thats pretty simple. But I'm trying to use things like data grid forms that have to just select the data source. Using the Data Source Wizard I can't figure out how to tell it to connect to machine X, database X, pass X, username X just like I would using code. It keeps insisting I connect it directly to a database file, which isn't shared. Am I missing some REALLY obvious answer? -- modified at 17:15 Thursday 1st June, 2006 C# Express 2005 Doesn't have this feature?
What type of database are you connecting to? I'd assume based on your comments so far that it's an access database in which case you must specify the a valid network path to the database, e.g.
\\machineX\c\database.mdbin the connection string, the username and password can also be specified in the string if requried.
You know you're a Land Rover owner when the best route from point A to point B is through the mud. Ed
-
What type of database are you connecting to? I'd assume based on your comments so far that it's an access database in which case you must specify the a valid network path to the database, e.g.
\\machineX\c\database.mdbin the connection string, the username and password can also be specified in the string if requried.
You know you're a Land Rover owner when the best route from point A to point B is through the mud. Ed
"data source wizard for SQL" is the topic, so I'm not connecting to access =P I just got a full copy of 2005 from work and solved my problem. I dont think the data objects are predefined and all that in Express for a server connection.